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".
SystemstateCollection commands for Hanganalyze and Systemstate: RAC
There 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 levelCollection commands for Hanganalyze and Systemstate: RAC with fixes for bug 11800959 and bug 11827088Collection commands for Hanganalyze and Systemstate: RAC without fixes for Bug 11800959 and Bug 11827088
For information on these patches see:
In RAC environment, a dump will be created for all RAC instances in the DIAG trace file for each instance.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-774011/，如需转载，请注明出处，否则将追究法律责任。