Re: Monitoring Insers & Updates

If you are using Sqlplus you can >Set timing on

                                                > Insert ....
                                will show the time elapsed...

If you want more details like the Executing Path,Cpu consumed , you can Enable sql_trace and Use Tkprof to format the trace file to read the details..like

>alter session set sql_trace=true;
>Insert...
>alter session set sql_trace=false;

This produces a Trace file which normally gets collected in the Directory specified by
USER_DUMP_DEST in your Init or config.ora files. Then you can go to that directory and
$tkprof <Trace_file> <output_file> explain=user/password sys=no will produce a Ascii file containing the session details...

hope this helps..

-Thiru

goyakat_at_my-deja.com wrote:

> I've done all sorts of memory tweaking & now my main apps programmer
> wants to know how long it takes to do 1,000 inserts & then how long to
> do a 1,000 updates. He wants to know if it's the database or the app
> that's sluggish.
>
> AND I can't seem to find any scripts in all the tuning books for this
> (there are plenty of scripts for testing memory use, rollback segs,
> logs). HELP!
>
> Isn't there a time variable I can turn on (or print start time) - run
> the insert script & then print end time?? Where is this magical time(s)
> kept in the data dictionaries??
>
> thanks.
> erin
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 09 1999 - 13:11:54 CDT