Oracle DBA tips
Tuesday, February 14, 2012
How to find last updates on table (oracle 10g)
SQL> SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from scott.emp;
SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
10-FEB-12 02.58.54.000000000 AM
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment