Re: Long Operation monitoring in 10g OEM

On 9 oct, 23:20, Dan <daniel.oster..._at_visaer.com> wrote:
> We recently upgraded to Oracle 10g. Does anyone know how to view the
> progress of long operations in 10g?
>
> In 9i Enterprise Manager, I was able to view sessions and see clearly
> those that were considered Long Operations (they had a clock icon next
> to the session). Once you opened the row, there was a tab for Long
> Operations where you could see how far along you were with the SQL
> statement it was running.
>
> In 10g, I now use the web-based OEM. There is more than enough info
> about the job running, but nowhere have I found the percent complete
> or estimated time remaining. All I see is the percent of total CPU it
> is using. I know I can run a query to get this long op info, but I
> prefer a graphical tool like the old 9i OEM.
>
> Am I just missing where it is, or has it been removed from 10g?
>
> Thanks,
> Dan

v$session_longops

HTH Cheers.

Carlos. Received on Wed Oct 10 2007 - 02:30:32 CDT