How To Drop and Recreate ASM Diskgroup [ID 563048.1]
修改时间 27-FEB-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal  ...
Deadlock Error Not in Alert.log and No Trace File Generated on OPS or RAC
修改时间 20-OCT-2010 类型 TROUBLESHOOTING 状态 ARCHIVED Applies to: Oracle Server - Enterprise Edition - Versi...
RAC Hangs due to small cache size on SYS.AUDSES$ [ID 395314.1]
修改时间 15-SEP-2010 类型 BULLETIN 状态 ARCHIVED PURPOSE-------Prevent hangs in RAC due to high login rate an...
ASM Instance Crashing with ORA-29702 [ID 445023.1]
修改时间 10-AUG-2011 类型 PROBLEM 状态 ARCHIVED In this Document Symptoms Cause &nb...
ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS Instance
In this Document Symptoms Changes Cause SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10...
How to Manually Determining and Resolving Archive Gaps in ASM [ID 1271114.1]
修改时间 17-FEB-2011 类型 HOWTO 状态 MODERATED In this Document Goal Solution ...
ASM 11g New Features - How ASM Disk Resync Works. [ID 466326.1]
ASM 11g New Features - How ASM Disk Resync Works. [ID 466326.1] 修改时间 10-AUG-2011 类型 BULLETIN 状态 PUBLISHED ...
RMAN: RAC Backup and Recovery using RMAN [ID 243760.1]
RMAN: RAC Backup and Recovery using RMAN [ID 243760.1] 修改时间 30-JUN-2011 类型 BULLETIN 状态 PUB...
How to restore ASM based OCR after complete loss of the CRS diskgroup
How to restore ASM based OCR after complete loss of the CRS diskgroup on Linux/Unix systems [ID 1062983.1] 修改时间 10-AUG-2011  ...
8月12日SYS用戶invalid對象處理
今天看到一個DB SYS用戶下有126個invalid的對象,單個編譯invalid對象無效用utlrp.sql 搞定了它/* Formatted on 2011/08/12 16:20 (Formatter Plus v4.8.8) */SELECT owner, object_name, object_type &...
debug记录登录信息的trigger
今天DBA檢查時發現記錄登錄信息的表中兩台電腦竟然用了同一個IP地址,這兩台電腦都是固定IP,不應該出現這樣的狀況記錄登入/登出的Trigger是原來一個DBA寫的,他已經離職,我也沒仔細看,這次要好好檢查一下...
Migrating Databases To and From ASM with Recovery Manager
This chapter describes how to migrate part or all of your database into and out of ASM storage using Recovery Manager. It includes the following topics:Migrating a Database into ASMMigrating ...
Step By Step Guide To Create Physical Standby Database Using RMAN
Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1] 修改?? 30-JUN-2009 ?型 HOWTO ?? MODERATED In this Document Goal SolutionThis document is being delivere...
How to create physical standby database with 11g RMAN DUPLICATE
How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1] 修改?? 11-SEP-2009 ?型 HOWTO ?? PUBLISHED In this Document G...
Redo Log File Management and Issues when using RMAN to do Automatic Recovery
Redo Log File Management and Issues when using RMAN to do Automatic Recovery [ID 155656.1] 修改?? 24-JUL-2011 ?型 BULLETIN ?? ARCHIVED Checked for relevance on 19-Aug-2008PURPOSE~~~~~~~~~~...
pl/sql function result cache in 11g
http://www.oracle-developer.net/display.php?id=504關於function result cache一篇不錯的文章
Troubleshooting "ORA-60 Deadlock Detected" Errors [ID 62365.1]
TX Transaction locks - Example wait scenarios [ID 62354.1]
TX Transaction locks - Example wait scenarios [ID 62354.1] 修改?? 16-AUG-2010 ?型 TROUBLESHOOTING ?? PUBLISHED &nb...