Oracle PRVT_UADV
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Submits an undo advisor task for execution
AUTHID DEFINER
Dependencies
DBMS_UNDOADV_LIB WRI$_ADV_UNDO_ADV  
Documented No
First Available 10.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtuadv.plb
 
EXECUTE
Submits an advisor task for to be executed. This is not something easily demonstrated so the demo at the right is for education purposes only. prvt_udv.execute(task_id IN BINARY_INTEGER);
SQL> exec prvt_uadv.execute(562);
BEGIN prvt_uadv.execute(562); END;
*
ERROR at line 1:
ORA-13605: The specified task or object 562 does not exist for the current user.
ORA-06512: at "SYS.PRVT_UADV", line 10
ORA-06512: at line 1

Related Topics
DBMS_UNDO_ADV
Packages
Tablespaces
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved