DevTech101

DevTech101

How to increase Oracle Database log size

alter database add logfile size 600m;
alter database drop logfile group 1;
select l.group# , l.bytes , l.status , l.archived , lf.member from v$logfile lf , v$log l where lf.group# = l.group#;
alter system switch logfile;
alter system checkpoint;
alter database drop logfile group [ active log];

Change parallel

alter system set parallel_max_servers=8 scope=both; 
alter system set optimizer_adaptive_features=false scope=both;
show parameter adaptive;

Set parallel min

alter system set parallel_min_servers=0;
sho parameter parallel_min_servers;

Change SHARED_POOL_SIZE

alter system set SHARED_POOL_SIZE = 600M scope=spfile;
show parameter shared_pool_size;

Change session cached cursors

alter session set session_cached_cursors =500;

EM Default ports
Enterprise Manager port list
Use the following URL to access:

  1. Enterprise Manager Cloud Control URL: https://em1.domain.com:7799/em
  2. Admin Server URL: https://em1.domain.com:7101/console
  3. BI Publisher URL: https://em1.domain.com:9801/xmlpserver

The following details need to be provided while installing an additional OMS:

  1. Admin Server Host Name: em1.domaincom
  2. Admin Server Port: 7101

References
https://oracle-base.com/articles/13c/cloud-control-13cr1-installation-on-oracle-linux-6-and-7

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
%d bloggers like this: