CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
HOME | BROWSE | GROUPS | REFERENCE | ADD CODE | LINKS | SPONSORS
It's time to sign up for your 2010 PSOUG membership!
Click here to join PSOUG now!
Search the Reference Library pages:  
Help us help you! Take our 1-minute PSOUG survey. Free Oracle Magazines & 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;
 
 
Contact Us • Legal Notices and Terms of Use • Privacy Statement
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [98 visitors online]    © 2009 psoug.org