Re: Bottleneck analysis
From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 07 Sep 2002 23:32:40 GMT
Message-ID: <Xns9282A84DB1D7BSunnySD_at_68.6.19.6>
Date: Sat, 07 Sep 2002 23:32:40 GMT
Message-ID: <Xns9282A84DB1D7BSunnySD_at_68.6.19.6>
kumar_kmk_at_hotmail.com (Kumar) wrote in news:bce41b15.0209070823.49b0a0ab_at_posting.google.com:
> Hi
> We have a java program making jdbc calls to the database (Oracle thin
> driver).
> We have some direct SQL calls and some cals to stored procedures. I
> would like to know which query is taking most time as the number of
> people accessing my program increase. Are there any tools ( free is
> better) available for this kind of analysis.
>
> Thanks
>
Enable SQL_TRACE and then run the output trace file through tkprof.
P.S.
Be sure to set the dump file size to UNLIMITED for the session being traced.
HTH & YMMV HAND! Received on Sun Sep 08 2002 - 01:32:40 CEST