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: 183
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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 01 20:22:01 CST 2024