Re: Does Anyone Have A SQL Timing Script?

There is an option with tkprof that will generate SQL insert statements to load the info into a table. It could be analysed from there.

HTH
   James

In article <3A83F911.CDD6589A_at_usgs.gov>,   Brian Peasland <peasland_at_usgs.gov> wrote:
> There is no easy script which will capture the information that you
> desire. What you can do is turn SQL_TRACE to TRUE for your session and
> execute your statements (you'll also need TIMED_STATISTICS=TRUE in
 your
> INIT.ORA). When you are done, set SQL_TRACE=FALSE. Then run TKPROF
> against your trace file. Each of your SQL statements will show up with
> timing information. You can then manually collate your own report. I
> suppose one could write a parser to glean the information out of the
> TKPROF results.......
>
> HTH,
> Brian
>
> navaed_at_my-deja.com wrote:
> >
> > All,
> >
> > Has anyone created a nice script that times the
> > performance of multiple SQL commands to alter a
> > table? What I would like to do is run about 20
> > or so Insert, Delete, and Update commands on a
> > table and see how long they took to execute. The
> > report that would look similar to this:
> >
> > Job_Id Command Success Begin_Time End_Time Durration
> > ------ ------- ------- ---------- -------- ---------
> > 1 Insert True 10:01:06 10:02:06 00:01:00
> > 2 Insert True 10:03:06 10:04:06 00:01:00
> > .
> > .
> > 21 Delete True 10:45:05 10:46:05 00:01:00
> > 22 Delete True 10:47:05 10:48:05 00:01:00
> > .
> > .
> > 41 Update True 11:08:03 11:09:03 00:01:00
> > 42 Update True 11:10:03 11:11:03 00:01:00
> >
> > I know there is the Timing Utility you can set to ON,
> > but how do you capture the timestamp?
> >
> > I am using Oracle 8i 7.1.3 Release 3 For Linux (kernel
> > 2.2.16) Any help is greatly appreciated.
> >
> > -Dan
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 09 2001 - 10:47:23 CST