-
编辑 删除
很折磨人的SQL优化
今天继续搞那一卡通 DB的SQL 折腾了一天，简单记下，等周一再补齐1、干掉一个5900万笔记录上一个Distinct_key值只有36的索引，加快每天对这个表一次性插入约60万笔记录SQL的速度2、在那个向5900万笔记...
-
编辑 删除
11.2.0.3 Linux X86-64 VKTM問題處理
今早在新作的一個11.2.0.3 Linux X86-64 Standby DB的預警文件中發現有規律的報警信息Wed Dec 21 22:30:19 2011Time drift detected. Please check VKTM trace file for more details.Wed Dec 21 23:30:21 2...
-
编辑 删除
How to determine granule size [ID 947152.1]
修改时间 10-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution  ...
-
编辑 删除
Why Does Oracle Create So Many Open File Descriptors in /dev/shm
ID 1321306.1修改时间 19-OCT-2011 类型 HOWTO 状态 REVIEWED In this Document Goal Solution ...
-
编辑 删除
HugePages and Oracle Database 11g Automatic Memory Management (AMM) on Linux
[ID 749851.1]修改时间 15-SEP-2011 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Ap...
-
编辑 删除
10.2.0.4升級11.2.0.3問題處理
近日將一個10.2.0.4 (LInux X86-64)的庫升級到11.2.0.3 (Linux X86-64)後發生一點小問題前期請開發測試11G測試庫都很正常，決定正式升級昨天早上開發打電話來，User反映導PPID很慢，程式會僵死，登上GridControl...
-
编辑 删除
ORA-00845 When Starting Up An 11g Instance With AMM Configured. [ID 460506.1]
修改时间 18-FEB-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause&...
-
编辑 删除
How To Avoid ORA-04030/ORA-12500 In 32 Bit Windows Environment [Video]
[ID 373602.1]修改时间 17-AUG-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms&n...
-
编辑 删除
split分區踩到陷阱
[i=s] 本帖最后由 spider0283 于 2011-12-16 15:57 编辑 臨近12月31，吩咐下面兄弟檢查分區表，分區範圍不夠的要加分區結果他把一個3300萬的大表的MAX分區split了，這個MAX分區有800多筆數據這個表僅有的...
-
编辑 删除
VI快捷键
-
编辑 删除
Implementing Address Windowing Extensions (AWE) or VLM on 32-bit Windows
[ID 225349.1] 修改时间 27-APR-2011 类型 BULLETIN 状态 PUBLISHED Applies to: Oracle Server - Enterprise EditionMi...
-
编辑 删除
ORA-4030 PGA Usage Diagnostic Script [Video] [ID 1087789.1]
修改时间 07-DEC-2011 类型 SAMPLE CODE 状态 PUBLISHED In this Document Purpose Software Req...
-
编辑 删除
How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1]
修改时间 21-NOV-2011 类型 BULLETIN 状态 PUBLISHED Applies to:Oracle Server - Enterprise Edition - Version:...
-
编辑 删除
ORA-19527 reported in Standby Database when starting Managed Recovery
[ID 352879.1]修改时间 28-MAR-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Ca...
-
编辑 删除
Fatal NI Connect Error 12170, 'TNS-12535 Reported in 11g Alert Log
[ID 1286376.1]修改时间 14-NOV-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms &...
-
编辑 删除
Master Note for Troubleshooting Oracle Managed Distributed Transactions
[ID 100664.1]修改时间 11-SEP-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is bein...
-
编辑 删除
Alert Log Messages: Private Strand Flush Not Complete [ID 372557.1]
In this Document Symptoms Changes Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0...
-
编辑 删除
The Performance Impact of Deadlock Detection [ID 285270.1]
Checked for relevance 8-18-2010.PURPOSE-------To increase awareness of the performance impact that deadlock detection can have on an instance. SCOPE & APPLICATION-------------------This a...
-
编辑 删除
Diagnosing and Resolving ORA-4030 errors [ID 233869.1]
Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.4 and later [Release: and later ]Information in this document applies to any platform.PurposeHow to diagnose ORA-40...
-
编辑 删除
Howto set maximum user processes on AIX [ID 1084995.1]
修改时间 26-AUG-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal SolutionApplies...
