Hi all DBAs,
Iam into Fine tuning of the database.(oracle8.1.6-HPUX11.0).
I got all the sql statements which r causing the most cpu usage.
But,even after fine tuning the queries I need to replace them with the old ones.but they could be coming from a jsp file are a forms or report.
How to identify the corresponding file..
I mean to say how to identify the source file of the query.
Please help me in this regard.
thanks in advance.