Recent content by OraDotNetDev

Hi Claus, That all sound good to me :-D

Including in the code in dbms_jobs, dbms_scheduler etc would be very helpful for impact analysis.

Yeah I missed the exclude system objects that definitely helps :) . What testing shows is that excluding tables and views from the search plus the above brings it down to 10 minutes, though obviously this is not a complete enough search in many cases. However looking at the trace there are all...

We have a requirement, as I'm sure many organisations do to carry out Code Search (Impact Analysis) across all schemas and Compare Objects (create Change Scripts.) Our DB is around 1.5 TB with ~250K objects ~9000 are stored code across 100 schemas. the numbers are reduced by a third* if we could...