Oracle | PRVT_WORKLOAD

Oracle PRVT_WORKLOAD 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 Undocumented

AUTHID DEFINER

Dependencies

DBA_SQLSET_DEFINITIONS	MVIEW$_ADV_CLIQUE	PRVT_SQLSET_INFRA
DBA_SQLSET_REFERENCES	MVIEW$_ADV_ELIGIBLE	PRVT_WORKLOAD_NOPRIV
DBMS_ADVISOR	MVIEW$_ADV_EXCEPTIONS	SQLSET_ROW
DBMS_ASSERT	MVIEW$_ADV_FILTERINSTANCE	USER$
DBMS_OUTPUT	MVIEW$_ADV_FJG	WRI$_ADV_DEF_PARAMETERS
DBMS_SMB_INTERNAL	MVIEW$_ADV_GC	WRI$_ADV_PARAMETERS
DBMS_SQLTUNE	MVIEW$_ADV_INFO	WRI$_ADV_SQLA_MAP
DBMS_SQLTUNE_INTERNAL	MVIEW$_ADV_JOURNAL	WRI$_ADV_SQLA_TMP
DBMS_SQLTUNE_UTIL0	MVIEW$_ADV_LEVEL	WRI$_ADV_SQLW_COLVOL
DBMS_STANDARD	MVIEW$_ADV_LOG	WRI$_ADV_SQLW_STMTS
DBMS_SUMAPI_LIB	MVIEW$_ADV_OUTPUT	WRI$_ADV_SQLW_SUM
DBMS_SUMA_LIB	MVIEW$_ADV_ROLLUP	WRI$_ADV_SQLW_TABLES
DBMS_SYS_ERROR	MVIEW$_ADV_SQLDEPEND	WRI$_ADV_SQLW_TABVOL
DUAL	MVIEW$_ADV_WORKLOAD	WRI$_ADV_TASKS
MVIEW$_ADVSEQ_ID	PLITBLM	WRI$_ADV_WORKLOAD
MVIEW$_ADV_AJG	PRVT_ACCESS_ADVISOR	WRI$_SQLSET_DEFINITIONS
MVIEW$_ADV_BASETABLE	PRVT_ADVISOR

Documented No

Exceptions

Error Code	Reason

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsms.plb
{ORACLE_HOME}/rdbms/admin/prvtwrk.plb

Subprograms

ADD_STATEMENT	GET_REPORT	PARAM_VALIDATE
CHECK_OR_CREATE_REFERENCE	IMPORT_SCHEMA	RECORD_JNL_ENTRY
CREATE_REPORT	IMPORT_SQLCACHE	RESET_WORKLOAD
CREATE_WORKLOAD	IMPORT_STS	SETUP_PARAMETERS
DELETE_REFERENCE	IMPORT_SUMADV	SETUP_TEMPLATES
DELETE_STATEMENT	IMPORT_USER	SYNONYM
DELETE_USER_SQLWKLD	I_COPY_TO_LOCAL_STS	TEST_API
DELETE_WORKLOAD	I_OPEN_SQLWKLD_SQLSET_CURSOR	UPDATE_STATEMENT

ADD_STATEMENT

Undocumented prvt_workload.add_statement( workload_name IN VARCHAR2, module IN VARCHAR2, action IN VARCHAR2, cpu_time IN NUMBER, elapsed_time IN NUMBER, disk_reads IN NUMBER, buffer_gets IN NUMBER, rows_processed IN NUMBER, optimizer_cost IN NUMBER, executions IN NUMBER, priority IN NUMBER, last_execution_date IN DATE, stat_period IN NUMBER, username IN VARCHAR2, sql_text IN CLOB, user_id IN BINARY_INTEGER);

TBD

CHECK_OR_CREATE_REFERENCE

Undocumented prvt_workload.check_or_create_reference( task_num IN BINARY_INTEGER, task_name IN VARCHAR2, work_num IN BINARY_INTEGER, workload_name IN VARCHAR2, is_sts_param IN BINARY_INTEGER, ref_id IN BINARY_INTEGER, execution_name IN VARCHAR2);

TBD

CREATE_REPORT

Undocumented prvt_workload.create_report( workload_name IN VARCHAR2, report_type IN VARCHAR2, location IN VARCHAR2, filename IN VARCHAR2);

TBD

CREATE_WORKLOAD

Undocumented prvt_workload.create_workload( task_id_num IN BINARY_INTEGER, from_task_id IN BINARY_INTEGER);

TBD

DELETE_REFERENCE

Undocumented prvt_workload.delete_reference( task_name IN VARCHAR2, sts_owner IN VARCHAR2, workload_name IN VARCHAR2, user_id IN BINARY_INTEGER, is_sts_param IN NUMBER, lock_wk IN BOOLEAN);

TBD

DELETE_STATEMENT

Undocumented prvt_workload.delete_statement( workload_name IN VARCHAR2, sql_id IN BINARY_INTEGER, deleted OUT BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD

DELETE_USER_SQLWKLD

Undocumented prvt_workload.delete_user_sqlwkld(user_name IN VARCHAR2);

exec prvt_workload.delete_user_sqlwkld('C##UWCLASS');

      

      PL/SQL procedure successfully completed.

DELETE_WORKLOAD

Undocumented prvt_workload.delete_workload(work_id IN BINARY_INTEGER);

TBD

GET_REPORT

Undocumented prvt_workload.get_report( workload_id IN BINARY_INTEGER, report_type IN BINARY_INTEGER, buffer IN OUT CLOB);

TBD

IMPORT_SCHEMA

Undocumented prvt_workload.import_schema( workload_name IN VARCHAR2, import_mode IN VARCHAR2, priority IN BINARY_INTEGER, saved_rows OUT BINARY_INTEGER, failed_rows OUT BINARY_INTEGER, user_id IN BINARY_INTEGER, cur_user IN VARCHAR2);

TBD

IMPORT_SQLCACHE

Undocumented prvt_workload.import_sqlcache( workload_name IN VARCHAR2, import_mode IN VARCHAR2, priority IN BINARY_INTEGER, saved_rows OUT BINARY_INTEGER, failed_rows OUT BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD

IMPORT_STS

Undocumented prvt_workload.import_sts( workload_name IN VARCHAR2, sts_owner IN VARCHAR2, sts_name IN VARCHAR2, import_mode IN VARCHAR2, priority IN BINARY_INTEGER, saved_rows OUT BINARY_INTEGER, failed_rows OUT BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD

IMPORT_SUMADV

Undocumented prvt_workload.import_sumadv( workload_name IN VARCHAR2, import_mode IN VARCHAR2, priority IN BINARY_INTEGER, sumadv_id IN BINARY_INTEGER, saved_rows OUT BINARY_INTEGER, failed_rows OUT BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD

IMPORT_USER

Undocumented prvt_workload.import_user( workload_name IN VARCHAR2, import_mode IN VARCHAR2, owner_name IN VARCHAR2, table_name IN VARCHAR2, saved_rows OUT BINARY_INTEGER, failed_rows OUT BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD

I_COPY_TO_LOCAL_STS

Undocumented prvt_workload.i_copy_to_local_sts( workload_name IN VARCHAR2, sts_name IN VARCHAR2, sts_owner_name IN VARCHAR2, user_id IN BINARY_INTEGER);

TBD

I_OPEN_SQLWKLD_SQLSET_CURSOR

Undocumented prvt_workload.i_open_sqlwkld_sqlset_cursor(l_id IN BINARY_INTEGER) RETURN sys_refcursor;

TBD

PARAM_VALIDATE

Undocumented prvt_workload.param_validate( work_id IN BINARY_INTEGER, name IN VARCHAR2, value IN VARCHAR2) RETURN VARCHAR2;

TBD

RECORD_JNL_ENTRY

Undocumented prvt_workload.record_jnl_entry( workid IN NUMBER, flags IN NUMBER, num IN NUMBER, msgid IN VARCHAR2, s1 IN VARCHAR2, s2 IN VARCHAR2, s3 IN VARCHAR2, s4 IN VARCHAR2, s5 IN VARCHAR2, s6 IN VARCHAR2, n1 IN NUMBER, n2 IN NUMBER, n3 IN NUMBER);

TBD

RESET_WORKLOAD

Undocumented prvt_workload.reset_workload(task_num IN BINARY_INTEGER);

TBD

SETUP_PARAMETERS

Undocumented prvt_workload.setup_parameters;

exec prvt_workload.setup_parameters;

      

      PL/SQL procedure successfully completed.

SETUP_TEMPLATES

Undocumented prvt_workload.setup_templates( adv_id IN BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD

SYNONYM

Undocumented prvt_workload.synonym( n1 IN VARCHAR2, n2 IN VARCHAR2) RETURN sys.prvt_workload.syn_type;

TBD

TEST_API

Undocumented prvt_workload.test_api( id IN NUMBER, which IN NUMBER);

TBD

UPDATE_STATEMENT

Undocumented prvt_workload.update_statement( workload_name IN VARCHAR2, sql_id IN BINARY_INTEGER, module IN VARCHAR2, action IN VARCHAR2, priority IN BINARY_INTEGER, username IN VARCHAR2, updated OUT BINARY_INTEGER, user_id IN BINARY_INTEGER);

TBD