Home » RDBMS Server » Performance Tuning » is tuning necessary or not.
is tuning necessary or not. [message #64931] Tue, 09 March 2004 20:33 Go to next message
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 Go to previous message
Frank Naude
Messages: 4565
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
Previous Topic: LOG_BUFFER - Selects?
Next Topic: utlbstat, utlestat
Goto Forum:
  


Current Time: Wed Sep 30 11:43:52 CDT 2020