Oracle eBS經驗分享

監控資料庫效能

SELECT   s.username
       , s.SID
       , s.serial#
       , s.machine
       , TO_CHAR (sl.start_time, 'mm/dd/yyyy hh24:mi:ss') start_time
       , s.osuser
       , s.module
       , s.program
       , s.client_info
       , 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
       , sl.MESSAGE
    FROM v$session s
       , v$session_longops sl
   WHERE s.SID = sl.SID
     AND s.serial# = sl.serial#
     AND sl.time_remaining > 0
ORDER BY progress_pct DESC;