In Oracle PL/SQL, SDO_TUNE is a built in package which contains tuning subprograms related to Spatial.
The subprograms contained by SDO_TUNE are as described below:
AVERAGE_MBR - Returns the average minimum bounding rectangle for geometries in a layer.
ESTIMATE_RTREE_INDEX_SIZE - Returns the maximum number of megabytes required for an R-tree spatial index table.
EXTENT_OF - Returns the minimum bounding rectangle of the data in a layer.
MIX_INFO - Returns geometry type information for a spatial layer.
QUALITY_DEGRADATION - Returns the quality degradation for a specified index table. Oracle has deprecated this subprogram in Oracle 11g release.