mysql数据库hang住_如何处理HANG住的DB

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

logo.jpg

首页 → 数据库技术

背景:

阅读新闻

如何处理HANG住的DB

[日期:2013-12-12]

来源:Linux社区

作者: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

logo.gif

0

VIP不能正常启动,报错CRS-1006

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

相关资讯

HANG住

drop用户hang住解决思路 (01月23日)

批量错误用户名与密码导致业务用户 (01月09日)

Oracle数据库shutdown immediate被 (01月19日)

图片资讯

本文评论

查看全部评论 (0)

评论声明

最新资讯

本周热门

Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们

本站(LinuxIDC)所刊载文章不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。

Copyright © 2006-2011 Linux公社 All rights reserved 浙ICP备06018118号

本文原创发布php中文网,转载请注明出处,感谢您的尊重!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值