-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|