In previous post, we have talked about how to identify empty tablespaces for dropping. In that post, we cautiously check the status of the tablespace… Read More »How to Drop Empty Tablespace
Beside routine administration and performance tuning, space management is also a major topic for DBA to handle. Usually, space is sometimes stressed by database growth.… Read More »How to Find Empty Tablespace
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
Table Resides in What Tablespace? To better manage overall tablespace usage, we'd like to know which tablespace specific table or index is in before moving… Read More »How to Check Tablespace of a Table
The size of an Oracle table can be calculated by different ways. In this post, I will introduce 3 approaches, theoretical table sizing, logical table… Read More »How to Check Oracle Table Size
Schema Size Calculation After knowing the whole database size, we may drill down a little bit to calculate schema size for every user in database.… Read More »How to Check Schema Size in Oracle
At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… Read More »How to Check Oracle Database Size
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