OraFAQ Forum: Performance Tuning » db cache advice 10g

Home » RDBMS Server » Performance Tuning » db cache advice 10g (Oracle 10g, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db cache advice 10g [message #584620]

Thu, 16 May 2013 06:14

TRaj
Messages: 82
Registered: September 2006

Member

Hi,

Is db_cache_advice = ON still necessary when sga_target is set?

Thanks.

Report message to a moderator

Re: db cache advice 10g [message #584637 is a reply to message #584620]

Thu, 16 May 2013 08:15

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

Do not set the parameter, it dates back to release 9.0.1 and is not necessary since the statistics_level parameter was introduced in release 9.2. Do not set this either: the default is always correct.

Report message to a moderator

Re: db cache advice 10g [message #584695 is a reply to message #584637]

Thu, 16 May 2013 17:55

TRaj
Messages: 82
Registered: September 2006

Member

Thanks Watson.

Report message to a moderator

Previous Topic:	Oracle generates different execution plans for test and prod environments
Next Topic:	commit_write in 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 03:42:50 CDT 2023