My Oracle Support Banner

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

Last updated on JANUARY 17, 2020

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.