Background: Oracle 9.2.0 running on win2k
q1: I need to find out which objects have not been in used for > 6 mths. How do i do this?
q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know whether this shld be deleted
q3: i also need to know which view, index, table (any object, object-type) is being referenced in a program (PL/SQL, C++). Anyway to run a query that would list this info
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!