-
Long process in EM
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.
-
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
People with goals know where they are going
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|