Re: Where do you find undo info in trace files, and how

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 29 Sep 2004 09:01:11 -0400
Message-Id: <415AB217.000007.00312@DAZA-MGEJCA5J7T>

Thanks Gopalakrishnan
What I want is to get all the same info I get setting autotrace, but from trace file, if you can helpme please.
in this case I'm searching "redo size" source :)

SQL> select count(*) from adm.cuentase_me;

COUNT(*)

Execution Plan

0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE)
2 1 INDEX (FULL SCAN) OF 'CST_CUE_COD' (UNIQUE) Statistics

        503  recursive calls
          0  db block gets
        157  consistent gets
          3  physical reads
          0  redo size
        245  bytes sent via SQL*Net to client
        417  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          6  sorts (memory)
          0  sorts (disk)
          1  rows processed

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------

From: K GopalakrishnanDate: 09/29/04 03:35:40 To: jreyes_at_dazasoftware.com; oracle-l_at_freelists.org Subject: Re: Where do you find undo info in trace files, and how

Juan:

Here is the sample. It is an undo block dump. Are you looking for block dumps or undo traces?

*-----------------------------

* Rec #0x1 slt: 0x2d objn: 31961(0x00007cd9) objd: 31961 tblspc:
14(0x000000
0e)
* Layer: 11 (Row) opc: 1 rci 0x00

Undo type: Regular undo Begin trans Last buffer split: No Temp Object: No
Tablespace Undo: No
rdba: 0x00000000

*-----------------------------

uba: 0x03401ea9.0247.12 ctl max scn: 0x0000.004f0664 prv tx scn: 0x0000.004f06eb
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0034.008.0000088a uba: 0x034546ec.027f.03 flg: C--- lkc: 0 scn: 0x0000.004ef173
KDO Op code: QMD row dependencies Disabled xtype: XA bdba: 0x03875321 hdba: 0x0382059a itli: 2 ispac: 0 maxfr: 3239
tabn: 0 lock: 0 nrow: 1
slot[0]: 34

Have a nice day !!

Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004. http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 29 2004 - 07:56:54 CDT