Subscriber Count

    464

Subscribe to Posts by Email

Pages

Current_SCN how it populates?

My friend has asked this question today as he got the same in one his interview…

The common answer we give is from any base table as v$database (current_scn) is populated by any base table.

However the base table is $KCCDI under column DICUR_SCN is current SCN. you can find this by querying the v$database […]