网络资源_ORACLE_调优
关注
分享
扫一扫
文章平均质量分 84
mybluetiankong
这个作者很懒，什么都没留下…
展开
-
How to Collect Diagnostics for Database Hanging Issues (文档 ID 452358.1)
In this Document Goal Solution What is needed to diagnose "Database Hang" issues? A. Dumps and Traces Hanganalyze and System转载 2013-11-23 08:21:41 · 912 阅读 · 0 评论 -
How to Reduce Parse Time Cpu (文档 ID 156262.1)
goal: How to reduce Parse Time Cpufact: Oracle Server - Enterprise Editionfix:Query V$SQLAREA to find frequently reparsed statements: SELECT SQL_TEXT, PARSE_CALLS, EXECUTIONS FROM V$SQLAREAO转载 2013-11-25 07:49:21 · 563 阅读 · 0 评论 -
High SQL Version Counts - Script to determine reason(s) (文档 ID 438755.1)
In this Document Purpose Ask Questions, Get Help, And Share Your Experiences With This Article Requirements Configuring In转载 2013-12-09 16:36:52 · 1277 阅读 · 0 评论 -
Tracing Sessions in Oracle Using the DBMS_SUPPORT Package (文档 ID 62160.1)
IntroductionThis is part of a set of articles which give an introduction to tuning Oracle. This particular article gives information about tracing user sessions using the DBMS_SUPPORT package. N原创 2013-12-02 09:56:11 · 578 阅读 · 0 评论 -
High Waits on 'Db File Sequential Read' Due to Table Lookup Following Index Access (文档 ID 875472.1)
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version 8.0.3.0 to 11.2.0原创 2013-12-02 09:16:25 · 765 阅读 · 0 评论 -
Troubleshooting: High Version Count Issues (文档 ID 296377.1)
In this Document Purpose Ask Questions, Get Help, And Share Your Experiences With This Article Troubleshooting Steps What is a 'High' Vers转载 2013-12-09 15:59:08 · 1959 阅读 · 0 评论 -
Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention (文档 ID 62143.1)
In this Document Purpose Introduction Ask Questions, Get Help, And Share Your Experiences With This Article Troubleshooting Steps转载 2013-12-15 17:07:58 · 1273 阅读 · 0 评论 -
How to Calculate Your Shared Pool Size (文档 ID 1012046.6)
***Checked for relevance on 29-Jul-2010*** ArchivingNOTE: This article was written for Oracle7 and Oracle8 databases. Withthe latest versions of Oracle it is best to use the advise information转载 2013-12-15 16:36:35 · 558 阅读 · 0 评论 -
VIEW: X$KSMLRU - LRU flushes from the shared pool - (7.3 - 8.1) (文档 ID 43600.1)
Note to customers:~~~~~~~~~~~~~~~~~~ This is an Oracle X$ table reference note which gives a summary description of the X$KSMLRU fixed view. This view exists in Oracle releases 7 through 8.1 bu转载 2013-12-16 17:04:56 · 546 阅读 · 0 评论 -
WAITEVENT: "library cache pin" Reference Note (文档 ID 34579.1)
"library cache pin" Reference NoteThis is a reference note for the wait event "library cache pin" which includes the following subsections:Brief definitionIndividual wait details (eg: For waits转载 2013-12-31 17:07:41 · 723 阅读 · 0 评论 -
How to Find which Session is Holding a Particular Library Cache Lock (文档 ID 122793.1)
APPLIES TO:Oracle Database - Personal Edition - Version 9.2.0.1 and laterOracle Database - Enterprise Edition - Version 9.2.0.1 and laterOracle Database - Standard Edition - Version 9.2.0.1 and转载 2014-01-01 09:27:27 · 818 阅读 · 0 评论 -
Library Cache 诊断：Lock, Pin 以及 Load Lock (文档 ID 1548524.1)
文档内容 用途 排错步骤 什么是"Library cache lock" ? 什么是"Library cache pin" ? 为什么需要这两种不同类型的锁? 减少Library Cache 竞争的一般建议转载 2013-12-31 15:21:45 · 1707 阅读 · 0 评论 -
LTOM - The On-Board Monitor User Guide (文档 ID 352363.1)
LTOM The On-Board Monitor User's GuideEmbedded Real-Time Data Collection and Diagnostics PlatformCarl DavisCenter of ExpertiseDecember 9, 2010Best PracticesPro-Active转载 2013-12-18 08:56:20 · 9551 阅读 · 1 评论 -
How to: Determine if a Package that is About to be Compiled is Being Used Currently (文档 ID 1054939.6
APPLIES TO:Oracle Server - Standard Edition - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]Oracle Server - Enterprise Edition - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]Information i转载 2014-01-01 11:26:37 · 764 阅读 · 0 评论 -
SCRIPT: FULLY DECODED LOCKING (文档 ID 1020008.6)
Abstract This script provides a complex fully decoded locking information which is much more detailed than the other two scripts in the series. Note 1020012.6 SCRIPT TO RETURN MEDIUM DETAIL L转载 2014-01-01 10:50:48 · 1522 阅读 · 0 评论 -
SCRIPT: Size Shared Pool using V$shared_pool_advice. (文档 ID 255409.1)
PURPOSE~~~~~~~~~~To make use of Shared Pool Advisory feature of Oracle 9.2.x and above. SCOPE & APPLICATION~~~~~~~~~~~~~~~~~~~~~~This document will help DBA's to use this feature(Shared pool A转载 2014-01-02 16:43:03 · 661 阅读 · 0 评论 -
The DBMS_SUPPORT Package (文档 ID 62294.1)
The DBMS_SUPPORT Package~~~~~~~~~~~~~~~~~~~~~~~~ This package is an add on to Oracle releases 7.2 onwards to provide a simple interface to some undocumented features of Oracle. As this exposes转载 2014-01-03 10:27:24 · 541 阅读 · 0 评论 -
Interpreting Raw SQL_TRACE output (文档 ID 39817.1)
APPLIES TO:Oracle Server - Standard Edition - Version 8.0.3.0 and laterOracle Server - Personal Edition - Version 8.0.3.0 and laterOracle Server - Enterprise Edition - Version 8.0.3.0 and later转载 2014-01-03 10:32:47 · 971 阅读 · 0 评论 -
H$PSEUDO_CURSOR (文档 ID 1298471.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 5-Nov-2012***PURPOSEPseudo curs转载 2014-01-04 10:57:07 · 839 阅读 · 0 评论 -
Troubleshooting 'cursor: pin S wait on X' waits. (文档 ID 1349387.1)
In this Document Purpose Troubleshooting Steps What is a 'Cursor: pin S wait on X' wait? What causes 'Cursor: pin S wait on X' waits?转载 2014-01-04 14:00:49 · 918 阅读 · 0 评论 -
Init.ora Parameter "_SQLEXEC_PROGRESSION_COST" [Hidden] Reference Note (文档 ID 68955.1)
Parameter: _SQLEXEC_PROGRESSION_COST ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Please note this is a hidden Oracle parameter and begins with an underscore character. The information on this parameter转载 2014-01-03 16:54:43 · 607 阅读 · 0 评论 -
Troubleshooting: Waits for Mutex Type Events (文档 ID 1377998.1)
In this Document Purpose Troubleshooting Steps Mutex Event Waits How to Identify Mutex Event Waits. Diagnosing Potential转载 2014-01-04 14:34:36 · 1062 阅读 · 0 评论 -
SCRIPT - to Set the 'SESSION_CACHED_CURSORS' and 'OPEN_CURSORS' Parameters(文档 ID 208857.1)
Abstract SCRIPT - to Tune the 'SESSION_CACHED_CURSORS' and 'OPEN_CURSORS' Parameters Product Name, Product VersionOracle Server Enterprise Edition Versions 8i, 9i, 10g an转载 2014-01-04 16:18:03 · 987 阅读 · 0 评论 -
Overview of ORA-1000 Maximum Number of Cursors Exceeded (文档 ID 1012266.6)
APPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]Information in this document applies to any platform.***Checked for relevance on 13-Jan-2012*转载 2014-01-04 17:27:00 · 1479 阅读 · 0 评论 -
WAITEVENT: "cursor: pin S wait on X" Reference Note (文档 ID 1298015.1)
"cursor: pin S wait on X" Reference NoteThis is a reference note for the wait event "cursor: pin S wait on X" which includes the following subsections:Brief definitionIndividual wait details (eg转载 2014-01-04 10:36:37 · 1431 阅读 · 0 评论 -
How to Determine the Blocking Session for Event: 'cursor: pin S wait on X' (文档 ID 786507.1)
In this Document Goal Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.转载 2014-01-04 11:26:29 · 855 阅读 · 0 评论 -
Diagnosing and Resolving Error ORA-04031 on the Shared Pool or Other Memory Pools (文档 ID 146599.1)
In this Document Purpose Troubleshooting Steps 1. Instance parameters related with the Shared Pool 2. Diagnosing error ORA-04031转载 2013-12-16 17:02:12 · 2448 阅读 · 0 评论 -
Monitoring Open Cursors & Troubleshooting ORA-1000 Errors (文档 ID 76684.1)
In this Document Purpose Scope Details ReferencesAPPLIES TO:PL/SQL - Version 10.2.0.4 and laterInformation in this documen转载 2014-01-04 16:39:35 · 726 阅读 · 0 评论 -
FAQ about OPEN and CLOSE Plsql Cursor in V$OPEN_CURSOR View (文档 ID 235291.1)
APPLIES TO:PL/SQL - Version 7.0.13 and laterInformation in this document applies to any platform.***Checked for relevance on 23-Aug-2013***PURPOSEThis note provides an example and will add转载 2014-01-05 10:32:49 · 1001 阅读 · 0 评论 -
Oracle X$ table list (文档 ID Note:22241.1)
Doc ID: Note:22241.1 Subject: List of X$ Tables and how the names are derived Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 14-MAR-1995 Last转载 2013-12-21 10:17:41 · 973 阅读 · 0 评论 -
OERR: ORA-4031 "unable to allocate %s bytes of shared memory ("%s","%s","%s")" (文档 ID 4031.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]Information in this document applies to any platform.PURPOSEThis article discusses the inte转载 2014-01-08 15:23:01 · 3886 阅读 · 0 评论 -
* Troubleshooting Performance Issues (文档 ID 1377446.1)
In this Document Purpose Best Practices Pro-Active Problem Avoidance and Diagnostic Collection Troubleshooting Steps Gener转载 2014-01-08 16:22:24 · 1052 阅读 · 0 评论 -
ORA-4031 Common Analysis/Diagnostic Scripts [Video] (文档 ID 430473.1)
In this Document Purpose Requirements Configuring Instructions Sample Code General Analysis of the Shared转载 2014-01-08 16:30:09 · 1453 阅读 · 0 评论 -
10.2.0.4 Patch Set - List of Bug Fixes by Problem Type (文档 ID 401436.1)
Bugs fixed in the 10.2.0.4 Patch SetSee Note:316900.1 for Support Status and Alerts affecting 10.2.0 releases.This note lists the customer bugs fixed in the 10.2.0.4 Patch Set which are not al转载 2013-12-25 16:50:19 · 9360 阅读 · 0 评论 -
Bug 13250244 - Shared pool leak of "KGLHD" memory when using multiple subpools (文档 ID 13250244.8)
Bug 13250244 Shared pool leak of "KGLHD" memory when using multiple subpools This note gives a brief overview of bug 13250244. The content was last updated on: 05-JUL-2013 Click here for detai转载 2013-12-26 10:50:46 · 1168 阅读 · 0 评论 -
Unsafe Literals or Peeked Bind Variables (文档 ID 377847.1)
In this Document Purpose Scope Details ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0转载 2013-12-26 15:21:23 · 787 阅读 · 0 评论 -
ORA-600 [4511] "Row locked by inactive ITL" (文档 ID 39553.1)
Note: For additional ORA-600 related information please read Note:146580.1PURPOSE: This article discusses the internal error "ORA-600 [4511]", what it means and possible actions. The informati转载 2014-01-12 15:00:31 · 1530 阅读 · 1 评论 -
What is an ORA-600 Internal Error? (文档 ID 146580.1)
In this Document Purpose Details ReferencesAPPLIES TO:Oracle Server - Personal EditionOracle Server - Standard EditionOracle Server - En转载 2014-01-12 15:10:40 · 1072 阅读 · 1 评论 -
Master Note for Diagnosing ORA-600 (文档 ID 1092832.1)
In this Document Details Actions Concepts/Definitions Diagnosing Common Issues Additional Resources转载 2014-01-12 15:36:35 · 1112 阅读 · 0 评论 -
ORA-600/ORA-7445/ORA-700 Error Look-up Tool (文档 ID 153788.1)
NEW: For ORA-7445 errors, if you have the related trace file, consider trying the MOS ORA-7445-Troubleshooting Tool CLICK HEREFor ORA-600 errors, if you have the rela转载 2014-01-12 15:40:22 · 3214 阅读 · 0 评论