Home » RDBMS Server » Performance Tuning » Explain Plan
Explain Plan [message #328671] Sat, 21 June 2008 09:23 Go to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Guys,

Any Idea why sometimes we will not get the tempspace column in the explain plan?

-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
-----------------------------------------------------------------------------------------

Arvind
Re: Explain Plan [message #328673 is a reply to message #328671] Sat, 21 June 2008 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
HUH?

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above
Re: Explain Plan [message #328683 is a reply to message #328671] Sat, 21 June 2008 10:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When temporary space is used.

Regards
Michel
Re: Explain Plan [message #328684 is a reply to message #328671] Sat, 21 June 2008 10:08 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Okey!!! Can that be estimated how much temp will be utilized when I actually run a query ?

Arvind
Re: Explain Plan [message #328686 is a reply to message #328671] Sat, 21 June 2008 10:20 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Also I was looking at the what all the default columns that can be displayed Ideally ....(pstop,Pstart ,temp , .....{All I know is these three ...}) ...Please help here.


Thanks Again,
Arvind
Re: Explain Plan [message #328691 is a reply to message #328684] Sat, 21 June 2008 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can that be estimated how much temp will be utilized when I actually run a query ?

"estimate" is the correct word.

Regards
Michel
Re: Explain Plan [message #328692 is a reply to message #328686] Sat, 21 June 2008 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Also I was looking at the what all the default columns that can be displayed

Database Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Re: Explain Plan [message #328758 is a reply to message #328671] Sun, 22 June 2008 12:04 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
thanks for the response!!!
but the "ESTIMATE" was irritating!!! Mad
Re: Explain Plan [message #328760 is a reply to message #328758] Sun, 22 June 2008 12:21 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
ArvindBhope wrote on Sun, 22 June 2008 10:04

but the "ESTIMATE" was irritating!!! Mad


Sounds like a personal problem.
Perhaps you benefit from a chill pill.
Previous Topic: slow server
Next Topic: Soft Close Cursor
Goto Forum:
  


Current Time: Tue Dec 06 04:51:44 CST 2016

Total time taken to generate the page: 0.24633 seconds