mybluetiankong的专栏

In this Document Symptoms Changes Cause Solution ReferencesThis document is being delivered to you via Ora

文档内容 目标 最佳实践 如何主动避免问题发生及做好诊断信息的收集 解决方案 Interpretation Top 5 Timed Events SQL Statistics

In this Document Goal SolutionAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 and laterInformation in this document applies to any platf

In this Document Goal SolutionAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2]Information in this doc

In this Document  Symptoms  Changes  Cause  Solution  ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1Oracle Se

In this Document Purpose Troubleshooting Steps What is a Row Cache Enqueue Lock? What is the meaning of the warning WAITED TOO LONG FOR

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.GOALThis document describes the 'SQL ordered by Physical Read

Oracle Performance Diagnostic Guide Welcome to the Oracle Performance Diagnostic Guide   This guide is intended to help you resolve query tuning, hang/locking, and slow database issues.  The

In this Document  Purpose     What is the Issue?  Scope and Application     Who is Affected?  Enterprise Manager Database Control Configuration - Recovering From Errors Due to CA Expiry on O

"buffer busy waits" Reference NoteThis is a reference note for the wait event "buffer busy waits" which includes the following subsections:Brief definitionIndividual wait details (eg: For waits

In this Document Purpose Scope Details Terminology ORA-01555 Explanation Solutions Examples

Bug 4742607  "cache buffer chains" latch contention from concurrent index range scans This note gives a brief overview of bug 4742607.  The content was last updated on: 03-APR-2009 Click here fo

"log file parallel write" Reference NoteThis is a reference note for the wait event "log file parallel write" which includes the following subsections:Brief definitionIndividual wait details (eg

"log file sync" Reference NoteThis is a reference note for the wait event "log file sync" which includes the following subsections:Brief definitionIndividual wait details (eg: For waits seen in

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

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

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

In this Document Purpose Scope Details ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.1 and later

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

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 DocumentPurpose Details Temporary Tablespaces Creating a Temporary Tablespace Altering a Temporary Tablespace

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 Concepts Instance Recovery When Oracle Database Performs Instance Reco

"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 Performance Tips ReferencesAPPLIES TO:Oracle Server - Enterprise Editi

In this DocumentPurpose Troubleshooting Steps Concepts Common Issues Involving Temporary Tablespaces ORA-1630 / ORA-1652

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

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

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