Orace数据库锁表的处理与总结<摘抄与总结三>
来源:互联网 发布:合肥九龙医院网络预约 编辑:程序博客网 时间:2024/05/16 23:48
当Oracle数据库发生TX锁等待时,如果不及时处理常常会引起Oracle数据库挂起,或导致死锁的发生,产生ORA-60的错误。
TX锁等待的分析
Oracle数据库中一般使用行级锁。
当Oracle检测到死锁产生时,中断并回滚死锁相关语句的执行,报ORA-00060的错误并记录在数据库的日志文件alertSID.log中。同时在user_dump_dest下产生了一个跟踪文件,详细描述死锁的相关信息。
我们怎么查看日志文件和跟踪文件呢?下面介绍一下我们常用的命令1、查看操作系统版本
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL>
2、查看预警日志文件(alert_sid.log)的位置
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /u01/oracle/admin/bdump
core_dump_dest string /u01/oracle/admin/cdump
max_dump_file_size string 10240
shadow_core_dump string partial
user_dump_dest string /u01/oracle/admin/udump
3、创建目录alert
注意:directory不是实体,只是一个指向,指向os中一个路径
SQL> create or replace directory alert as '/u01/oracle/admin/bdump';
Directory created.
SQL>
4、创建外部表alert
SQL> create table alert
1 (log varchar2(1000))
2 organization external
3 (type oracle_loader
4 default directory alert
5 access parameters
6 (records delimited by newline)
7 location ('alert_PROD.log'))
8 reject limit unlimited;
Table created.
5、查看alert中的内容
SQL> select * from alert where rownum<20;
LOG
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Wed Feb 27 11:05:11 2013
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
19 rows selected.
SQL>
6、看看数据库有哪些 可爱的ORA- 错误吧
SQL> select * from alert where log like '%ORA-%';
LOG
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORA-959 signalled during: alter database default tablespace users...
ORA-959 signalled during: drop tablespace uses...
ORA-12919 signalled during: drop tablespace users...
ORA-1549 signalled during: drop tablespace users...
ORA-1505 signalled during: alter database add logfile group 1
ORA-1184 signalled during: alter database add logfile group 1
ORA-1013 signalled during: alter tablespace tts read only...
ORA-1013 signalled during: alter tablespace tts read only...
ORA-1013 signalled during: alter tablespace users read only...
ORA-1539 signalled during: alter tablespace users read only...
0 0
- Orace数据库锁表的处理与总结<摘抄与总结三>
- Orace数据库锁表的处理与总结<摘抄与总结一>
- Orace数据库锁表的处理与总结<摘抄与总结二>
- sg函数总结与摘抄
- nginx与PHP的flush(摘抄加总结)
- 继续摘抄: Linux与windows 互访总结
- PHP总结(三)PHP与数据库的交互
- cocos2d Touch处理摘抄总结
- 数据库系统表的总结与应用
- VB与数据库的总结
- 《黑客与画家》摘抄 三
- 《The C++ Programming Language》摘抄与总结——关于
- VB与数据库总结
- 【VB与数据库】总结
- android 触摸事件的处理与总结
- 有关性能的摘抄总结
- 总结 vb与数据库的连接方法
- VB与数据库(三)之迟到的机房收费系统总结
- UML,理理关系
- 第七周 项目二 并联电阻
- ubuntu文件系统
- Cocos2d-X 学习笔记4 锚点
- 最短路径图算法(shortest path dijkstra)
- Orace数据库锁表的处理与总结<摘抄与总结三>
- 删除SVN文件 Delete SVN Folders.reg
- bat(批处理文件)初步 第一篇 基本符号
- 1150 1151 魔板
- C++与java通过jni交互
- Centos 6.5 搭建LNMP服务器(nginx+mysql+php)
- Array实例
- 【Stackoverflow好问题】将InputStream转换为String
- 利用js获取服务器时间的两个简单方法