CODEWITHSUNDEEP
sqldatabaseoracle-database
Giorgi Tsiklauri
Giorgi Tsiklauri

Reputation: 11110

How can I see when a view was modified in Oracle DB

I wonder if I can (and I'm pretty sure I can) see the log about when my particular view A had lastly been modified/edited, or accessed.

Upvotes: 2

Views: 11451

Answers (2)

Nick
Nick

Reputation: 2514

Oracle does not track access counts by default. However, if you are in Oracle 10g or newer, you can leverage Fine Grain Auditing and track the events against the view you'd like to see like selects or even DML statements.

http://www.oracle-base.com/articles/10g/database-security-enhancements-10g.php#fga

Upvotes: 1

Frank Schmitt
Frank Schmitt

Reputation: 30765

To find out when your view was last modified, you can use the view USER_OBJECTS:

select object_name, object_type, created, last_ddl_time 
from user_objects
where object_name = '<my_view_name>';

I'm not sure whether there exists a possibility to find out when your view was last accessed, though.

Upvotes: 5

Related Questions