Oracle | DBMS_TRANSACTION_INTERNAL

Oracle DBMS_TRANSACTION_INTERNAL_SYS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

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

                      38814826        38814826    38814826