GV$ARCHIVE_PROCESSESselect inst_id, -- INST_ID NUMBER to_number (kcrrxpid), -- PROCESS NUMBER decode -- STATUS VARCHAR2(10) (kcrrxsts, 1, 'SCHEDULED', 2, 'STARTING', 3, 'ACTIVE', 4, 'STOPPING', 5, 'TERMINATED', 6, 'INITING', 'STOPPED'), to_number (kcrrxseq), -- LOG_SEQUENCE NUMBER decode -- STATE VARCHAR2(4) (kcrrxsta, 1, 'BUSY', 'IDLE') from x$kcrrarch