Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
- 0 Answers
- 940 Views
- Infosys, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between simple view and complex view?
Can Multiple instances be run on Single Machine???
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
Explain database link?
what is the difference between first normal form & second normal form?
How many types of database triggers exist?
IS it possible to built the oracle database without setting the kernal parameters?
What is catalog in Oracle?
What are nested tables?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to use subqueries in the from clause in oracle?
What is a trace file and how is it created in oracle?
Oracle General 
