eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: MDSYS.ALL_SDO_INDEX_METADATA

Source

View Text - Preformatted


select SDO_INDEX_OWNER, SDO_INDEX_TYPE,
        SDO_LEVEL, SDO_NUMTILES, SDO_MAXLEVEL, SDO_COMMIT_INTERVAL,
        SDO_INDEX_TABLE, SDO_INDEX_NAME, SDO_INDEX_PRIMARY, SDO_TSNAME,
        SDO_COLUMN_NAME, SDO_RTREE_HEIGHT, SDO_RTREE_NUM_NODES,
        SDO_RTREE_DIMENSIONALITY, SDO_RTREE_FANOUT, SDO_RTREE_ROOT,
        SDO_RTREE_SEQ_NAME, SDO_FIXED_META, SDO_TABLESPACE,
        SDO_INITIAL_EXTENT, SDO_NEXT_EXTENT, SDO_PCTINCREASE,
        SDO_MIN_EXTENTS, SDO_MAX_EXTENTS, SDO_INDEX_DIMS, SDO_LAYER_GTYPE,
        SDO_RTREE_PCTFREE, SDO_INDEX_PARTITION, SDO_PARTITIONED,
        SDO_RTREE_QUALITY, SDO_INDEX_VERSION, SDO_INDEX_GEODETIC,
        SDO_INDEX_STATUS,
        SDO_NL_INDEX_TABLE,
        SDO_DML_BATCH_SIZE, SDO_RTREE_ENT_XPND,
        SDO_NUM_ROWS,                                           --- bug9743250
        SDO_NUM_BLKS,
        SDO_OPTIMIZED_NODES,
        SDO_ROOT_MBR                                            --- bug2719909
 from SDO_INDEX_METADATA_TABLE
 where
 (exists
   (select index_name from all_indexes
    where index_name=sdo_index_name and
          owner = sdo_index_owner))

View Text - HTML Formatted

SELECT SDO_INDEX_OWNER
, SDO_INDEX_TYPE
, SDO_LEVEL
, SDO_NUMTILES
, SDO_MAXLEVEL
, SDO_COMMIT_INTERVAL
, SDO_INDEX_TABLE
, SDO_INDEX_NAME
, SDO_INDEX_PRIMARY
, SDO_TSNAME
, SDO_COLUMN_NAME
, SDO_RTREE_HEIGHT
, SDO_RTREE_NUM_NODES
, SDO_RTREE_DIMENSIONALITY
, SDO_RTREE_FANOUT
, SDO_RTREE_ROOT
, SDO_RTREE_SEQ_NAME
, SDO_FIXED_META
, SDO_TABLESPACE
, SDO_INITIAL_EXTENT
, SDO_NEXT_EXTENT
, SDO_PCTINCREASE
, SDO_MIN_EXTENTS
, SDO_MAX_EXTENTS
, SDO_INDEX_DIMS
, SDO_LAYER_GTYPE
, SDO_RTREE_PCTFREE
, SDO_INDEX_PARTITION
, SDO_PARTITIONED
, SDO_RTREE_QUALITY
, SDO_INDEX_VERSION
, SDO_INDEX_GEODETIC
, SDO_INDEX_STATUS
, SDO_NL_INDEX_TABLE
, SDO_DML_BATCH_SIZE
, SDO_RTREE_ENT_XPND
, SDO_NUM_ROWS
, --- BUG9743250 SDO_NUM_BLKS
, SDO_OPTIMIZED_NODES
, SDO_ROOT_MBR --- BUG2719909
FROM SDO_INDEX_METADATA_TABLE WHERE (EXISTS (SELECT INDEX_NAME
FROM ALL_INDEXES
WHERE INDEX_NAME=SDO_INDEX_NAME AND OWNER = SDO_INDEX_OWNER))