Check Recovery Time

From NazimWIKI

Revision as of 23:38, 8 November 2019 by Admin (talk | contribs) (Created page with "It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery. <blockquote><pre> SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery.

SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM smon_scn_time;

Retrieved from "http://www.nazimcricket.com/wiki/index.php?title=Check_Recovery_Time&oldid=94"