澶ч儴鍒嗘儏鍐典笅锛屾垜浠彲浠ュ埄鐢╰kprof宸ュ叿鏍煎紡鍖杢race鏂囦欢锛岃trace鏂囦欢渚夸簬闃呰锛屼絾trkprof浜х敓鐨勬槸trace鏂囦欢鐨勬眹鎬荤粨鏋滐紝濡傛灉闇€瑕佺煡閬搒ql姣忎竴姝ョ‘鍒囨墽琛屼簡浠€涔堬紝鎴戜滑涔熷彧鑳界洿鎺ラ槄璇籺race聽
==============================================
APPNAME mod='%s' mh=%lu act='%s' ah=%lu聽
==============================================
APPNAME锛欰pplication name setting銆傚湪Oracle 7.2鍜屼互涓婄増鏈腑鍑虹幇銆傝繖涓悕绉板彲浠ョ敱DBMS_APPLICATION_INFO鍖呮潵璁惧畾銆?br> mod锛氭ā鍧楀悕
mh锛氭ā鍧楃殑鏁ｅ垪鍊?br> act锛氬姩浣滐紝濡侱BMS_APPLICATION_INFO
ah锛氬姩浣滅殑鏁ｅ垪鍊?br> 绀轰緥聽
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
===============================================
PARSING IN CURSOR # len=X dep=X uid=X oct=X lid=X tim=X hv=X ad='X'
statement....
END OF STMT
=============================================聽==
CURSOR锛欳ursor number
len 锛歀ength of SQL statement锛孲QL璇彞鐨勯暱搴?br> dep 锛歊ecursive depth of the cursor锛屽綋鍓峉QL璇彞鐨勯€掕娣卞害锛屽鏋滀负0鍒欒〃绀烘槸鐢ㄦ埛鎻愪氦鐨凷QL锛屼负1鍒欐槸鐢变簬鐢ㄦ埛SQL鑰屽鑷碠racle鍚庡彴鑷繁鎵ц鐨凷QL锛屼负2鍒欐槸鐢?绾QL缁х画璇卞彂鐨勪笅涓€绾QL銆?br> uid 锛歋chema user id of parsing user,褰撳墠妯″紡鐨勭敤鎴穒d鍜宭id涓嶅悓銆傛垜浠煡閬撳綋浣跨敤alter session set current_schema=NEWUSER鍛戒护鍚庯紝鐢ㄦ埛OLDUSER鍦ㄦ墽琛岄渶瑕丯EWUSER鐨勭浉鍏虫潈闄愭椂鎵嶄細鍒囨崲涓篘EWUSER锛屽垯杩欐椂浠ID鍗充负OLDUSER锛宭ib涓篘EWUSER
oct 锛歄racle command type. oracle鐨勫懡浠ょ被鍨?br> lid 锛歅rivilege user id. 鏍稿璁块棶鏉冮檺鐨刬d
tim 锛歍imestamp銆傚湪Oracle9i涔嬪墠鍗曚綅鏄?%绉掞紝9i涔嬪悗鍒欐槸1/1,000,000绉掋€傚埄鐢ㄨ繖涓€煎彲浠ヨ绠椾竴涓猄QL鎵ц浜嗗埌搴曞闀挎椂闂淬€傝繖涓€煎氨鏄綋鍓嶈琚啓鍏race鏂囦欢鏃舵暟鎹簱V$TIMER瑙嗗浘鐨勫€笺€?br> hv 锛欻ash id. sql鐨勬暎鍒梚d
ad 锛歋QLTEXT address锛孲QLTEXT鐨勫湴鍧€锛岃窡V$SQLAREA鍜孷$SQLTEXT瑙嗗浘涓殑ADDRESS瀛楁鍊肩浉绛夈€?br> statement 锛歍he actual SQL statement being parsed.瀹為檯鐨剆ql璇彞

绀轰緥聽
PARSING IN CURSOR #2 len=60 dep=0 uid=55 oct=6 lid=55 tim=1303778511213906 hv=478751424 ad='2ce279a4'
update employees set salary=1.1*salary where employee_id=100
END OF STMT聽
======================================================
PARSE #<CURSOR>:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
EXEC #<CURSOR>:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
FETCH #<CURSOR>:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
UNMAP #<CURSOR>:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
======================================================
PARSE 锛歅arse a statement. 瑙ｆ瀽涓€涓猄QL
EXEC 锛欵xecute a pre-parsed statement. 鎵ц宸茬粡瑙ｆ瀽瀹屾瘯鐨凷QL
FETCH 锛欶etch rows from a cursor. 浠庢父鏍囦腑寰楀埌鏁版嵁锛岄€氬父鎸噑elect杩斿洖璁板綍
UNMAP 锛氬鏋滄父鏍囦娇鐢ㄤ簡涓存椂琛紙temporary table锛? 褰撴父鏍囧叧闂殑鏃跺€欏皢浼氱湅鍒癠NMAP锛岀敤浠ヤ粠绋嬪簭涓棿缁撴灉涓噴鏀句笉鍦ㄧ敤鍒扮殑涓存椂娈?br> c锛欳PU time锛孋PU鏃堕棿 (100th's of a second Oracle7, 8. Microseconds in Oracle 9 onwards).
e锛欵lapsed time锛屾秷鑰楃殑鏃堕棿 (100th's of a second Oracle7, 8. Microseconds in Oracle 9 onwards).
p锛歂umber of physical reads锛岀墿鐞嗚鐨勬暟閲?
cr锛歂umber of buffers retrieved for Consistent reads锛宑onsistent妯″紡涓嬬殑璇绘鏁帮紝涓汉璁や负鍙互鐞嗚В涓簈uery妯″紡涓嬬殑璇绘鏁?br> cu锛歂umber of buffers retrieved in current mode锛宑urrent妯″紡涓嬬殑璇绘鏁?br> mis锛欳ursor missed in the cache锛屽湪搴撶紦瀛樻睜涓涪澶辩殑娓告爣
r锛歂umber of rows processed锛屽鐞嗙殑琛屾暟
dep锛歊ecursive call depth (0 = user SQL, >0 = recursive)锛岄€掑綊璇彞鐨勬繁搴?br> og锛歄ptimizer goal锛屼紭鍖栫洰鏍? 1=All_Rows, 2=First_Rows, 3=Rule, 4=Choose
tim锛歍imestamp (large number in 100ths of a second).璁℃椂鍣?br> 绀轰緥
FETCH #2:c=0,e=106,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6005498548671聽
======================================================
ERROR #%d:err=%d tim=%lu
======================================================
褰撴墽琛屾垨鑰呭彇鏁版嵁鍙戠敓閿欒
err 锛歄racle error code (e.g. ORA-XXXXX) at the top of the stack锛孫racle 閿欒浠ｇ爜(e.g. ORA-XXXXX)
tim 锛歍imestamp锛屾椂闂存埑
绀轰緥