Home » RDBMS Server » Performance Tuning » _library_cache_advice (Oracle 10g)
_library_cache_advice [message #581265] Wed, 03 April 2013 16:18 Go to next message
Messages: 38
Registered: December 2012
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.
Re: _library_cache_advice [message #581266 is a reply to message #581265] Wed, 03 April 2013 17:11 Go to previous message
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.
Previous Topic: Capacity Planning for 250 user OLTP shop
Next Topic: Clarification on using awrrpti.sql script
Goto Forum:

Current Time: Sun Aug 01 07:50:27 CDT 2021