ashdump* scripts and post-load processing of MMNL traces (Doc ID 555303.1)

rongshiyuan發表於2014-04-03
ashdump* scripts and post-load processing of MMNL traces (Doc ID 555303.1)

In this Document

Purpose
Requirements
Configuring
Instructions
Script
References

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 and later
Information  in this document applies to any platform.
The scripts help upload and process MMNL trace files.
Similar scripts can be found on he Oracle CD companion.

Purpose

The scripts in this document are to be used in conjunction with Document 243132.1 10g and above Active Session History (Ash) And Analysis Of Ash Online And Offline

Script Details
============
1. ashdump_loader Main script to run with one argument. Argument is the the name of the tracefile.
2. ashdump_table.sql Called by the main script to create the table called ASHDUMP.
3. ashdump_sqlldr.ctl Called by main script to load the trace file into table ASHDUMP.
4.ashdump_post.sql  Post-Load processing of the data once loaded.

Requirements

SQL*Plus and SQL*Loader 10gR2.

Configuring

1) Place attached scripts in a directory
2) Copy the MMNL files to upload to the same directory
3) $ sqlplus system @ashdump_table.sql

Instructions

1) run ashdump_loader giving as parameter each of the MMNL files to upload.
2) Run once : $ sqlplus system @ashdump_post.sql

Caution

This sample code is provided for educational purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.

Proofread this sample code before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns), this sample code may not be in an executable state when you first receive it. Check over the sample code to ensure that errors of this type are corrected.

Script

Attached Script
1. Attachment 555303.1:LDRashdump_loader
2. Attachment 555303.1:TBLashdump_table.sql
3. Attachment 555303.1:CTLashdump_sqlldr.ctl
4. Attachment 555303.1:PSTashdump_post.sql

References

 

Attachments

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1135378/，如需轉載，請註明出處，否則將追究法律責任。

相關文章