Friday, March 19, 2021

 

Oracle Enterprise Manager Cloud Control 12c Release 5 Installation on Oracle Linux 5.11 and 6.6





SQL> ALTER SYSTEM SET db_securefile = 'PERMITTED';

SQL>
begin
for c in (select sid, serial# from v$session) loop
   dbms_system.set_int_param_in_session(c.sid,c.serial#,'session_cached_cursors', 400);
end loop;
end;
/

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE=1G scope=both;

No comments:

Post a Comment

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...