Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
select a.sid, a.serial#, b.sql_text
from v$session a, v$sqlarea b
Open in new window
select * from v$session_longops where time_remaining>0 and message not like '%RMAN%';
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.