Re: Find table name -- reading from undo

Veera wrote:
> 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

Rather than the question you asked perhaps you should have asked: "What is the best way to monitor long running jobs?"

The solution is to use the DBMS_APPLICATION_INFO package's SET_SESSION_LONGOPS procedure.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)