Oracle Enterprise Manager : Database Express 12c

 select dbms_xdb_config.gethttpsport() from dual;

 if NULL,
exec dbms_xdb_config.sethttpsport(5500);
==> Login: https://IP Addess:5500/em





Comments

Post a Comment

Popular posts from this blog

Remove the spurious CR characters The ^M is a carriage return character. Linux uses the line feed character to mark the end of a line, whereas Windows uses the two-character sequence CR LF. Your file has Windows line endings, which is confusing Linux. You can remove the spurious CR characters with the following command: sed -i -e 's/\r$//' 
Read more
[Enter Post Title Here] All About Statistics In Oracle In this post I'll try to summarize all sorts of statistics in Oracle, I strongly recommend reading the full article, as it contains information you may find it valuable in understanding Oracle statistics. ##################################### Database | Schema | Table | Index Statistics ##################################### Gather Database Statistics : ======================= SQL> EXEC DBMS_STATS.GATHER_DATABASE_STATS(      ESTIMATE_PERCENT=>100,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY',       CASCADE => TRUE,       degree => 4,       OPTIONS => 'GATHER STALE',       GATHER_SYS => TRUE,       STATTAB => PROD_STATS); CASCADE => TRUE  :Gather statistics on the indexes as well. If not used Oracle will decide whether to collect index statistics or not. DEGREE => 4 :Degree of parallelism. options:          =>'GATHER'  :Gathers statistics on
Read more
Change bytes into char inside data type of VARCHAR2   begin for r in     (select owner, table_name, column_name, data_length       from all_tab_columns       where data_type = 'VARCHAR2'        and char_used = 'B' and owner = 'SCHEMA') loop execute immediate 'alter table ' || r.owner || '.' || r.table_name || ' modify '  || r.column_name  || ' varchar2(' || r.data_length || ' char)'; end loop; end; / Note: Replace SCHEMA with owner of the tables
Read more