EVENT: DROP_SEGMENTS - Forcing cleanup of TEMPORARY segments
Doc ID: Note:47400.1 Type: REFERENCE Last Revision Date: 05-OCT-2005 Status: PUBLISHED The DROP_SEGMENTS event~~~~~~~~~~~~~~~~~~~~~~~ Available from 8.0 onwards. ...
How to Relink Oracle Database Software on UNIX
Doc ID: Note:131321.1 Type: BULLETIN Last Revision Date: 06-OCT-2006 Status: PUBLISHED PURPOSE-------Provide relinking instructions for Oracle Database softwareon UNIX platforms. SCOPE & APPLICATI...
FAQ - Flash Recovery Area feature of 10G
Doc ID: Note:305817.1 Type: FAQ Last Revision Date: 06-OCT-2005 Status: PUBLISHED FLASH RECOVERY AREA --------------------FREQUENTLY ASKED QUESTIONS--------------------------CONTENTS--------1. Wha...
Using Bitmap Join Indexes to Avoid Join Operations
Doc ID: Note:149521.1 Type: BULLETIN Last Revision Date: 28-AUG-2002 Status: PUBLISHED PURPOSE-------Discuss Bitmap Join Index (BJI) Functionality.SCOPE & APPLICATION-------------------Warehouse DBAs ...
Local Materialized View Fast Refresh Restrictions
Doc ID: Note:222843.1 Type: BULLETIN Last Revision Date: 04-DEC-2003 Status: PUBLISHED PURPOSE-------This note describes 9i Local Aggregate Materialized View Fast Refresh Restrictions.RELATED DOCUMENT...
ORA-12051 or ORA-12054 when Creating Local Materialized View
Doc ID: Note:101705.1 Type: PROBLEM Last Revision Date: 24-APR-2006 Status: PUBLISHEDProblem Description-------------------You are trying to create a materialized view which refreshes automaticall...
Performance Slowdown During Heavy Undo Segment Onlining
文档 ID: 注释:301432.1 类型: PROBLEM 上次修订日期: 12-JUN-2005 状态: MODERATED Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.5This problem can occur on any platform.SymptomsSever...
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN
Doc ID: Note:223543.1 Type: FAQ Last Revision Date: 22-MAR-2006 Status: PUBLISHED How to recover from a DROP or TRUNCATE table by using RMAN.-----------------------------------------------------------...
Nested Materialized Views: Creation / Refresh Overview and ORA-12053
Doc ID: Note:212553.1 Type: BULLETIN Last Revision Date: 13-NOV-2002 Status: PUBLISHEDPURPOSE-------To explain in details how to fast refresh a Nested Materialized View. SCOPE & APPLICATION-------...
Materialized View Refresh : Log Population and Purge
Doc ID: Note:236233.1 Type: BULLETIN Last Revision Date: 09-DEC-2003 Status: PUBLISHED Overview========The purpose of this article is to explain Oracle’s materialized view fast refresh mechanism....
EVENT: 10231 "skip corrupted blocks on _table_scans_"
Doc ID: Note:21205.1 Type: REFERENCE Last Revision Date: 20-APR-2006 Status: PUBLISHED Event: 10231Text: skip corrupted blocks on _table_scans_--------...
ORA-600 [3020] On Standby When Adding a Datafile On Primary
Doc ID: Note:277620.1 Type: PROBLEM Last Revision Date: 11-JAN-2006 Status: PUBLISHED The information in this document applies to: Oracle Server - Ente...
HOW TO FIND THE SESSION HOLDING A LIBRARY CACHE LOCK
Doc ID: Note:122793.1 Type: TROUBLESHOOTING Last Revision Date: 25-JUL-2005 Status: PUBLISHED PURPOSE------- In some situations it may happen your session is 'hanging' and is awaiting for a 'Libr...
Differences Between Rowid & Primary Key Materialized Views
Doc ID: Note:254593.1 Type: BULLETIN Last Revision Date: 18-JAN-2005 Status: PUBLISHEDDifferences Between Rowid & Primary Key Materialized Views ==================================================...
Firewalls, Windows NT and Redirections
Doc ID: Note:66382.1 Type: BULLETIN Last Revision Date: 03-JUN-2005 Status: PUBLISHED PURPOSETo explain how firewalls work when a Windows NT server is involved.RELATED DOCUMENTSNote 45226.1 SQL*Net an...
DB crash with ORA-1092 and ORA-980 While startup
Doc ID: Note:280928.1 Type: PROBLEM Last Revision Date: 19-JUN-2005 Status: PUBLISHED Applies to: Oracle Server - Enterprise Edition - Version: 9.2 to 9.2Thi...
LOG_BUFFER Differs from the Value Set in the spfile or pfile
Doc ID: Note:373018.1 Type: PROBLEM Last Revision Date: 01-SEP-2006 Status: MODERATED Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1.0This problem can occur on any platform.Sym...
RMAN DUPLICATION FAILS WITH RMAN-600 [7002] IF NEWNAME FOR NON-DB FILES IS USED
Bug No. 2624658 Filed 14-OCT-2002 Updated 27-JAN-2003 Product Oracle Server - Enterprise Edition Product Version 9.2.0.1.0 Platform AIX 4.3 Based Systems (64-bi...