undo usage in a query [message #429278] |
Tue, 03 November 2009 00:37 |
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 |
|
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
|
|
|