- 博客(71)
- 资源 (6)
- 收藏
- 关注
RSS订阅转载 How to Interpret the "SQL ordered by Physical Reads (UnOptimized)" Section in AWR (文档 ID 1466035.1)
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
2014-01-21 11:43:09
2501
转载 How to Interpret the OS stats section of an AWR report (文档 ID 762526.1)
In this Document Goal FixAPPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.1 and laterInformation in this document applies to any platform.
2014-01-21 11:34:50
1046
转载 123
LatchFreeThe latch free wait event has three parameters: latch address, latch number, and the number of tries. In Oracle Database 10g, depending on the latch wait event, it can fall under the Co
2014-01-21 08:46:25
1014
转载 How to Read Buffer Cache Advisory Section in AWR and Statspack Reports. (文档 ID 754639.1)
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
2014-01-20 20:51:48
826
转载 How to Read PGA Memory Advisory Section in AWR and Statspack Reports (文档 ID 786554.1)
In this Document Goal SolutionAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 and laterInformation in this document applies to any platf
2014-01-20 16:55:54
1356
转载 常见问题:如何使用AWR报告来诊断数据库性能问题 (文档 ID 1523048.1)
文档内容 目标 最佳实践 如何主动避免问题发生及做好诊断信息的收集 解决方案 Interpretation Top 5 Timed Events SQL Statistics
2014-01-20 16:44:36
1086
转载 " Library Cache: Mutex X " On Koka Cursors (LOBs) Non-Shared : (文档 ID 758674.1)
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
2014-01-20 15:37:33
1585
转载 "Cursor: Pin S Wait On X" Contention Mutex Sleep Reason Primarily (文档 ID 1268724.1)
In this Document Symptoms Changes Cause Solution ReferencesThis document is being delivered to you via Ora
2014-01-20 15:19:58
1172
转载 Troubleshooting: "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! " (文档 ID 278316.1)
In this Document Purpose Troubleshooting Steps What is a Row Cache Enqueue Lock? What is the meaning of the warning WAITED TOO LONG FOR
2014-01-20 15:07:14
3975
转载 High 'cursor: pin S wait on X' . Cause: Shared Pool/Buffer Cache Resize Activity (文档 ID 742599.1)
In this Document Symptoms Changes Cause Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition -
2014-01-20 11:16:54
1207
转载 Wrong wait events in 11.2 ("cursor: mutex S" instead of "cursor: mutex X") (文档 ID 9591812.8)
Bug 9591812 Wrong wait events in 11.2 ("cursor: mutex S" instead of "cursor: mutex X") This note gives a brief overview of bug 9591812. The content was last updated on: 28-JUN-2013 Click here
2014-01-20 10:53:13
831
转载 How to Collect Errorstacks for use in Diagnosing Performance Issues. (文档 ID 1364257.1)
In this Document Goal Solution Introduction Gathering Errorstacks Gathering Errorstacks on Your Current session Command ExplanationAPPLIES TO:Oracle Server
2014-01-20 10:22:36
650
转载 常见问题：'cursor:mutex ..'/ 'cursor:pin ..'/ 'library cache:mutex ..'类型的等待事件 (文档 ID 1525791.1)
In this Document Purpose Questions and Answers 什么是 'cursor: ' 等待事件？ 最常见的等待事件是什么？ 等待事件最常见的原因是什么？ 如何避免这些等待事件？
2014-01-20 10:11:04
2375
转载 WAITEVENT: "cursor: pin S" Reference Note (文档 ID 1310764.1)
"cursor: pin S" Reference NoteThis is a reference note for the wait event "cursor: pin S" which includes the following subsections:Brief definitionIndividual wait details (eg: For waits seen in
2014-01-20 09:47:26
1248
转载 OSWatcher Black Box（包括：[视频]） (文档 ID 1526578.1)
文档内容 用途 适用范围 详细信息 OSWatcher 简介 OSWatcher 下载 OSWatcher 用户手册 版本：最新版本 7.0.3 2013年11月18日
2014-01-20 09:30:50
1300
转载 Enhancement to obsolete parent cursors if VERSION_COUNT exceeds a threshold (文档 ID 10187168.8)
Bug 10187168 Enhancement to obsolete parent cursors if VERSION_COUNT exceeds a threshold This note gives a brief overview of bug 10187168. The content was last updated on: 28-JUN-2013 Click he
2014-01-19 10:41:41
809
转载 WAITEVENT: "library cache: mutex X" (文档 ID 727400.1)
In this Document Purpose Scope Details Definition: Individual Waits: Systemwide Waits: Wait
2014-01-19 09:56:34
4175
转载 Troubleshooting 'library cache: mutex X' waits. (文档 ID 1357946.1)
In this Document Purpose Troubleshooting Steps What is a 'library cache: mutex X' wait? What causes 'library cache: mutex X' wait?
2014-01-19 09:32:59
866
转载 Bug 7307972 - Excessive waits on 'library cache: mutex x' (文档 ID 7307972.8)
Bug 7307972 Excessive waits on 'library cache: mutex x' This note gives a brief overview of bug 7307972. The content was last updated on: 18-NOV-2010 Click here for details of each of the sect
2014-01-18 19:56:49
604
转载 Bug 9239863 - Excessive "library cache:mutex X" contention on hot objects (文档 ID 9239863.8)
Bug 9239863 Excessive "library cache:mutex X" contention on hot objects This note gives a brief overview of bug 9239863. The content was last updated on: 28-JUN-2013 Click here for details of
2014-01-18 19:45:21
771
转载 Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes (文档 ID 459694.1)
In this Document Purpose Scope Details DOWNLOAD PROCWATCHER Requirements Procwatcher Features
2014-01-18 19:21:45
1609
转载 * TROUBLESHOOTING: Possible Causes of Poor SQL Performance (文档 ID 33089.1)
In this Document Purpose Troubleshooting Steps Diagnostics/Remedies 1. Poorly tuned SQL 2. Poor disk performance/disk cont
2014-01-17 15:57:35
814
转载 Automatic Workload Repository (AWR) Reports - Start Point (文档 ID 1363422.1)
In this Document Purpose Scope Automatic Workload Repository (AWR) Overview Details Collecting AWR reports
2014-01-17 15:33:58
1131
转载 How to Generate an AWR Report and Create Baselines (文档 ID 748642.1)
In this Document Goal Solution Running a Basic Report Generating Various Types of AWR Reports Various Useful Operations
2014-01-17 14:29:51
996
转载 How to Pin a Cursor in the Shared Pool using DBMS_SHARED_POOL.KEEP (文档 ID 726780.1)
In this Document Goal Fix ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version 8.0.3.0 and laterOracle Server - Personal Edit
2014-01-16 16:01:06
680
转载 Using a Procedure to KEEP Cursors Executed> 10 times (文档 ID 130699.1)
APPLIES TO:Oracle Server - Enterprise Edition - Version 7.0.16.0 to 11.2.0.3 [Release 7.0 to 11.2]Information in this document applies to any platform.GOALThe purpose of this article is to e
2014-01-16 15:51:57
823
转载 用GDB调试程序
用GDB调试程序（一）GDB概述————GDB是GNU开源组织发布的一个强大的UNIX下的程序调试工具。或许，各位比较喜欢那种图形界面方式的，像VC、BCB等IDE的调试，但如果你是在UNIX平台下做软件，你会发现GDB这个调试工具有比VC、BCB的图形化调试器更强大的功能。所谓“寸有所长，尺有所短”就是这个道理。一般来说，GDB主要帮忙你完成下面四个方面的功能：
2014-01-16 10:16:33
687
转载 常见问题:如何使用AWR报告来诊断数据库性能问题 (文档 ID 1523048.1)
文档内容 目标 最佳实践 如何主动避免问题发生及做好诊断信息的收集 解决方案 Interpretation Top 5 Timed Events SQL Statistics
2014-01-16 09:58:24
2202
转载 Systemwide Tuning using STATSPACK Reports (文档 ID 228913.1)
APPLIES TO:Oracle Database - Enterprise EditionInformation in this document applies to any platform.PURPOSEThis article is a reference to understand the output generated by the STATSPACK uti
2014-01-16 09:42:01
1448
转载 Gathering a StatsPack snapshot (文档 ID 149121.1)
PURPOSE-------This note is intended to provide information about the steps required to take a StatsPack snapshot of current database performance levels and how to capture different granularities
2014-01-16 09:40:09
623
转载 Statistics Package (STATSPACK) Guide (文档 ID 394937.1)
In this Document Goal Fix 0. Introduction and Terminology How does Statspack work? 1. Enterprise Manager (EM), Automat
2014-01-16 09:38:47
2162
转载 Installing and Configuring StatsPack Package (文档 ID 149113.1)
PURPOSE-------This note is intended to provide configuring and installing information about the StatsPack package.SCOPE & APPLICATION-------------------This note is applicable for Oracle RDBMS
2014-01-16 09:36:26
591
转载 Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM (文档 ID 276103.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.10.1.0.2 to 10.2.0.5 [Release: 10.1 to 10.2]PURPOSEPurp
2014-01-16 08:52:41
1127
转载 Introduction to Adaptive Cursor Sharing Concepts and Multimedia Demo [Video] (文档 ID 1115994.1)
In this Document Goal FixThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to
2014-01-16 08:24:59
537
转载 Adaptive Cursor Sharing: Worked Example (文档 ID 836256.1)
In this Document Purpose Scope Details ReferencesAPPLIES TO:Oracle Server - Enterprise Edition - Version 11.1.0.6 and later
2014-01-16 08:23:32
577
转载 Adaptive Cursor Sharing: Overview (文档 ID 740052.1)
In this Document Purpose Scope Details Introduction Advantages and Disadvantages of Adaptive Cursor Sharing
2014-01-16 08:22:35
786
转载 SQLT 诊断工具 (文档 ID 1526574.1)
文档内容 主要内容 下载 SQLTXPLAIN (SQLT) SQLTXPLAIN (SQLT) 简介 安装 SQLTXPLAIN 参考资料 SQLTXPLAIN FAQ SQLT 网
2014-01-15 09:59:38
1644
转载 How To Quickly Add/Remove Column Statistics (Histograms) For A Column (文档 ID 390249.1
In this Document Goal FixAPPLIES 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
2014-01-14 17:14:38
693
转载 How to Submit a Testcase to Oracle Support for Reproducing an Execution Plan (文档 ID 390610.1)
In this Document Goal Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterInformation in this do
2014-01-14 16:20:04
678
转载 How to Obtain Tracing of Optimizer Computations (EVENT 10053) (文档 ID 225598.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.Checked for relevance on 03-Jan-2012PURPOSETo provide in
2014-01-14 16:05:43
746
Solaris pstack.sh
2013-11-27
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人