Home » RDBMS Server » Performance Tuning » undo usage in a query (oracle 10.2.0.4, Sun 5.10 )
undo usage in a query [message #429278] Tue, 03 November 2009 00:37 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
hi

i have to execute a script and want to know the undo being used for while executing the script.
Kindly help me how i can do that..


regards
Re: undo usage in a query [message #429293 is a reply to message #429278] Tue, 03 November 2009 01:21 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL> desc v$mystat
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SID                                       NUMBER
 STATISTIC#                                NUMBER
 VALUE                                     NUMBER

SQL> select statistic#, name from v$statname where name like '%undo%';
STATISTIC# NAME
---------- -----------------------------------------------------------
        75 DBWR undo block writes
       176 undo change vector size
       177 transaction tables consistent reads - undo records applied
       179 data blocks consistent reads - undo records applied
       188 rollback changes - undo records applied
       200 auto extends on undo tablespace
       202 total number of undo segments dropped
       220 global undo segment hints helped
       221 global undo segment hints were stale
       222 local undo segment hints helped
       223 local undo segment hints were stale
       224 undo segment header was pinned
       226 SMON posted for undo segment recovery
       229 SMON posted for undo segment shrink
       236 IMU undo retention flush
       242 IMU undo allocation size

16 rows selected.

Regards
Michel
Previous Topic: Advanced Queuing correlation id
Next Topic: ORA-02097 AND ORA-00439
Goto Forum:
  


Current Time: Mon Nov 25 16:26:29 CST 2024