Re: Does Anyone Have A SQL Timing Script?

This sounds too obvious but...here goes,

sqlplus user/password_at_sid
spool test1.fil;
set timing on;
sql statement test1;
set timing off;
spool off;
exit;

Looks good to me !

In article <95vv24$5tm$1_at_nnrp1.deja.com>,   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/
>

--
Back it up !


Sent via Deja.com
http://www.deja.com/