Hi all,
One day, I got my system hang and after investigate by my DBA, he found a statement execute with large amount resource.
I reviewed that statement, it is abnormal and shouldnt be execute in case. Thus, I try to search where using this statement.
I tried query the part or the whole statement in:
user_source
DBA_SOURCE
DBA_VW(customer table from DBA but only included views)
I can find part of the information, such as the table name involved; But I cannot find the exact statement that my DBA found for me.
May I ask is there any location I missing? or should I search in some other place/view ?
Please help and advise; Many thanks.