Re: Sporadic ORA-04030

Re: open cursors - A value of 60 should be normal, especially if your app uses pl/sql.
pl/sql uses its own cursor cache. So even if you close a cursor in pl/sql, it will
still show up in v$open_cursor. Based on LRU, the cached cursors are closed
before the max_open_cursors limit is reached.

So a value of 60 might actually be less if your app uses a lot of pl/sql.

Anurag Received on Fri Jan 21 2005 - 14:29:09 CST