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.
--------------- -------------------
SQL AREA .98769462
BODY .99920477
TRIGGER .96562836

and i have query v$sgastat to check free memory..
-------------------------- ---------
free memory 14599820

suggest me ragarding tuning is necessary or not..

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: 4578
Registered: April 1998
Senior Member

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.

Previous Topic: LOG_BUFFER - Selects?
Next Topic: utlbstat, utlestat
Goto Forum:

Current Time: Thu Feb 22 02:38:51 CST 2024