| Oracle PRVT_UADV Version 11.2.0.3 |
|---|
| General Information | ||||
| Purpose | Submits an undo advisor task for execution | |||
| AUTHID | DEFINER | |||
| Dependencies |
|
|||
| First Available | 10.1 | |||
| Security Model | Owned by SYS with no privileges granted | |||
| Source | {ORACLE_HOME}/rdbms/admin/prvt | |||
| EXECUTE | ||||
| Submits an advsor 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 |
| Tablespaces |
| 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-2013 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||
