Home » RDBMS Server » Server Administration » Execution plan - parameters (oracle 10.2.0.1.0 o/s:hp-ux:11.23)
Execution plan - parameters [message #388264] Tue, 24 February 2009 01:24 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

dear sir, 

while deriving the execution plan, what are the parameters ( from pflie )
are looked up by optimizer ?

Thank you,
kesavan.
Re: Execution plan - parameters [message #388273 is a reply to message #388264] Tue, 24 February 2009 01:48 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many, so many parameters and not only from pfile but from implied/derived/ajusted/... parameter values.

Regards
Michel
Previous Topic: session_cached_cursor
Next Topic: database growth size
Goto Forum:
  


Current Time: Mon Jul 24 19:48:06 CDT 2017

Total time taken to generate the page: 0.06411 seconds