Hi All:

I need some suggestions in tuning of the DB.
I am using TOAD and monitoring the performance of the DB.
It hints me on three values.

1. parse/execution ratio
2. Library cache pin hit ratio (Shared pool is too small).
3. Library cache pin get ratio (dynamice or UnShareable sqll).


Here is the stats. collected on for librarycahe.

from v$librarycahce

NAMESPACE Hit ratio pin hit ra reloads
--------------- ---------- ---------- ----------
SQL AREA 72 85 173
TABLE/PROCEDURE 96 97 134
BODY 99 99 1
TRIGGER 99 99 2
INDEX 0 0 0
CLUSTER 99 99 0
OBJECT 100 100 0
PIPE 100 100 0


Pls. suggest me what to be done to have the alerts go off.

my SGA component is as follows

Total System Global Area 236896416 bytes
Fixed Size 73888 bytes
Variable Size 79355904 bytes
Database Buffers 157286400 bytes
Redo Buffers 180224 bytes


Shared_pool parameters


hi_shared_memory_address integer 0
shared_memory_address integer 0
shared_pool_reserved_size string 2621440
shared_pool_size string 52428800


thank u

srini