Rantings of a impatient CNC consultant

I want to know know where the upgrade is at, and it’s killing me.  Lucky we have the logops table to help us along.  You need to be on an oracle database to see this information.

SELECT SID, SOFAR, TOTALWORK,
       ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE", elapsed_seconds, elapsed_seconds/(ROUND(SOFAR/TOTALWORK*100,2))*((totalwork-sofar)/totalwork*100)
FROM V$SESSION_LONGOPS
where sofar != totalwork

The script above is pretty handy, as it tells me the SID and SERIAL# of the sessions that are taking a long time.  How long the SQL has been running and also how many seconds to go.  This is great.

I can see things like index creation and also constraint creation – as well as complex SQL in the results.