DBA Segments – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Database segments such as tables, indexes, lob segments by size and total database size summary
Report Parameters
Segment Name like, Segment Type, Table Name, Tablespace Name, Owner, Size bigger than x MB, Group by
Oracle EBS Tables Used
dba_segments, dba_indexes, dba_lobs, dba_secondary_objects
Report Categories
Related Reports
DBA Index Columns, DBA Objects, DBA SGA Buffer Cache Object Usage, DBA Dependencies (uses), DBA AWR Active Session History, DBA Blitz Report ORDS Configuration, DBA SGA Active Session History, DBA ORDS Configuration Validation, DBA Blocking Sessions
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA Segments 22-Dec-2025 084642.xlsx |
| Blitz Report™ XML Import | DBA_Segments.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-segments/ |
Case Study & Technical Analysis
Abstract
The DBA Segments report is a fundamental storage analysis tool used to visualize space consumption within the Oracle database. It aggregates data at the segment level—covering tables, indexes, LOBs, and partitions—to identify the largest objects and their growth patterns. This analysis is critical for capacity planning, reclaiming wasted space, and managing tablespace quotas.
Technical Analysis
Core Components
- Segment Classification: Categorizes storage by type (TABLE, INDEX, LOBSEGMENT, TABLE PARTITION, etc.).
- Size Metrics: Reports physical space allocated (bytes/blocks) versus actual space used, helping to identify fragmentation or “high water mark” issues.
- Ownership & Location: Maps segments to their owners (schemas) and tablespaces.
Key Views
DBA_SEGMENTS: The primary source for storage allocation data.DBA_INDEXES: Used to correlate index segments with their parent tables.DBA_LOBS: Links LOB segments (which often have system-generated names) back to their parent table and column.DBA_SECONDARY_OBJECTS: Handles secondary objects like domain indexes.
Operational Use Cases
- Top N Analysis: Identifying the top 10 or 20 largest objects in the database to focus tuning or archiving efforts.
- Growth Monitoring: Tracking segment size changes over time to forecast storage requirements.
- Cleanup: Finding temporary or “backup” tables (e.g.,
EMP_BKP_2023) that are consuming space unnecessarily. - LOB Management: Specifically analyzing Large Object storage, which can often grow uncontrollably if not monitored.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics