PURPOSE=======The purpose of this article is to provide an understanding of FREELISTS andFREELIST GROUPS.SCOPE & APPLICATION===================This article is intended to be used by DBAs to h...
APPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.5.0 to 9.2.0.3 [Release 8.1.5 to 9.2]Oracle Database - Personal Edition - Version 8.1.5.0 to 9.2.0.3 [Release 8.1.5 to 9.2]Informati...
index$_join$ or Other Internal Table Appears in Audit Trail Instead of Base Table. (Doc ID 955968.1)
In this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been...
"enqueue" Reference NoteThis is a reference note for the wait event "enqueue" which includes the following subsections:Brief definitionIndividual wait details (eg: For waits seen in Systemwide w...
In this DocumentPurpose Scope Details Concepts Instance Recovery When Oracle Database Performs Instance Reco...
In this DocumentPurpose Troubleshooting Steps Concepts Common Issues Involving Temporary Tablespaces ORA-1630 / ORA-1652...
Problem Description-------------------You see connections start to hang and CI locks that are hangingthe system. You suspect that there is a locking problem. When youcheck v$lock, you find sessio...
In this DocumentPurpose Scope Details Performance Tips ReferencesAPPLIES TO:Oracle Server - Enterprise Editi...
In this DocumentPurpose Details Temporary Tablespaces Creating a Temporary Tablespace Altering a Temporary Tablespace...
The DROP_SEGMENTS event~~~~~~~~~~~~~~~~~~~~~~~ Available from 8.0 onwards. DESCRIPTION Finds all the temporary segments in a tablespace which are not currently locked and drops them....
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later [Release: 11.1 and later ]Linux x86Linux ...
Jump to: For 12c requirements refer to Note 1587357.1 AIX HP-UX (PA-RISC and Itanium) Linux x86 Linux x86-64 Linux Itanium Linux on Power Linux on zSeries Mac OS X (PowerPC and x86...
In this Document Purpose Scope Details ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.1 and later...
Pre-Install checks for 10gR2 RDBMS on Linux x86PurposeNOTE: This standalone HCVE script has been de-supported and fully decommissioned as of August 25th, 2006. All standalone HCVE scripts ha...
NOTE: This document is provided as legacy information from the Oracle 8i-9i Timeframe. Although commands in this document may still function, you are recommended to use articles designed specifically...