[ORACLE] Check DB Activity HTML version

check_db_activity_html.sh performs a quick health and activity snapshot across multiple Oracle database instances on a host. It automatically discovers instances from PMON processes or accepts an explicit list of SIDs, initializes the environment per SID, connects as SYSDBA, and captures key runtime indicators (state, sessions, waits, Data Guard lag, long operations).
Output is written to a HTML file.

[ORACLE] Check DB Activity

check_db_activity.sh performs a quick health and activity snapshot across multiple Oracle database instances on a host. It automatically discovers instances from PMON processes or accepts an explicit list of SIDs, initializes the environment per SID, connects as SYSDBA, and captures key runtime indicators (state, sessions, waits, Data Guard lag, long operations).
Output is written to a timestamped log file.

[ORACLE] Diagnostic from the PID (top CPU) -> output HTML file

Output file generated : HTML file.

 

# Auto-detect top CPU process and generate HTML file in current dir

./diag_top_pid.sh

 

# Explicit PID and output directory

./diag_top_pid.sh -p 3010886 -o /appli/home/oracle/diag

 

# With explicit connect string (if not using / as sysdba)

./diag_top_pid.sh -c "sys/YourPwd@//host:1521/PDB as sysdba"

[ORACLE] Diagnostic from the PID (top CPU) -> output logfile

Output file generated : log file.

 

# Auto-detect top CPU process and generate logfile  in current dir

./diag_top_pid.sh

 

# Explicit PID and output directory

./diag_top_pid.sh -p 3010886 -o /appli/home/oracle/diag

 

# With explicit connect string (if not using / as sysdba)

./diag_top_pid.sh -c "sys/YourPwd@//host:1521/PDB as sysdba"