Re: Scripts to pull BSTAT & ESTAT Trace Data

Selena,

You only need to use TKPROF with SQL Trace.

When you run BSTAT, some tables are populated with the current state of the database. When you run ESTAT, some tables are populated with the current state of the database. The difference is the change in state between the times BSTAT and ESTAT was run. Also, when you run ESTAT, a report will be created for you. This report is called REPORT.TXT and will reside in your current directory when you envoked SQL*Plus (or SVRMGR). This report is probably what you are looking for.

HTH,
Brian

lenaf7_at_yahoo.com wrote:
>
> Hi,
>
> Does anyone have any scripts that they can share, which will pull the
> same information from the database, instead of running SQL Trace, BSTAT
> & ESTAT and then using TKPROF to view the files?
>
> Let me know,
>
> Thanks,
> Selena
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================