How to check shared_pool_reserved_size

[cam_01]

Hi,

I have written a new parameter shared_pool_reserved_size
in init.ora file,my question is how to check it that it is working
smoothly.


Any ideas !

Thanks

[amar]

Select value from v$parameter where
name='shared_pool_reserved_size'; ??

-amar

[padmam]

Hi, 15th April 2001 14:31 hrs chennai

you can check for the parameter 'shared_pool_reserved_size' as follows.

1)Use the view v$shared_pool_reserved.

2)you can also set another parameter :

'shared_pool_reserved_min_alloc' in init.ora.

This parameter can allocate space from the reserved list if a chunk of memory of sufficient memory is not found on the shared pools free list.

3)Set the initial size of shared_pool_reserved_size as 10% of the shared_pool_size.


How to find the above parameter usage
==========================

1)When shared_pool_reserved_size is too small

Request_failures > 0 and one of the following is true.

I)LAST_FAILURE_SIZE>SHARED_POOL_RESERVED_MIN_ALLOC

II)MAX_FREE_SIZE < SHARED_POOL_RESERVED_MIN_ALLOC

III)FREE_SPACE < SHARED_POOL_RESERVED_MIN_ALLOC

then

Increase the SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE accordingly or

increase the SHARED_POOL_RESERVED_MIN_ALLOC but for this you have to increase the SHARED_POOL_SIZE

2)When shared_pool_reserved_size is too large

Too much of memory has been allocated to the reserved list if

I)REQUEST_MISS=0 or not increasing.

II)FREE_SPACE=>50% of SHARED_POOL_RESERVED_SIZE minimum.

then

Decrease the SHARED_POOL_RESERVED_SIZE or

Decrease SHARED_POOL_RESERVED_MIN_ALLOC (if not the default value).

for the columns mentioned above check those values in the v$shared_pool_reserved DD view.

Cheers

Padmam

[Edited by padmam on 04-15-2001 at 05:29 AM]