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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 19 2005 - 10:52:24 CST
