We have executed a gather database stats job with following command
EXEC DBMS_STATS.GATHER_DATABASE_STATS(estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,degree => 16,options => 'GATHER AUTO',cascade => TRUE);
But during execution of the process , we have noticed that this process has completely Serial and not using parallelism at all.
We fount the following
"When GATHER AUTO is specified, the only additional valid parameters are ownname, stattab, statid, objlist and statown; all other parameter settings are ignored"
This a note id which we found which proved very usefule.
EXEC DBMS_STATS.GATHER_DATABASE_STATS(estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,degree => 16,options => 'GATHER AUTO',cascade => TRUE);
But during execution of the process , we have noticed that this process has completely Serial and not using parallelism at all.
We fount the following
"When GATHER AUTO is specified, the only additional valid parameters are ownname, stattab, statid, objlist and statown; all other parameter settings are ignored"
This a note id which we found which proved very usefule.
Once we removed options => 'GATHER AUTO' from the command we could see it running in parallel
No comments:
Post a Comment