首页 > Linux操作系统 > Linux操作系统 > HANGANALYZE
Collection commands for Hanganalyze and Systemstate: Non-RAC:Sometimes, database may actually just be very slow and not actually hanging. It is therefore recommended, where possible to get 2 hanganalyze and 2 systemstate dumps in order to determine whether processes are moving at all or whether they are "frozen".
Hanganalyzesqlplus '/ as sysdba'
oradebug setmypid
oradebug unlimit
oradebug hanganalyze 3
-- Wait one minute before getting the second hanganalyze
oradebug hanganalyze 3
oradebug tracefile_name
exitSystemstate
sqlplus '/ as sysdba'Collection commands for Hanganalyze and Systemstate: RAC
oradebug setmypid
oradebug unlimit
oradebug dump systemstate 266
oradebug dump systemstate 266
oradebug tracefile_name
exitThere are 2 bugs affecting RAC that without the relevant patches being applied on your system, make using level 266 or 267 very costly. Therefore without these fixes in place it highly unadvisable to use these level
For information on these patches see:Document 11800959.8 Bug 11800959 - A SYSTEMSTATE dump with level >= 10 in RAC dumps huge BUSY GLOBAL CACHE ELEMENTS - can hang/crash instancesCollection commands for Hanganalyze and Systemstate: RAC with fixes for bug 11800959 and bug 11827088
Document 11827088.8 Bug 11827088 - Latch 'gc element' contention, LMHB terminates the instancesqlplus '/ as sysdba'Collection commands for Hanganalyze and Systemstate: RAC without fixes for Bug 11800959 and Bug 11827088
oradebug setorapname reco
oradebug unlimit
oradebug -g all hanganalyze 3
oradebug -g all hanganalyze 3
oradebug -g all dump systemstate 266
oradebug -g all dump systemstate 266
exitsqlplus '/ as sysdba'
oradebug setorapname reco
oradebug unlimit
oradebug -g all hanganalyze 3
oradebug -g all hanganalyze 3
oradebug -g all dump systemstate 258
oradebug -g all dump systemstate 258
exitIn RAC environment, a dump will be created for all RAC instances in the DIAG trace file for each instance.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15747463/viewspace-774011/ ,如需转载,请注明出处,否则将追究法律责任。