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 will be available on generic Linux platforms in January and soon on AIX and Windows

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