How Can I Calculate Or Check The Space Used In Blocks Of Tables With SDO_GEOMETRY Columns
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial and Graph - Version 18.104.22.168 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.
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