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 […]
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 […]
Space

Must Dos after Moving a Table

Posted on
Moving a table is actually a reorganization process, The database will copy the original data to the new place. In which, the data will be stored optimally in terms of performance and space. But if you found the performance was degraded on this table after moving, it might be that your indexes have not been […]