Re: Q: how to time a transaction

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 06 Apr 2007 13:50:31 -0700
Message-ID: <1175892627.243318@bubbleator.drizzle.com>

eAddict wrote:
> 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

My observation that this is going to grind scalability and performance into the dust is that you are 4 patches behind on a version of the database that begins desupport in just a few months.

Wouldn't your efforts better be spent upgrading to 10.2.0.3?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Apr 06 2007 - 15:50:31 CDT