Oracle 12c DBMS_SESSION

Oracle DBMS_SESSION_STATE Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.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.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

Purpose Beyond the obvious from the name: Unknown

AUTHID DEFINER

Dependencies

DBMS_SS_LIB

Documented No

First Available 11.1.0.6

Security Model Owned by SYS with no privileges granted

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

Subprograms

CAPTURE	SS_CAPTURE	SS_UNMARK_CAPTURE
MARK_CAPTURE	SS_MARK_CAPTURE	UNMARK_CAPTURE
RESTORE	SS_RESTORE

CAPTURE

Undocumented dbms_session_state.capture( session_id IN BINARY_INTEGER, session_serial IN BINARY_INTEGER, cmode IN VARCHAR2, directory IN VARCHAR2, format IN VARCHAR2, locator OUT RAW);

TBD

MARK_CAPTURE

Undocumented dbms_session_state.mark_capture( session_id IN BINARY_INTEGER, session_serial IN BINARY_INTEGER, capture_scope IN VARCHAR2, notify IN BOOLEAN, suspend IN BOOLEAN, timeout IN BINARY_INTEGER);

TBD

RESTORE

Undocumented dbms_session_state.restore( session_id IN BINARY_INTEGER, session_serial IN BINARY_INTEGER, rmode IN VARCHAR2, directory IN VARCHAR2, locator IN RAW);

TBD

SS_CAPTURE

Undocumented dbms_session.ss_capture( sid IN BINARY_INTEGER, ser IN BINARY_INTEGER, cmode IN BINARY_INTEGER, cdir IN VARCHAR2, cfmt IN BINARY_INTEGER, cloc OUT RAW);

TBD

SS_MARK_CAPTURE

Undocumented dbms_session.ss_mark_capture( sid IN BINARY_INTEGER, ser IN BINARY_INTEGER, scope IN BINARY_INTEGER, notify IN BOOLEAN, suspend IN BOOLEAN, timeout IN BINARY_INTEGER);

TBD

SS_RESTORE

Undocumented dbms_session_state.ss_restore( sid IN BINARY_INTEGER, ser IN BINARY_INTEGER, rmode IN BINARY_INTEGER, rdir IN VARCHAR2, rloc IN RAW);

TBD

SS_UNMARK_CAPTURE

Undocumented dbms_session_state.ss_unmark_capture( sid IN BINARY_INTEGER, ser IN BINARY_INTEGER);

TBD

UNMARK_CAPTURE

Undocumented dbms_session_state.unmark_capture( session_id IN BINARY_INTEGER, session_serial IN BINARY_INTEGER);

TBD