| General Information |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsatsk.sql |
| First Available |
11.1 |
| Dependencies |
| DBMS_AUTOTASK_PRVT |
DBMS_SCHEDULER |
| DBMS_LOCK |
SYS_PLSQL_11658_100_1 |
|
| 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; |
