如何處理HANG住的DB

如何處理HANG住的DB 1. 生成 systemstate dump:SQLgt;sqlplus -prelim / as sysdbaSQLgt; alter session set max_dump_file_si

首頁 → 數(shù)據(jù)庫技術(shù)

背景：

如何處理HANG住的DB

[日期：2013-12-12] 來源：Linux社區(qū) 作者：zhou1862324 [字體：]

如何處理HANG住的DB

1. 生成 systemstate dump:
SQL>sqlplus -prelim / as sysdba
SQL> alter session set max_dump_file_size = unlimited;
SQL> alter session set events 'immediate trace name systemstate level 10';
Wait for some 30 seconds
SQL> alter session set events 'immediate trace name systemstate level 10';
Wait for some 30 seconds
SQL> alter session set events 'immediate trace name systemstate level 10;

2. 開一個新的SESSION:
SQL>sqlplus -prelim / as sysdba
SQL>oradebug setmypid
SQL>oradebug unlimit;
SQL>oradebug dump hanganalyze 3
Wait for 30 seconds
SQL>oradebug dump hanganalyze 3
Wait for 30 seconds
SQL>oradebug dump hanganalyze 3

對生成的文件進行分析。

附：system state dump when connection to the instance is not possible
There are several ways of getting more information when connection to an instance is not possible by sqlplus. It is useful to collect as much information about a hang before clearing the instance.

1.) Using OS debuggers like dbx or gdb.
For example:
$ps -ef |grep $Oracle_SID ## Use PID of any User Process instead of BG Process
$gdb $ORACLE_HOME/bin/oracle
print ksudss(10)
The systemstate dump will be in the bdump or udump depending on the PID chosen
2.) Using the new 10.1 sqlplus -prelim option.
For example:
export ORACLE_SID=PROD ## Replace PROD with the SID you want to trace
sqlplus -prelim / as sysdba
oradebug setmypid
oradebug unlimit;
oradebug dump systemstate 10
3.) Finally if either option (1) or (2) is not doable, please remember to take stacks of all the Oracle Background process using pstack or gdb
For example:
script stack.log
pstack
pstack
4.) Finally you may also want to collect some truss, tusc or strace of sqlplus
Note: The recommended systemstate level for 10g is 266

VIP不能正常啟動，報錯CRS-1006

GoldenGate疑似BUG：info all查看不到extract

相關(guān)資訊 HANG住

圖片資訊

本文評論 　　查看全部評論 (0)

評論聲明

最新資訊

本周熱門

Linux公社簡介 - 廣告服務(wù) - 網(wǎng)站地圖 - 幫助信息 - 聯(lián)系我們
本站（LinuxIDC）所刊載文章不代表同意其說法或描述，僅為提供更多信息，也不構(gòu)成任何建議。

Copyright © 2006-2011　Linux公社　All rights reserved 浙ICP備06018118號

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com