Home » RDBMS Server » Server Administration » Interpreting trace output of 10046 event
Interpreting trace output of 10046 event [message #53751] Wed, 09 October 2002 09:27 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
Hi,
trace file question

Hi,

I am using oracle 81720 on solaris 2.8 . I have generated a trace file by setting event 10046 and it indicates the following :

XCTEND rlbk=1, rd_only=1 for select statements.
looking at the meaning of these "rblk", "rd_only" from metalink docs, rlbk = 1 if a rollback was performed, 0 if no rollback ( commit) rd_only = 1 if transaction was read only, 0 if changes occured.

here is the modified select stmt. :

PARSING IN CURSOR #1 len=554 dep=0 uid=53 oct=3 lid=53 tim=209785289 hv=1973622631 ad='530354f0'
Select column_list from table_name where id=:1
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=3,tim=209785289
BINDS #1:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=24 offset=0
bfp=018beac8 bln=22 avl=04 flg=05
value=170105
XCTEND rlbk=0, rd_only=1 <----------------(???)
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=3,tim=209785289
FETCH #1:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=1,dep=0,og=3,tim=209785294
STAT #1 id=1 cnt=1 pid=0 pos=0 obj=4022 op='TABLE ACCESS BY INDEX ROWID table_name '
STAT #1 id=2 cnt=2 pid=1 pos=1 obj=4025 op='INDEX RANGE SCAN '
XCTEND rlbk=1, rd_only=1 <================(?)
XCTEND rlbk=1, rd_only=1 <================(?)
=====================
Questions:
1)For which statement these additional (one pointed out with <=== ) XCTEND values are for?
2) if I were to add all the rlbk=1 for all user stmts., will I get the user_rollbacks statistics indicated in statspack/utlestat report?
3) is there a way to find out meaning of all the oac flags?
4) We are only executing a select statement and I need to understand why it is issuing 3 "xctend" calls ? is it how oracle works internally or is it something to do
how java code handles commit/rollback ?

Thanks
Kapil

Report message to a moderator

Re: Interpreting trace output of 10046 event [message #54604 is a reply to message #53751] Fri, 22 November 2002 16:51 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
This trace file could be formated using tkproff utility. It's much more human readable after that.

Use:

$tkproff trace_file.trc report_file.txt

and review the generated report file.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Help Please
Next Topic: Err: "products in use" but none are
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:48:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.