Common X$ dictionary table queries for ORA-4031 investigation

LAST UPDATE:

APPLIES TO:

PURPOSE:
There are a number of x$ queries in various notes in WebIV. This note is an attempt to collect the commonly used scripts for investigating Shared Pool problems in one place. Attached is a ZIP file with the common scripts for analysis of fragmentation and/or memory problems.

Click here (last updated 2-11-2009) to download the attached zip file.

SOFTWARE REQUIREMENTS/PREREQUISITES:

RUNNING THE SAMPLE CODE:
Scripts:

CAUTION:

SAMPLE CODE:

SAMPLE CODE OUTPUT:
ChunkOverview.sql spools to chunkoverview.out

ChunkClassBreakdown.sql spools to chunksummary.out

ChunkByTypeClass.sql spools to chunkbytype.out

ChunkBreakdown.sql spools to chunks.out

Attachments:
Various internal scripts – 02-11-2009(2.59 KB)

参考:
Common X$ dictionary table queries for ORA-4031 investigation (Doc ID 742575.1 INTERNAL)

相关文章

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据