Resolve a Hung Database
DBA should not panic and take following step for troubleshoot.
Solution:-
1) Check your Alert log to any error shown in which related for database hung.
2) AWR and ASH report where
Hard parses at Top of load Profile section
Above section will show why database is slow.
3)Check the database for blocking locks as well as latch contention.
4) Check server memory and CPU usage. check PGA should not low.
5) Check Flash Recovery area (FRA)
6) Check login using Prelim option;
The -prelim option of the SQL*Plus connect string was introduced in 10g to bypasses the creation of a new session in cases where the database is hung and not accepting traditional sqlplus connections.
sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Fri Dec 29 20:38:02 2023
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> set _prelim on
SQL> connect / as sysdba
Prelim connection established
SQL> oradebug hanganalyze 3
Statement processed.
No comments:
Post a Comment