Re: Monitoring Insers & Updates

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 9 Aug 1999 20:11:03 +0200
Message-ID: <934222272.29297.0.pluto.d4ee154e@news.demon.nl>

Why doesn't he simply issue
set timing on
in sqlplus and you will get the time in hundreths of seconds. Or set timed_statistics =true in init<sid>.ora, and trace his session. If you are a DBA, you should have the same experience as I have: in 80 percent of all databases with performance problems the application design is to blame, and tuning Oracle will not remedy it.

Hth,

Sybrand Bakker, Oracle DBA

<goyakat_at_my-deja.com> wrote in message news:7on2b9$nhl$1_at_nnrp1.deja.com...
> 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:03 CDT