Detecting Procedure Name and Tables
Dear All,
1.) I have a list of queries to be tuned. Once i finish tuning, i need to edit the procedures where these queries are in. So i need some script or method to find the Procedure name, given the Query. I tried USER_SOURCE and ALL_SOURCE, but the system hangs cos, i have around 25,000 stored procedures. Is there any way to find it out using the address or something like that.
2.) I also need to find out the tables that are going for a Full Table Scan, in the application. If there be any script or way where we can find those tables that go for a full scan, then i can try applying some indexes on those tables.
-Tanks in advance.