OraFAQ Forum: Performance Tuning » what's mean of plh in SQL_TRACE?

Home » RDBMS Server » Performance Tuning » what's mean of plh in SQL_TRACE? (11gr2)

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

Switch to threaded view of this topic

Create a new topic

Submit Reply

what's mean of plh in SQL_TRACE? [message #575584]

Thu, 24 January 2013 08:17

alantany
Messages: 115
Registered: July 2007

Senior Member

Hi,
Could someone tell me what the PLH means in a SQL_TRACE trace file,like:

FETCH #2:c=0,e=37,p=0,cr=1,cu=0,mis=0,r=15,dep=0,og=1,plh=1601196873,tim=439414885936
FETCH #2:c=0,e=40,p=0,cr=1,cu=0,mis=0,r=15,dep=0,og=1,plh=1601196873,tim=439414892914

Thanks!

Alan

Report message to a moderator

Send a private message to this user

Re: what's mean of plh in SQL_TRACE? [message #575587 is a reply to message #575584]

Thu, 24 January 2013 08:55

BlackSwan
Messages: 20107
Registered: January 2009

Senior Member

http://oracle-abc.wikidot.com/en:abbreviation-in-oracle-trace-file

is GOOGLE broken for you?

Plan Hash Value

Report message to a moderator

Send a private message to this user

Re: what's mean of plh in SQL_TRACE? [message #575627 is a reply to message #575587]

Thu, 24 January 2013 20:48

alantany
Messages: 115
Registered: July 2007

Senior Member

Thank you,BlackSwan!
Yes,google is always broken here,you know. Shocked

Shocked

Regards
Alan

Report message to a moderator

Send a private message to this user

Re: what's mean of plh in SQL_TRACE? [message #575628 is a reply to message #575627]

Thu, 24 January 2013 20:57

BlackSwan
Messages: 20107
Registered: January 2009

Senior Member

>Yes,google is always broken here,you know.
consider taking a class in Remedial GOOGLE operations

Report message to a moderator

Send a private message to this user

Re: what's mean of plh in SQL_TRACE? [message #575631 is a reply to message #575628]

Thu, 24 January 2013 21:41

alantany
Messages: 115
Registered: July 2007

Senior Member

Thanks.
But I consider a VPN verver.

Regards
Alan

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	Physical Reads & Logical Reads
Next Topic:	How can we verify the statistic info is not good

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 15:36:34 CDT 2013

Total time taken to generate the page: 0.36169 seconds