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
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.
Re: _library_cache_advice [message #581266 is a reply to message #581265] Wed, 03 April 2013 17:11 Go to previous message
BlackSwan
Messages: 22780
Registered: January 2009
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: Tue Sep 16 06:52:06 CDT 2014

Total time taken to generate the page: 0.11098 seconds