| General |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsatsk.sql |
| First Available |
11.1 |
| Dependencies |
| DBMS_AUTOTASK_PRVT |
DBMS_LOCK |
| DBMS_AUTO_TASK_IMMEDIATE |
DBMS_SCHEDULER |
|
| Security Model |
Execute is granted to the DBA role |
| |
| GATHER_OPTIMIZER_STATS; |
| Immediately gathers
optimizer statistics |
dbms_auto_task_immediate.gather_optimizer_stats; |
| exec dbms_auto_task_immediate.gather_optimizer_stats; |