Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select * from dba_source does not give any output

user12195658Sep 23 2015 — edited Sep 25 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2015
Added on Sep 23 2015
25 comments
2,824 views