Fixed Table STATS Issue after Gathering Fixed Object STATS
Fixed Table STATS Issue after Gathering Fixed Object STATS Posted on March 15, 2015 by Weidong Zhou 3 Recently we were w...
技术文章列表
402 篇Find a session which are generating more archive logs
To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount o...
Extended Statistics (Oracle Optimizer)
« Oracle OpenWorld… | Main | How do I know what… » Extended Statistics By Maria Colgan-Oracle on Mar 17, 201...
EXPDP_IMPDP running slow on 11g or above _ STREAMS AQ: ENQUEUE BLOCKED ON LOW MEMORY” WHEN REDUCING STREAMS_POOL_SIZE
SYMPTOMS The import with DataPump of tables into an Oracle11g Release 11.2.0.4 database takes almost 45 minutes, while t...
EXP-00003: no storage definition found for segment(0, 0)解决办法 – zhasir的专栏 – 博客频道 – CSDN.NET
Oracle11gR2中空表是不会分配segment的。当含有空表，使用exp导出整个用户的时候报EXP-00003: no storage definition found for segment(0, 0)错误。 解决办法： 方法一：如...
Execution failed: Can’t locate Env.pm in @INC (Perl script (roothas.pl)) – Mohammad Nazmul Huda
评论 | [root@testdb1 ~]# /opt/grid/product/11.2.0.3/crs/install/roothas.pl -deconfig Can't locate Env.pm in @INC (@IN...
Error ORA-31655 On DataPump Import (IMPDP) With Privileged
Applies to: Oracle Database – Enterprise Edition – Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2] Infor...
ENABLE_GOLDENGATE_REPLICATION
2014-03-20 13:27:40 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rdb3mis.prm: Virtual Memory Facilities for: CO...
Enable ARCHIVELOG and FLASHBACK mode on ASM
Tweet Recommend this on Google To enable ARCHIVELOG on ASM and configure FLASHBACK (without enabling it) you need to set...
Document Display_2
In this Document Symptoms Cause Solution Applies to: Oracle Database – Enterprise Edition – Version 11.2.0.3...
Document Display_1
In this Document Purpose Troubleshooting Steps What is a 'Cursor: pin S wait on X' wait? What causes 'Cur...
Document Display
Symptoms Changes Cause Bug 11788276## Solution References BUG:11788276
Document 1526158.1
文档内容 — ## 适用于: Oracle Database – Enterprise Edition – 版本 10.2.0.1 到 11.2.0.3 [发行版 10.2 到 11.2] 本文档所含信息...
Document 1492498.1
— ## Applies to: Oracle Server – Enterprise Edition – Version 11.2.0.1 and later Information in this d...
Document 1260095.1
Applies to: Oracle Database – Enterprise Edition – Version 11.2.0.1 to 11.2.0.4 [Release 11.2] IBM AIX on PO...
Document 1054736.6
## Applies to: Oracle Database – Enterprise Edition – Version 8.1.7.0 and later HP-UX PA-RISC (32-bit) Sympt...
Document 438580.1
— ## Applies to: Oracle Database – Enterprise Edition – Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to ...
Document 345180.1
— ## Applies to: Oracle Database – Enterprise Edition – Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to ...
Document 276554.1
— ## Applies to: Oracle Database – Enterprise Edition – Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to ...
Document 215858.1
<u>PURPOSE</u> This article explains how to use the HANGANALYZE utility to diagnose hanging issues in Oracle...