Forum Stats

  • 3,875,048 Users
  • 2,266,799 Discussions
  • 7,912,070 Comments

Discussions

Two questions about V$DATABASE.CURRENT_SCN, and its conversion to timestamp

Sebino
Sebino Member Posts: 68 Red Ribbon

Hello,

1) CURRENT_SCN column of v$database is incremented by one every X milliseconds right ?

(I mean it's absolutely sequential and always incremented by one -"+ 1"-, if I could catch every value Oracle makes I would get *no gap* right ?)

2) When converting its value with SCN_TO_TIMESTAMP() I always get ".000000000" after the seconds, and no finer details:

SQL> select current_scn, scn_to_timestamp(current_scn) from v$database;

CURRENT_SCN SCN_TO_TIMESTAMP(CURRENT_SCN)
----------- ---------------------------------------------------------------------------
 7110209832 16-MAR-22 02.26.20.000000000 PM

SQL> /

CURRENT_SCN SCN_TO_TIMESTAMP(CURRENT_SCN)
----------- ---------------------------------------------------------------------------
 7110209833 16-MAR-22 02.26.20.000000000 PM


but you see ? here above I got twice 2:26:20PM with two different SCNs...

Is there no way to refine this ".000000000" value ?

Thanks.

Sebino

Answers