SELECT
inst_id,
SID,
SERIAL#,
OPNAME,
SOFAR,
TOTALWORK,
ROUND(SOFAR/TOTALWORK*100, 2) AS "%_COMPLETE",
START_TIME
FROM
GV$SESSION_LONGOPS
WHERE
OPNAME LIKE 'EXPORT%'
AND TOTALWORK > 0;
How to shutdown a Single Instance Database in Oracle 19c Overview Shutdown is an operation performed when a command is issued by the Administrator to bring down the Database or when it receives a signal to bring down the Database incase of a failure/malfunction or due to SHUTDOWN ABORT comm and execution. The options used by t he Administrator to bring down the Database is called as Shutdown Modes and the Database Server follows a sequence to shutdown a Database . Let's check how does that happen. Concepts The following are the shutdown Modes. Shutdown Modes A database administrator with SYSDBA or SYSOPER privileges can shut down the database using the SQL*Plus SHUTDOWN command or Enterprise Manager. The SHUTDOWN command has the following options that determine the shutdown behavior. Now let's look into each SHUTDOWN option in detail. SHUTDOWN ABORT This mode is used for emergency situations, such as when shutdown with "IMMEDIATE" option doesn't work. This mode o...