Toad World® Forums

statiscs on oracle view


#1

Hello:

Over the years we have created many views in the Oracle database. Is there a way to determine, or get some statistics on the last time a view in the database was actually last accessed. If we can determine this we can get rid of those views not actually being used anymore.


#2

The only way that I know of for views would be to enable auditing on them, and then that would work going forward.