Re: Q: how to time a transaction

On Apr 4, 9:40 am, "eAddict" <eAdd..._at_gmail.com> wrote:
> I have been requested to monitor EVERY transaction for how long it
> takes to run/complete. I know you can trace individaul transactions
> but is there a way to get each one? How would I time how long it
> takes from request to reply?
>
> Thanks!
> Vince

OK.... a bit of info that I forgot in the previous post. We are running Oracle 9.2.0.4 on HP-UX 11i. We have an oracle database as a backend to a software program. The users have noticed a severe slow down since the software got updated (the software NOT the DB). For example, it might have taken 3 sec to get a query back now it is 30+ sec. The company that wrote the code (the underlying SQL) says it ain't thier code, the network folks say it isn't thier network, the Citrix folks say it isn't them and I am only seeing 2-3 sec response times on average for all 400+ users on the database. Apparently there are a few very LONG transactions vs the zillion short ones.

I am looking for something that might help me with end-to-end transactions or failing that something that can show when a query hits the DB and sends the info back I can get that back on a granullar (sp?) level so I can either point out that the code is or is not the culprit.

Thanks for any light you can shed.
I am looking more for a direction to attack this vs someone doing it for me.
Vince Received on Fri Apr 06 2007 - 15:21:18 CDT