Re: sgastat miscellaneous

From: Scott Gamble <gambles_at_allegiance.net>
Date: Thu, 26 Jul 2001 19:28:40 GMT
Message-ID: <Ib_77.13$4H4.11279@e3500-chi1.usenetserver.com>

You didn't mention version number, but taking a stab in the dark on this one 8.1.7.1 has a memory leak involving the miscellaneous.

The bug number is 1397603, I don't think you can view the bug itself but if you search for 4031 and 8.1.7 you will return a good number of hits all describing the same problem.

Oracle made available a work around, and a 'one off' patch for it. Had to open a tar to get the patch.

The work around is to set _db_handles_cached = 0 in your init.ora, This stopped our problem with the same error.

When we upgraded to 8.1.7 from 8.0.6 we started getting these prety regularly, after the parameter change the problem went away.

Scott Gamble
"Stephan Bressler" <agadir_at_web.de> wrote in <9jodkf$qpk$1_at_news.mch.sbs.de>:

>Hi,
>
>our shared_pool ist 100MB. After a livetime of 20 hours new connections
>fail due to "cannot allocate 4096 bytes in shared pool".
>Looking at v$sgastat, miscellaneous keeps more than 70 MB.
>
>What's in this area? How can we get rid of if?
>
>TIA
>Stephan
>
>
Received on Thu Jul 26 2001 - 14:28:40 CDT