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

https://oracle-base.com/articles/12c/cloud-control-12cr5-installation-on-oracle-linux-5-and-6#software

https://oracle-base.com/articles/12c/cloud-control-12cr2-post-installation-setup-tasks

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;

How to change SESSION_CACHED_CURSORS for all sessions

Ask Question

The ALTER SYSTEM SET clause for this parameter is only valid with the SCOPE=SPFILE option, so you can not change the parameter value with this dynamically.

You can change the value for all other sessions, e.g as below:

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', 100);
end loop;
end;
/