OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » pstart and pstop

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pstart and pstop [message #341138]

Sun, 17 August 2008 00:38

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

Report message to a moderator

Re: pstart and pstop [message #341139 is a reply to message #341138]

Sun, 17 August 2008 00:40

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: pstart and pstop [message #341145 is a reply to message #341138]

Sun, 17 August 2008 01:04

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel

Report message to a moderator

Re: pstart and pstop [message #341152 is a reply to message #341138]

Sun, 17 August 2008 04:37

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

Report message to a moderator

Re: pstart and pstop [message #341154 is a reply to message #341152]

Sun, 17 August 2008 05:16

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator