oracle dump 수행

1. hang dump

-- rac 

sqlplus  / as sysdba  > /tmp/hangdump << EOF

set linsize 140

oradebug setmypid

oradebug setinst all

oradebug -g def hanganalyze 3   

exit

EOF

/tmp/hangdump 내용 검토

-- single

sqlplus  / as sysdba  > /tmp/hangdump << EOF

set linsize 140

oradebug setmypid

oradebug  hanganalyze 3   

exit

EOF

/tmp/hangdump 내용 검토

2. sysdump

-- rac

sqlplus  / as sysdba  > /tmp/systemdump << EOF

set linsize 140

oradebug setmypid

oradebug unlimit

oradebug -g def dump systemstate  10 

oradebug tracefile_name  

exit

EOF

/tmp/systemdump 내용 검토

--single

sqlplus  / as sysdba  > /tmp/systemdump << EOF

set linsize 140

oradebug setmypid

oradebug unlimit

oradebug dump systemstate  10 

oradebug tracefile_name  

exit

EOF

/tmp/systemdump 내용 검토