SAP ABAP Table SEG_ORA (ORACLE Segment Information from dba_segments)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SDBO (Package) Database Administration: Oracle-Specific Components

Basic Data

Table Category	INTTAB	Structure
Structure	SEG_ORA	Table Relationship Diagram
Short Description	ORACLE Segment Information from dba_segments

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OWNER	☑	SEG_OWNER	CHAR30	CHAR	30	0	Segment owner
2	SEG_NAME	☑	SEG_NAME	CHAR81	CHAR	81	0	Segment name
3	SEG_TYPE	☐	SEG_TYPE	CHAR17	CHAR	17	0	Segment type
4	TSP_NAME	☐	TSP_NAME	CHAR_30	CHAR	30	0	Tablespace name
5	HD_FILE	☐	SEG_HFILE	DEC17	DEC	17	0	Header file number
6	HD_BLKS	☐	SEG_HBLK	DEC17	DEC	17	0	Header block number
7	BYTES	☐	SEG_BYTES	DEC17	DEC	17	0	Segment bytes
8	BLOCKS	☐	SEG_BLKS	DEC17	DEC	17	0	Segment blocks
9	EXTENTS	☐	SEG_EXTS	DEC17	DEC	17	0	Segment number of extents
10	INI_EXT	☐	SEG_INIT	DEC17	DEC	17	0	Initial extent
11	NEXT_EXT	☐	SEG_NEXT	DEC17	DEC	17	0	Next extent
12	MINEXTS	☐	SEG_MINEXT	DEC17	DEC	17	0	Min extents
13	MAXEXTS	☐	SEG_MAXEXT	DEC17	DEC	17	0	Max extents
14	PCT_INC	☐	SEG_PCTINC	DEC17	DEC	17	0	Pct inc
15	FLISTS	☐	FLISTS	DEC17	DEC	17	0	Free lists
16	FLIST_G	☐	FLIST_G	DEC17	DEC	17	0	Free list groups

History

Last changed by/on	SAP	19990505
SAP Release Created in