How to change SESSION_CACHED_CURSORS for all sessions

2 votes

2 answers

41501 views

                          how Can I do to change SESSION_CACHED_CURSORS for all sessions?

I found on google and oracle website:

Alter Session... but I need to changed it for all the session and not only for one of them.

How can I do it?

UPDATE 1:

    SQL> alter session set session_cached_cursors=800 scope=both sid='*';
    alter session set session_cached_cursors=800 scope=both sid='*'
                                                 *
    ERROR at line 1:
    ORA-02248: invalid option for ALTER SESSION

Asked by jcho360 (2009 rep)

Dec 2, 2013, 07:24 PM
Last activity: Aug 13, 2021, 01:00 PM

How to change SESSION_CACHED_CURSORS for all sessions

Related Questions