Oracle PRVT_WORKLOAD_NOPRIV
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_ADVISOR PRVT_ADVISOR PRVT_WORKLOAD
DBMS_SYS_ERROR    
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsms.plb
Subprograms
 
DELETE_STATEMENT
Undocumented prvt_workload_nopriv.delete_statement(
workload_name IN  VARCHAR2,
search        IN  VARCHAR2,
deleted       OUT BINARY_INTEGER)
TBD
 
UPDATE_STATEMENT
Undocumented prvt_workload_nopriv.update_statement(
workload_name IN  VARCHAR2,
module        IN  VARCHAR2,
action        IN  VARCHAR2,
priority      IN  BINARY_INTEGER,
username      IN  VARCHAR2,
search        IN  VARCHAR2,
updated       OUT BINARY_INTEGER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_ADVISOR
PRVT_WORKLOAD
What's New In 21c
What's New In 26ai

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