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 188.8.131.52 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!