Home » RDBMS Server » Performance Tuning » what's mean of plh in SQL_TRACE? (11gr2)
what's mean of plh in SQL_TRACE? [message #575584] Thu, 24 January 2013 08:17 Go to next message
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
Re: what's mean of plh in SQL_TRACE? [message #575587 is a reply to message #575584] Thu, 24 January 2013 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://oracle-abc.wikidot.com/en:abbreviation-in-oracle-trace-file

is GOOGLE broken for you?

Plan Hash Value
Re: what's mean of plh in SQL_TRACE? [message #575627 is a reply to message #575587] Thu, 24 January 2013 20:48 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member
Thank you,BlackSwan!
Yes,google is always broken here,you know. Shocked

Regards
Alan
Re: what's mean of plh in SQL_TRACE? [message #575628 is a reply to message #575627] Thu, 24 January 2013 20:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Yes,google is always broken here,you know.
consider taking a class in Remedial GOOGLE operations
Re: what's mean of plh in SQL_TRACE? [message #575631 is a reply to message #575628] Thu, 24 January 2013 21:41 Go to previous message
alantany
Messages: 115
Registered: July 2007
Senior Member
Thanks.
But I consider a VPN verver.

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


Current Time: Fri Mar 29 01:54:25 CDT 2024