My Oracle Support Banner

Gather Stats Does Not Populate LAST_ANALYZED for Spatial Index (Doc ID 2084588.1)

Last updated on DECEMBER 02, 2015

Applies to:

Oracle Spatial and Graph - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

LAST_ANALYZED column in the USER_INDEXES remains NULL for spatial index after gathering statistics.

SQL> exec dbms_stats.gather_schema_stats('SDOTEST',options=>'GATHER', ESTIMATE_PERCENT=>10, DEGREE=>4, cascade => TRUE);

PL/SQL procedure successfully completed.

SQL> select index_name, ityp_name, last_analyzed, status, domidx_opstatus, domidx_status from user_indexes order by 1;

INDEX_NAME                ITYP_NAME       LAST_ANALYZED       STATUS   DOMIDX DOMIDX_STATU
------------------------- --------------- ------------------- -------- ------ ------------
COLA_SPATIAL_IDX_CS       SPATIAL_INDEX                       VALID    VALID  VALID
SYS_C009500                               2015-12-02 13:36:00 VALID
SYS_IL0000070407C00009$$                                      VALID
SYS_IL0000070407C00010$$                                      VALID
SYS_IL0000070414C00003$$                                      VALID

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.