Data Dictionary View

How to Find Largest Segments in Oracle

Posted on
Find Largest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within a tablespace. Which means segments contain not only metadata but real data. Normally, segments include tables, indexes and large objects, etc. Let’s see what largest segments are in our database. […]