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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

What are the differences between blob and clob in oracle?

0 Answers  


Difference between inner join vs where ?

0 Answers  


Why do we need integrity constraints in a database?

0 Answers  


Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,


What is sharded cluster?

0 Answers  


How do we know whether an index is created on a table ???

2 Answers   TCS,


How to rename an index?

0 Answers  


What is a schema in oracle?

0 Answers  


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  


I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  


What is a database table in oracle?

0 Answers  


What is an oracle database table?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)