Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Find table name -- reading from undo
Hi,
We used to look into the v$sess_io whenever we get a request to find status of a long running job. And if we see CONSISTENT_CHANGES column in v$sess_io is increasing then we will say "this session is reading from undo ".
Now my question is
Is there any way to find the table for which it is reading UNDO to get consistant image.
Thanks Received on Wed Jun 08 2005 - 09:25:53 CDT
![]() |
![]() |