Home » RDBMS Server » Performance Tuning » pstart and pstop
pstart and pstop [message #341138] Sun, 17 August 2008 00:38 Go to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
hello all,

In one of my explain plan i could see the pstart and pstop columns . Iam not sure what they are and why they are!!
Can any one let me know its impact and its importance in the plan

thanks,
ab
Re: pstart and pstop [message #341139 is a reply to message #341138] Sun, 17 August 2008 00:40 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
HUH?

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above
Re: pstart and pstop [message #341145 is a reply to message #341138] Sun, 17 August 2008 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Re: pstart and pstop [message #341152 is a reply to message #341138] Sun, 17 August 2008 04:37 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Yeah Mike Iam aware of that note,Actually I was looking at some examples on that note... CAn any one please help me out ?

thanks,
AB
Re: pstart and pstop [message #341154 is a reply to message #341152] Sun, 17 August 2008 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you want more? There are a dozen examples about partition in this chapter.
Please, do not be just aware of it, read and study it.

Regards
Michel
Re: pstart and pstop [message #341155 is a reply to message #341138] Sun, 17 August 2008 05:18 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
:- ) Cool and thanks. I could get what I was desired from an article in web.

thanks,
Razz
Re: pstart and pstop [message #341171 is a reply to message #341155] Sun, 17 August 2008 08:51 Go to previous message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It should be cool to post the link to this magical article.

Regards
Michel
Previous Topic: Query Performance
Next Topic: Gather Schema stats
Goto Forum:
  


Current Time: Wed Dec 07 06:46:26 CST 2016

Total time taken to generate the page: 0.14342 seconds