Time spent by DB for a particular query

Thread view:

gp - 29 Aug 2005 21:59 GMT

Hi,
I use Oracle 10g as my backend repository. I am trying to do some
performance analysis against this DB.

All I need is time spent by DB for a particular query.

I used statspack to capture DB statistics. But, I am not able to
comprehend usefull information from the report.

How can I get that information.
If not statspack, are there any other tools?

Thanks,
gp

Reply to this Message

Roy Brokvam - 29 Aug 2005 23:49 GMT

You should ask this question in the Oracle groups, as this is not a Java
question at all. There are several Oracle tools that will help you analyze
your query, and Statspack is one of the most powerful. It is well documented
in the Oracle documentation.

Regards,
Roy

> Hi,
> I use Oracle 10g as my backend repository. I am trying to do some
[quoted text clipped - 10 lines]
> Thanks,
> gp

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...