Re: Determine value of SHARED_POOL_RESERVED_MIN_ALLOC

#1

Terry Dykstra <dontreply_tddykstra (AT) forestoil (DOT) ca> schreef in berichtnieuws
5NEKa.9304$ZS3.1115781 (AT) news2 (DOT) telusplanet.net...

Quote:

In 8i this parameter is hidden. But in reading techdoc 146599.11 it
mentions this parameter to help diagnosing ora-4031 (which I'm running
into). I'm running 81741 SE and need to determine what the current value
is
of shared_pool-reserved_min_alloc. How do I do that?

--
Terry Dykstra
Canadian Forest Oil Ltd.

Have a look at http://www.ixora.com.au/scripts. First read the requirements.
Choose "parameters" to find a script that lists hidden paramters. Choose
"shared pool" to find some interesting scripts to investigate the shared
pool.
Also consider pinning large objects in the shared pool so they don't get
aged out (but you probably know about that already).
Check for fragmentation of the shared pool. When sql statements use literals
instead of bind variables they can cause big fragmentation troubles. If so
consider setting parameter cursor_sharing = force.
Read Metalink note 61623.1. It describes a query that shows what is flushed
out of the shared pool to get something loaded into it. A very nice X$ view:
after every select (!) it's empty again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Determine value of SHARED_POOL_RESERVED_MIN_ALLOC

comp.databases.oracle.server comp.databases.oracle.server

Re: Determine value of SHARED_POOL_RESERVED_MIN_ALLOC - 06-26-2003 , 01:20 PM