PHASE_CODE Column :
C – Completed
I – Inactive
P – Pending
R – Running
STATUS_CODE Column :
A – Waiting
B – Resuming
C – Normal
D – Cancelled
E – Error
F – Scheduled
G – Warning
H – On Hold
I – Normal
M – No Manager
Q – Standby
R – Normal
S – Suspended
T – Terminating
U – Disabled
W – Paused
X – Terminated
Z – Waiting
Disclaimer:
This is an independent personal blog and is not affiliated with, sponsored by, or endorsed by Oracle Corporation. The views, explanations, and experiences expressed here are the author’s own. Commands, scripts, and procedures may be based on Oracle’s official documentation and are provided for educational and reference purposes only. Always test and validate them before use in a Live/Production environment. Sample output shown in this article was generated during the author’s own testing and may vary depending on the environment.
Please read full Disclaimer.