Test

Information

Apples are green

Oranges are orange

Bananas are yellow




How to take Oracle System State Dump?
How to check Sessions using TEMP Space ?
How to perform Character set conversion?
How to drop & cleanup database?




How to take Oracle System State Dump?
Whenever , there is a hang, the first and foremost thing that needs to be done is -- taking system state dump.
To collect systemstate, please run the following on one instance - cluster wide systemstate will be generated:


a- Using SQL*Plus connect as "/ AS SYSDBA"; if its not possible, use "sqlplus -prelim / as sysdba"
b- Execute the following commands:
SQL> oradebug setmypid
SQL> oradebug unlimit
SQL> oradebug setinst all
SQL> oradebug -g def dump systemstate 267
... Wait about 2 minutes to give time to identify process state changes.
SQL> oradebug -g def dump systemstate 267

SQL> oradebug -g def hanganalyze 4

No comments:

Post a Comment