How to know how much work done for a session

ezhilarasan_1 — Wed, 04 Aug 2004 21:35:36 GMT

Hi,

I got the below script from Metalink to know about How much work done for a RMAN session.
Likewise can we find out for each session of other jobs. Because users are oftently asking like how much ( presentage %) work done and
how long estimated time ..

How to answer them !! can we use the below SQL
formula for any job ? Please reply me.

-----------------------------------
To calculate the progress of an RMAN job, run the following query in SQL*Plus while the RMAN job is executing:

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "% COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
-----------------------------------

Thanks
Ezhil

Re: How to know how much work done for a session

Yogeeraj_1 — Thu, 05 Aug 2004 00:31:51 GMT

hi,

To monitor the progress of backups, copies, and restores, you can query the view V$SESSION_LONGOPS.

The query should work fine.

To determine which events are being waited for, you can query V$SESSION_WAIT.
e.g.
SELECT sid, seconds_in_wait AS sec_wait, event FROM v$session_wait
WHERE wait_time = 0
ORDER BY sid;

If you want to tune performance, see: http://download-east.oracle.com/docs/cd/A81042_01/DOC/server.816/a76992/toc.htm

hope this helps!
regards
Yogeeraj

topic Re: How to know how much work done for a session in Operating System - HP-UX

How to know how much work done for a session

Re: How to know how much work done for a session