Long process in EM

[steeve123]

n Enterprise manager 9i. There was a possibility to see long operations.
Where is it in enterprise manager grid control?
im on 10.2.0.1.

I can found info regarding this using the following query:
SELECT s.sid,
s.serial#,
s.machine,
ROUND(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,
ROUND(sl.time_remaining/60) || ':' || MOD(sl.time_remaining,60) remaining,
ROUND(sl.sofar/sl.totalwork*100, 2) progress_pct
FROM v$session s,
v$session_longops sl
WHERE s.sid = sl.sid
AND s.serial# = sl.serial#;

But it would be great to use the grid to get that info.

[zakriyamhd]

Hi steeve,

I am not sure if this is what your looking for...

I will look at the TOP CONSUMERS page.
|->Performance page
|-> TOP Consumers ( under additional monitoring links)
|_> overview || top services || top modules || top actions|| top clients || top sessions

Thanks

[steeve123]

check this out to see what i need.
http://www.gplivna.eu/papers/v$session_longops.htm
I need that in the enterprise manager grid control 10.2.0.1.
I figured if it was in enterprise 9i, then it should be in grid10g.

[steeve123]

Anyone?