Database Administration (MOSC)

MOSC Banner

OPEN_CURSORS instance wide vs. per session

edited Aug 11, 2015 10:09AM in Database Administration (MOSC) 2 commentsAnswered

We had the problem that we ran out of max open cursors with an instance. After increasing the number by using


alter system set open_cursors=1000 scope=both;

it worked (for a while). Now we again have a problem at the customer's site. I don't have a definite

error message yet, but may I ask here already a question:

Instance wide is the number of cursors set to 1000 with the above command.

Does this apply to any session/process?

I was using this to to obtain a picture. Would that be appropriate to analyze the problem?

SQL> select count(*) from v$open_cursor;

  COUNT(*)
----------
       572

SQL> select max(a.value) as highest_open_cur, p.value as max_open_cur
  2    from v$sesstat a, v$statname b, v$parameter p
  3    where a.statistic# = b.statistic#
  4    and b.name = 'opened cursors current'
  5    and p.name= 'open_cursors'
  6    group by p.value;

HIGHEST_OPEN_CUR
----------------
MAX_OPEN_CUR
--------------------------------------------------------------------------------

              47
1000


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center