Oracle 12cR2 DBMS_SQADM

Oracle DBMS_SQADM_SYSCALLS Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

Purpose Support for Automatic Diagnostic Repository (ADR)

AUTHID DEFINER

Dependencies

DBMS_PRVTSQIS

DBMS_SQADM_LIB

Documented No

First Available 12cR1

Security Model Owned by SYS with

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

Subprograms

KWSA_3GL_ADDCSUB	KWSA_3GL_ALTERDSUB	KWSA_3GL_DRPDSUB
KWSA_3GL_ADDDSUB	KWSA_3GL_DRPCSUB	KWSA_3GL_LOCKDSUB

KWSA_3GL_ADDCSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_addCSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_id IN NUMBER, pos_bmap OUT NUMBER, create_time IN TIMESTAMP WITH TIME ZONE, flags OUT NUMBER, parent_id OUT NUMBER, parent IN VARCHAR2);

TBD

KWSA_3GL_ADDDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_addDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, pos_bmapP OUT NUMBER, rule_name IN VARCHAR2, trans_sch IN VARCHAR2, trans_name IN VARCHAR2, create_time IN TIMESTAMP WITH TIME ZONE, flags IN NUMBER);

KWSA_3GL_ALTERDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_alterDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, rule_name IN VARCHAR2, trans_sch IN VARCHAR2, trans_name IN VARCHAR2, updrule IN BOOLEAN, updtrans IN BOOLEAN);

TBD

KWSA_3GL_DRPCSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_drpCSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, qid IN NUMBER, par_name IN VARCHAR2);

TBD

KWSA_3GL_DRPDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_drpDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, qid IN NUMBER);

TBD

KWSA_3GL_LOCKDSUB

Undocumented dbms_sqadm_syscalls.dbms_sqadm_syscalls.kwsa_3GL_LockDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, operation IN VARCHAR2, flags IN BINARY_INTEGER);

TBD