Normally, we would like to list tables in a tablespace for better managing segment allocation. In fact, a tablespace is just a logical collection of… Read More »How to List Tables in Datafile
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 »How to List Tables in Tablespace
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 »Segments vs Schema Objects
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 »How to Check Oracle Segment Size