Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am working on an Oracle 10g database which is being populated periodically with data from network nodes. What Oracle table can I query to to get the time at which myTableOfInterest was last populated?

I have already searched and tried: select max(ORA_ROWSCN), scn_to_timestamp(max(ORA_ROWSCN)) from myTableName; Unfortunately this select results in no rows being found.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Have a look at the TIMESTAMP column of the ALL_TAB_MODIFICATIONS. http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2097.htm

Also, keep in mind this part:

Note: These views are populated only for tables with the MONITORING attribute. They are intended for statistics collection over a long period of time. For performance reasons, the Oracle Database does not populate these views immediately when the actual modifications occur. Run the FLUSH_DATABASE_MONITORING_INFO procedure in the DIMS_STATS PL/SQL package to populate these views with the latest information. The ANALYZE_ANY system privilege is required to run this procedure.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.