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
See also
Server Maintenance Tasks as a DBA Click Here
Follow us on Facebook..!!
See Also :
