How to Drop Empty Tablespace
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
DBA_SEGMENTS
How to Find 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
How to Resolve ORA-01549: tablespace not empty, use INCLUDING CONTENTS option
ORA-01549 Tried to drop a tablespace in the simplest way, but it failed with ORA-01549. SQL> drop tablespace erptbs; drop tablespace erptbs * ERROR at… Read More »How to Resolve ORA-01549: tablespace not empty, use INCLUDING CONTENTS option
How to List Tables in 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
How to Check Tablespace of a Table
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
How to Check Oracle Table Size
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
How to Check Schema Size in Oracle
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
How to Check Oracle Database Size
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
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
How to Check Oracle Segment Size
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