ITPub博客

首页 > 数据库 > Oracle > ashdump* scripts and post-load processing of MMNL traces (Doc ID 555303.1)

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

Oracle 作者:rongshiyuan 时间:2014-04-03 13:42:29 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-11-24

  • 博文量
    798
  • 访问量
    3253120