Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Where do you find undo info in trace files, and how
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(*)
0
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?
*-----------------------------
*-----------------------------
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 29 2004 - 07:56:54 CDT
![]() |
![]() |