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 Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...