| is tuning necessary or not. [message #64931] |
Tue, 09 March 2004 20:33  |
bhavin shah
Messages: 11
Registered: November 2003
|
Junior Member |
|
|
hi friends,
presently I have seen my library cache parameter as below.
NAMESPACE ( PINS-RELOADS)/PINS
--------------- -------------------
SQL AREA .98769462
TABLE/PROCEDURE .99291405
BODY .99920477
TRIGGER .96562836
and i have query v$sgastat to check free memory..
NAME BYTES
-------------------------- ---------
free memory 14599820
suggest me ragarding tuning is necessary or not..
bhavin
|
|
|
|
| Re: is tuning necessary or not. [message #64936 is a reply to message #64931] |
Wed, 10 March 2004 23:29  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
These ratios are basically meaningless. Yours is obviously fine - as they will provide any manager with a fuzzy warm feeling that the database is performing well (which might or might not be true).
Most important is that you have sufficient space left in your shared pool should Oracle want to allocate more memory to the library cache. You might want to ensure that this remains true over peak processing periods.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
