Health Check – When the Application Users complaints for an issue

FREE Sign-Up with Gmail and Receive Pdf's and Updates via Mail -Click Here

Check-List for Performing Database health checks, when there is an issue reported by Application users.

1. Check the Database details

2. Monitor the consumption of resources

3. Check the Alert Log

4. Check Listener log

5. Check Filesystem space Usage

6. Generate AWR Report

7. Generate ADDM Report

8. Finding Locks,Blocker Session and Waiting sessions in a oracle database

9. Check for alerts in OEM

Hands-On

1.  Monitor the consumption of resources :-

select * from v$resource_limit where resource_name in ('processes','sessions');

The v$session views shows current sessions (which change rapidly),

while the v$resource_limit shows the current and maximum global resource utilization for some system resources.

2. Check the Alert Log :-

$locate alert_<ORACLE_SID>

--- OR ---

UNIX/Linux command to locate the alert log file

-----------------------------------------------

$ find / -name 'alert_*.log' 2> /dev/null

Open the Alert log using VI Editor :

vi <alert_log_location_of_the_above_output>

“press shift+g”

?ORA-   ---> press enter key

press 'n' to check backwards/up side and 'N' for forward/down side search.

:q! --and press enter, for exiting vi editor

3. Check Listener log :-

$locate listener.log

Or

$lsnrctl status

4. Check Filesystem space Usage :-

$ df -h (Linux / UNIX)

$ df -g (AIX)

5. Finding Locks,Blocker Session and Waiting sessions in a oracle database :-

SQL>Select * from v$lock;

A fast way to check blocking/waiting situations

SQL > SELECT * FROM v$lock WHERE block > 0 OR request > 0;

6. Check for alerts in OEM :-

Login to Oracle Enterprise Manager with valid username and password

click on "Alerts" tab

then select the below tabs one by one to see the alerts generated

Targets Down/Critical/Warning/Errors/


See also 

Server Maintenance Tasks as a DBA  Click Here 

 Follow us on Facebook..!!

See Also : 

How to Prepare for DBA Interview

General Tips to Prepare for an Oracle DBA Job Interview