-
编辑 删除
SMON: Parallel transaction recovery tried 引发的问题
SMON: Parallel transaction recovery tried 这个一般是在 具有在跑大数据量的 transaction的时候 kill 掉了进程而导致 smon 去清理 回滚段时导致的。 这个在 业务高峰期的时...
-
编辑 删除
ora-00600 [17182], [0x60000000005A49C8], [], [], [], [], [], []
environment: hp unix Release: B.11.23Version: UMachine: ia64oracle 9.2.0.6...
-
编辑 删除
what does unknown mean in v$rollstat.status
Often, v$rollstat.status has 4 values whitch are ONLINE,PENDING OFFLINE,OFFLINE,FULL.I have seen unknown in v$rollstat.status.what does It meaning?through metalink(id:736905.1):The following query wi...
-
编辑 删除
ORA-00600 [keltnfy-ldmInit], [46] when startup nomount
I changed the hostname of linux os a short time begore. And then,I also changed the "host=dataguard1" to "host=dg2" in listener.ora.I thought it's enough. then ,I did followed:sql...
-
编辑 删除
Cannot determine all dependent dynamic libraries for /proc/self/exe
when I startup the db ,alert.log shows these messages:Starting ORACLE instance (normal)Cannot determine all dependent dynamic libraries for /proc/self/exe Unable to find dynamic library libocr10.so i...
-
编辑 删除
vmware 里的 rac install 的记录
最近想学 rac，所以在虚拟机上装了下，前前后后总共花了 一星期的时间，由于对 rac 很不熟悉，所以很多内容也无从考证，但是总得记录的： 安装过程，都是参考 三思的文档和...
-
编辑 删除
rman 恢复一例 restore controlfile
>rman target /恢复管理器: Release 10.2.0.1.0 - Production on 星期三 5月 12 09:43:02 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.已连接到目标数据库 (未启动)RMAN> Oracle 实例已启...
-
编辑 删除
rman 的一点点
BACKUP DATABASE PLUS ARCHIVELOG; 做了什么You can add archived redo logs to a backup of other files by using the BACKUP ... PLUS ARCHIVELOG clause. Adding BACKUP ... PLUS ARCHIVELOG causes RMAN to do ...
-
编辑 删除
视图 order by 导致执行计划改变
CREATE TABLE test_aaa AS SELECT * FROM Dba_Objects;CREATE TABLE test_bbbb AS SELECT * FROM Dba_Objects WHERE ROWNUM<=10000;INSERT INTO test_bbbb SELECT * FROM test_bbbb; --执行 2 次CREATE INDE...
-
编辑 删除
绑定变量的使用
绑定变量的变迁和使用像 select * from test where ch1=1; ----1 是常量无论是 存储过程（PL/SQL）还是 一般的 语句在 9i 中，都会变成 select * from test where ch1='SYS_...' --系统自动生...
