Data Dictionary View

How to Find Largest Segments in Oracle

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

How to List All Tables in Oracle

Posted on
USER_TABLES vs ALL_TABLES vs DBA_TABLES
List All Tables You Own To list all tables that belong to you, you can query USER_TABLES which is an Oracle data dictionary view used to look up table information of yours. SQL> conn hr/hr; Connected. SQL> select table_name from user_tables; TABLE_NAME —————————— LOCATIONS COUNTRIES JOB_HISTORY EMPLOYEES JOBS DEPARTMENTS REGIONS 7 rows selected. The listed […]