Segment

How to List Tables and Indexes in a Data File

by Ed Chen
June 6, 2022June 22, 2022

Normally, we would like to know what objects in a tablespace for better managing object allocation. In fact, a tablespace is just a logical collection… Read More »

How to List Tables or Indexes in a Tablespace

by Ed Chen
June 3, 2022June 3, 2022

We have talked about the differences between schema objects and segments in another post. From tablespace's point of view, program units and informative schema objects… Read More »

Segments vs Schema Objects

by Ed Chen
July 20, 2019April 18, 2022

Segments vs Schema Objects Not only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions… Read More »

How to Check Oracle Segment Size

by Ed Chen
January 14, 2019November 10, 2021

Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within… Read More »