Oracle | DBMS_TRANSACTION_INTERNAL

Oracle DBMS_TRANSACTION_INTERNAL_SYS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Obtains the current SCN number

AUTHID DEFINER

Dependencies

STANDARD (only)

Documented No

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthtxn.plb

GET_CURRENT_SCN

Returns the current System Change Number dbms_transaction_internal_sys.get_current_scn( base_ub1 IN BINARY_INTEGER, wrap_ub2 IN BINARY_INTEGER) RETURN NUMBER;

SELECT dbms_flashback.get_system_change_number,

             dbms_transaction_internal_sys.get_current_scn,

             current_scn

      FROM  v$database;

      

      GET_SYSTEM_CHANGE_NUMBER GET_CURRENT_SCN CURRENT_SCN

      ------------------------ --------------- -----------

                     
      916034039       916034039   916034039