Oracle 12c DBMS_TRANSACTION_INTERNAL

Oracle DBMS_TRANSACTION_INTERNAL_SYS Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Purpose

Obtains the current SCN number

AUTHID

DEFINER

Dependencies

Only STANDARD

Documented

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,
base_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;