Yaping's Weblog

August 30, 2008

A very cool tool — orasrp

Filed under: Oracle — Yaping @ 4:22 am
Tags:

Orasrp is a very good tool to analyze trace file and it’s free.

@>alter session set events ‘10046 trace name context forever,level 12′;
Session altered.
@>alter index idx_t1_id rebuild online;
Index altered.
@>alter session set events ‘10046 trace name context off’;
Session altered.
@>@tracefile
Wrote file /tmp/myvar.sql
/opt/app/oracle/admin/chen/udump/chen_ora_2604.trc

[oracle@chen tmp]$ ./orasrp /opt/app/oracle/admin/chen/udump/chen_ora_2604.trc 1.html

Now we can view 1.html, the format is human and the result contains a lot of anlysis value.
Bind vary also specifies its value, very readable.

Refer to http://www.oracledba.ru/orasrp/

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: