Oracle DBMS_AUTO_TASK_IMMEDIATE
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 Zero delay initiation of optimizer stats gathering
AUTHID DEFINER
Dependencies
DBMS_AUTOTASK_PRVT DBMS_LOCK DBMS_SCHEDULER
Documented No
First Available 11.1.0.6
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source $ORACLE_HOME/rdbms/admin/dbmsatsk.sql
 
GATHER_OPTIMIZER_STATS
Immediately gathers optimizer statistics dbms_auto_task_immediate.gather_optimizer_stats;
exec dbms_auto_task_immediate.gather_optimizer_stats;

Related Topics
DBMS_AUTOTASK_PRVT
DBMS_AUTO_TASK
DBMS_AUTO_TASK_ADMIN
DBMS_AUTO_TASK_EXPORT
Packages
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