How Can I Calculate Or Check The Space Used In Blocks Of Tables With SDO_GEOMETRY Columns (Doc ID 1591882.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

How can I calculate or check the space used in blocks of tables with SDO_GEOMETRY columns?
The problem is if you have a table in an Oracle database with a SDO_GEOMETRY column and if you have re-calculated the table statistics with DBMS_STATS.GATHER_TABLE_STATS the USER_SEGMENTS view gets you back the total space used by the table for ALL table columns. But what I need is a method to calculate only the total space used from ALL table columns WITHOUT the SDO_GEOMETRY column. And this independent if the SDO_GEOMETRY column has a spatial index or not.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms