ORA-4031 on 9.2.0.5

  • From: "Subbiah, Nagarajan" <Nagarajan.Subbiah@xxxxxxxx>
  • To: "'Oracle-L (E-mail)'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 19 Jan 2005 10:47:45 -0500

We are using oracle 9.2.0.5 on HP 11.11. The v$sgastat monitoring shows that
the 'shared pool miscellaneous' is keep growing and ORA-4031 occurs in few
days. The  session_cached_cursors, value is 128 and the open_cursors is 600.
What does the 'shared pool miscellaneous' refers to and any known bugs on
ORA-4031 on 9.2.0.5?
Any script is available for the pro-active monitoring and take some action
to avoid it before the application start throwing the error message?
Value of _kghdsidx_count is 2. Shared_pool_size was increased from 250M to
600M.

> Thanks,
> Raja


--
//www.freelists.org/webpage/oracle-l

Other related posts: