Re: Does Anyone Have A SQL Timing Script?

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!
========================================