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