Sometimes there are batch jobs or long-running queries in the database that may take a while to complete. This query will show the status of the query -- how much of it is completed. In other words, this may be viewed as a "progress bar" for the query. It has been tested on v. 188.8.131.52 on Tru64 and Windows. (Note: This tip is a modified version of a tip from Oracle documentation.)
SELECT * FROM (select
,round(sofar/totalwork*100,2) "% Complete"
WHERE "% Complete" != 100