Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

SebinoMar 16 2022

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
Comments
Post Details
Added on Mar 16 2022
#database, #database-key-features, #replication
1 comment
615 views