Oracle Database Discussions

Hi,

I have executed : alter system set parallel_degree_policy='AUTO';

and also calibrated the I/O. So when i execute  select * from V$IO_CALIBRATION_STATUS;

The STATUS is READY

I also have these correct parameters:

SQL > show parameter disk_asynch_io   :  TRUE

SQL > show  parameter filesystemio_options     :  asynch

But when i get the explain plan for one query it still says automatic DOP: skipped because of IO calibrate statistics are missing

Note: Parallel_servers_target is less than parallel_max_servers in my database and this means that parallel statement queuing can occur

Now, i'm gathering the statistics for the whole schema, do you think it helps out?

Do you have any idea , why the DOP is yet skipped!!!!!!   the parallelism works ok when i use oracle Hints in the query!

Thanks in advance!

/Hesi