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: 64103
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: Sun Dec 04 18:31:08 CST 2016

Total time taken to generate the page: 0.13304 seconds