-
编辑 删除
一些X$表的小结
· 作者 小荷||【转载时请务必以超链接形式标明文章原始出处和作者信息】 · 永久链接: http://www.oracleblog.org/study-note/summary-of-some-x-tables/ 1.X$KTUXE——[K]ernel [T]ransaction [U]ndo Transa[x]t...
-
编辑 删除
RFS-process on physical standby database fails with Ora-00600:[Kcrrrfswda.9]
In this Document Symptoms Changes Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later ...
-
编辑 删除
Warning: OS async I/O limit 128 is lower than.. in Alert log
1. For more details about how to tune ASYNC I/O for Raw disk partitions on HP_UX kindly refer, Oracle Database Administrator's Reference 11g Release 1 (11.1) for Linux and UNIX-Based Operating Sy...
-
编辑 删除
DataGuard体系结构
一、DataGuard总体结构 总体目标1、 描述计划和非计划停机的不同因数 2、 DataGuard的主要组件 3、 物理以及逻辑DataGuard的异同 4、 建立DataGuard的好处 5、&nb...
-
编辑 删除
How to Add/Drop/Resize Redo Log with Physical Standby in place
In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5Information in this document applies to any platform.GoalTo Add...
-
编辑 删除
Monitoring Open Cursors & Troubleshooting ORA-1000 Errors
In this Document Purpose Scope and Application Monitoring Open Cursors & Troubleshooting ORA-1000 Errors ReferencesApplies to: PL/SQL - Version: 10.2.0...
-
编辑 删除
ORA-00313, ORA-00312, ORA-27037 in Standby Database
ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1] 修改时间 20-APR-2009 类型 PROBLEM 状态 MODERATED In th...
-
编辑 删除
sqlnet.expire_time and IDLE_TIME
当设置了resource_limit=true 。通过idle_time限制session idle 时间。session idle超过设置时间，状态为sniped (v$session).,然而OS下的process并不会释放，当session(user process) 再次与server process 通讯，将...
-
编辑 删除
Archiving With Multiple Destinations Fails With ORA-16040
fact: Oracle Server - Enterprise Edition 9.0fact: Oracle Server - Enterprise Edition 8.1symptom: Archiving failssymptom: ORA-16040: standby destination archivelog file is lockedsymptom: Multiple a...
-
编辑 删除
Changing SYS passwd of PRIMARY db when STANDBY in place to avoid ORA-16191
In this Document Goal SolutionPlatforms: 1-914CU; This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been s...
-
编辑 删除
Two ORA-1031 Reported in Trace File of Primary in Dataguard Configuration
In this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and ...
-
编辑 删除
LOG_ARCHIVE_DEST_2 Fails With ORA-1031 [ID 259142.1]
In this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.2 - Release: 10.1 to 10...
-
编辑 删除
Redo Corruption Errors During Redo Transport [ID 386417.1]
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1.0 to 9.2.0.7.0This problem can occur on any platform.SymptomsWhen shipping redo to a standby database, the following errors are repo...
-
编辑 删除
LAG与LEAD分析函數的用法
LAG的使用例子:with a as (select 1 id,'a' name from dual union all select 2 id,'b' name from dual union all select 3 id,'c' name from dual union all select 4 id,'d...
-
编辑 删除
关于查询空值列的优化案例
SQL> desc all_objects 名称 &...
-
编辑 删除
在ORACLE中增进SCN及案例介绍
在oracle数据库中我们可以利用oracle的内部事件调整SCN。增进SCN通常有两种常用方法:1.alter session set events 'IMMEDIATE trace name ADJUST_SCN level x';--需要数据库OPEN2.通过10015事件alter session se...
-
编辑 删除
使用vi编辑器删除文本中所有空行
我这里在编辑一个很大的文件，有几万行，都是文件名sheetid, 中间有很多空行，我现在要做的事情就有要把这个文件中的空行都删除掉，这个本来想在ultraedit里面完成的，结果弄了好半天都没有搞定，时间紧急也没法再去...
-
编辑 删除
left join与right join
create table mytest1(id number,name varchar2(20));insert into mytest1 select 1,'a' from dual;insert into mytest1 select 2,'b' from dual;insert into mytest1 select 3,'c' from dual;insert into mytest1 s...
-
编辑 删除
压缩及删除归档日志脚本
前两天备库的归档日志尚未应用,结果被脚本给压缩了,导致备库向主库再次请求归档日志时主库的归档日志也被压缩而找不到相应文件,结果报错.因以前的压缩及删除归档的脚本存在过多弊端,故重新写了一...
-
编辑 删除
OracleRAC10.2.0.1Linux升级到10.2.0.4步骤:
OracleRAC10.2.0.1Linux升级到10.2.0.4步骤: 1.下载升级补丁p6810189_10204_Linux-x86.zip,并上传到RAC的master node,解压. 2.停止数据库,用rman备份全库,再用tar...
