-
编辑 删除
一些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...
