Is there any way to find out when particular view was compiled?
I think that you can determine the time a view was last compiled querying the data dictionary view dba_objects:

sql&gt; select last_ddl_time from dba_objects where object_type = 'VIEW' and object_name = 'MOO';


You can also see the text the view is based on in the dba_views dictionary view:

sql&gt; select * from dba_views where view_name = `MOO`;