Monitoring Insers & Updates

From: <goyakat_at_my-deja.com>
Date: Mon, 09 Aug 1999 17:15:34 GMT
Message-ID: <7on2b9$nhl$1@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 - 12:15:34 CDT