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

How Oracle List Tables

Posted on
Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES
In this post, we will talk about three different Oracle views that can list all tables within defined scope, they are: Oracle List Tables that You Own Oracle List Tables that You Can Use Oracle List Tables for Whole Database Later on, we will talk about some useful concepts that are really helpful for you […]