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
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)