OraFAQ Forum: Performance Tuning » _library_cache

Home » RDBMS Server » Performance Tuning » _library_cache_advice (Oracle 10g)

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

_library_cache_advice [message #581265]

Wed, 03 April 2013 16:18

gatetec
Messages: 38
Registered: December 2012

Member

Parameter                           Session Value                       Instance Value
----------------------------------- ----------------------------------- -----------------------------------
_library_cache_advice               TRUE                                TRUE

Sorry for this basic question!
What is exactly _library_cache_advice? and the impact from disabling (TRUE -> FALSE)?
I searched sources, but couldn't find a clear answer.

Report message to a moderator

Re: _library_cache_advice [message #581266 is a reply to message #581265]

Wed, 03 April 2013 17:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ANY & EVERY parameter that has a left most underscore character is "undocumented" & is reserved for EXCLUSIVE use by Oracle Corp.
Any change should only occur when directed to do so by Oracle Support.
You should ignore any & all of these parameters.

Report message to a moderator

Previous Topic:	Capacity Planning for 250 user OLTP shop
Next Topic:	Clarification on using awrrpti.sql script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 21 17:53:24 CDT 2025