CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_AUTO_TASK_IMMEDIATE
Version 11.1
 
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;
 

Related Topics

DBMS_AUTO_TASK

DBMS_AUTO_TASK_ADMIN

DBMS_AUTO_TASK_EXPORT

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [64 users online]    © 2010 psoug.org