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
Use the following URL to access:
- Enterprise Manager Cloud Control URL: https://em1.domain.com:7799/em
- Admin Server URL: https://em1.domain.com:7101/console
- BI Publisher URL: https://em1.domain.com:9801/xmlpserver
The following details need to be provided while installing an additional OMS:
- Admin Server Host Name: em1.domaincom
- Admin Server Port: 7101
References
https://oracle-base.com/articles/13c/cloud-control-13cr1-installation-on-oracle-linux-6-and-7