Table

How to Check Oracle Table Size

Posted on
Although we have listed the top 10 biggest tables in our Oracle database, we also can check single table size by similar ways. Theoretical Table Size We used NUM_ROWS and AVG_ROW_LEN (in byte) in DBA_TABLES to calculate how many bytes that active rows of the table are used. The result can not be very accurate […]
Administration

How to Check Oracle Database Size

Posted on
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 and create reasonable tablespaces in advance. Prediction on space growth You have to log the overall space usage on weekly or monthly basis in order to predict the database size […]
Segment

Segments vs Schema Objects

Posted on
Segments vs Schema Objects No only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions of segment and schema object in Oracle world. Segments A segment in an Oracle database is a set of extents that contains all the data for a specific logical storage […]
Data Dictionary View

How to Find Biggest Segments in Oracle

Posted on
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 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 biggest segments are in our database. […]
Data Dictionary View

Oracle Show Tables in a List

Posted on
Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Oracle Show Tables that You Own in a List Oracle Show Tables that You Can Use in a List Oracle Show Tables for Whole Database in a List Later on, we will talk about […]