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