Hi There,
we are facing a performance issue in oracle 10.2.0.4.0 on Solaris.
so for that we had generated the AWR Report to analyse the report.
in the Report we had found a query which is coming in TOP 3 SQL statements by CPU Utilization.
Below is the Query:
2d9d68qpr99u8 select count(*) from CUSTOMER where CUSTOMER_ID like :"SYS_B_0"
so we decided to drill down to know of which object this query is part of.
so we try to find out the actual object (procedure,view,function,package) which is having this query with the help of below query:
select * from all_SOURCE where text like '%select count(*) from CUSTOMER%;
But it is not showing anything in the result.
how can i find the exact source of the query ???
thanks