ITPub博客

[@more@]This is a reference note for the wait event "buffer busy waits" which includes the following subsections:Brief definitionIndividual wait details (eg: For waits seen in <>)Systemwide wait details (eg: For waits seen in <>)Reducing waits / wait timesSee Note:61998.1 for an introduction to Wait Events.Definition:Versions:7.0 - 10.2 Documentation: 9.0This wait happens when a session wants to access a database block in the buffer cache but it cannot as the buffer is &quo

[@more@]Note: For additional ORA-600 related information please read Note:146580.1PURPOSE: This article discusses the internal error "ORA-600 [729]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [729] [a]VERSIONS: versions 7.0 to 10.1 DESCRIPTION: A space leak has been detected in the User Global Area (UGA). There is NO data corru

[@more@]Contents Introduction Overview of Steps to handle a Corruption Corruption due to NOLOGGING or UNRECOVERABLE (1) Determine the Extent of the Corruption Problem (2) Replace or Move Away from Suspect Hardware (3) Which Objects are Affected ? Options for various Segment Types: CACHE CLUSTER INDEX PARTITION INDEX LOBINDEX LOBSEGMENT ROLLBACK TABLE PARTITION TABLE TEMPORARY IOT TYPE2 UNDO Other Segm

[@more@]Introduction ============ Truss and trace are utilities that exist on SOME Unix boxes. These are NOT general purpose tools and should not be used to help progress a problem unless their output has been requested by Oracle Support or is understood and is likely to be of help. This short article describes what truss and trace are and how to use them. Warning: These tools produce a LOT of output. What do these util

[@more@]Purpose: This bulletin focuses on latches. It attempts to give a clear understanding of how latches are implemented in the Oracle RDBMS and what causes latch contention. The information provided can be used in tuning the various kinds of latches discussed. Contents: 1. What is a Latch? 2. Latches vs Enqueues 3. When do we need to obtain a latch? 4. Latches request modes? 5.

[@more@]Purpose ======= This article describes instructions for obtaining a stack trace for all threads from a core file. Once you have obtained the requested information, please supply it to support in the manner that support requests. Initial Steps ============= Rename the core to something other than 'core'. This is in case there is a failure during the command execution that would create another core file which would overwrite the original core file, for example, core.date

[@more@]Introduction ~~~~~~~~~~~~ This short article aims explain how to get a stack trace from a core dump produced by any of the Oracle products. By following the steps below you can provide Oracle Support with vital information to help identify the cause of a problem. Please note that it is important to include information about the tool being used, any code involved, the operation being performed, environment etc.. in addition