Re: Application, session and performance.

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 24 Mar 2007 18:23:46 GMT
Message-ID: <S0eNh.82312$Ko5.18078@newsfe08.phx>

gxchristian_at_yahoo.co.uk wrote in news:1174759833.717517.124640 @n59g2000hsh.googlegroups.com:

> Hello,
>
> I need to monitor the performance of an application that executes
> queries against an Oracle database. Given the application -Access- has
> almost no way to trace activity inside it, I need to control its
> performance from Oracle.
>
> Given the requirements I have from the application monitoring, I am
> lead to measure:
>
> - Time it takes to execute specific transactions for specific users.
> - Time between two commits (application/transaction) for specific
> users.
> - Long-running queries (with user data about who launched them).
>
> I have read some stuff here and there, but still feel I need some
> guidance. I have also read about specific functionality in Oracle 10g
> around performance.... would it cover my needs?. Any tip or way to
> face this?.
>
> Many thanks,
> George.
>
>

Please restate your question, because I don't understand what you are asking.

Can YOU modify the application you are being asked to monitor?

What OS name & version?
Which version of Oracle to 4 decimal places? Received on Sat Mar 24 2007 - 13:23:46 CDT