| layout | default |
|---|---|
| title | DBA Segments | Oracle EBS SQL Report |
| description | Database segments such as tables, indexes, lob segments by size and total database size summary |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Segments, dba_segments, dba_indexes, dba_lobs |
| permalink | /DBA%20Segments/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Database segments such as tables, indexes, lob segments by size and total database size summary
Segment Name like, Segment Type, Table Name, Tablespace Name, Owner, Size bigger than x MB, Group by
dba_segments, dba_indexes, dba_lobs, dba_secondary_objects
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
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.
| 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/ |
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.
- 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.
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.
- 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.
- 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