Gather index global statistics automatically?

Dec 18, 2015 8:01AM

Hi to All,

I have a problem with statistics in my Oracle RAC Database 11.2.0.2 in Linux.

We have a newly created hash partitioned index "TRANSACCION_IDX_PART" (16 partitions) that lacks global statistics:

SQL> select INDEX_NAME,PARTITION_NAME,last_analyzed, global_stats from user_ind_statistics where index_name ='TRANSACCION_IDX_PART';

INDEX_NAME PARTITION_NAME LAST_ANA GLOBAL_STATS

------------------------------ ------------------------------ -------- ---

TRANSACCION_IDX_PART 22/11/15 NO

TRANSACCION_IDX_PART TRANS_PART_1 22/11/15 NO

TRANSACCION_IDX_PART TRANS_PART_10 22/11/15 NO

TRANSACCION_IDX_PART TRANS_PART_11 23/11/15 NO

TRANSACCION_IDX_PART TRANS_PART_12 25/11/15 NO

TRANSACCION_IDX_PART TRANS_PART_13 26/11/15 NO

TRANSACCION_IDX_PART TRANS_PART_14 27/11/15 NO

SQL Performance (MOSC)