Oracle PRVT_WORKLOAD
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_ADVISOR
PRVT_WORKLOAD_NOPRIV
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx