SAP ORA_DBA_TABLES table - Copy of DBA_TABLES (currently not provided with snapshots) details in SAP


SAP ORA_DBA_TABLES table summary

Object Name: ORA_DBA_TABLES
Dictionary Type: Transparent table
Description: Copy of DBA_TABLES (currently not provided with snapshots)


Field list for ORA_DBA_TABLES table on an S/4 SAP system

Details
ORA_DBA_TABLES-SNAPSHOT_ID table field - Oracle monitor: snapshot ID

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

ORA_DBA_TABLES-OWNER table field - Oracle monitoring: Owner of the object

Description: Oracle monitoring: Owner of the object
Field Name: OWNER
Data Element: ORA_OWNER_30
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNER

ORA_DBA_TABLES-TABLE_NAME table field - Oracle monitoring: table name

Description: Oracle monitoring: table name
Field Name: TABLE_NAME
Data Element: ORA_TABLE_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_NAME

ORA_DBA_TABLES-TABLESPACE_NAME table field - Oracle monitoring: Tablespacename to which objects belong

Description: Oracle monitoring: Tablespacename to which objects belong
Field Name: TABLESPACE_NAME
Data Element: ORA_TABLESPACE_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLESPACE_NAME

ORA_DBA_TABLES-CLUSTER_NAME table field - Oracle monitoring: cluster name

Description: Oracle monitoring: cluster name
Field Name: CLUSTER_NAME
Data Element: ORA_CLUSTER_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLUSTER_NAME

ORA_DBA_TABLES-IOT_NAME table field - Oracle monitoring: IOT name

Description: Oracle monitoring: IOT name
Field Name: IOT_NAME
Data Element: ORA_IOT_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOT_NAME

ORA_DBA_TABLES-PCT_FREE table field - Oracle monitoring:percentage of free space in a block

Description: Oracle monitoring:percentage of free space in a block
Field Name: PCT_FREE
Data Element: ORA_PCT_FREE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_FREE

ORA_DBA_TABLES-PCT_USED table field - Oracle monitoring: percentage of used space in a block

Description: Oracle monitoring: percentage of used space in a block
Field Name: PCT_USED
Data Element: ORA_PCT_USED
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_USED

ORA_DBA_TABLES-INI_TRANS table field - Oracle monitoring: Initial number of transactions

Description: Oracle monitoring: Initial number of transactions
Field Name: INI_TRANS
Data Element: ORA_INI_TRANS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INI_TRANS

ORA_DBA_TABLES-MAX_TRANS table field - Oracle monitoring: Maximum number of transactions

Description: Oracle monitoring: Maximum number of transactions
Field Name: MAX_TRANS
Data Element: ORA_MAX_TRANS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_TRANS

ORA_DBA_TABLES-INITIAL_EXTENT table field - Oracle monitoring: Size of the initial extent in bytes

Description: Oracle monitoring: Size of the initial extent in bytes
Field Name: INITIAL_EXTENT
Data Element: ORA_INITIAL_EXTENT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INITIAL_EXTENT

ORA_DBA_TABLES-NEXT_EXTENT table field - Oracle monitor: Next extent

Description: Oracle monitor: Next extent
Field Name: NEXT_EXTENT
Data Element: ORA_NEXT_EXTENT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXT_EXTENT

ORA_DBA_TABLES-MIN_EXTENTS table field - Oracle monitor: Minimum extent

Description: Oracle monitor: Minimum extent
Field Name: MIN_EXTENTS
Data Element: ORA_MIN_EXTENTS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_EXTENTS

ORA_DBA_TABLES-MAX_EXTENTS table field - Oracle monitor: Maximum extent

Description: Oracle monitor: Maximum extent
Field Name: MAX_EXTENTS
Data Element: ORA_MAX_EXTENTS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_EXTENTS

ORA_DBA_TABLES-PCT_INCREASE table field - Oracle monitor. PCT increase

Description: Oracle monitor. PCT increase
Field Name: PCT_INCREASE
Data Element: ORA_PCT_INCREASE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_INCREASE

ORA_DBA_TABLES-FREELISTS table field - Oracle monitoring: Number of process freelists allocated

Description: Oracle monitoring: Number of process freelists allocated
Field Name: FREELISTS
Data Element: ORA_FREELISTS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREELISTS

ORA_DBA_TABLES-FREELIST_GROUPS table field - Oracle monitoring: Number of freelist groups allocated

Description: Oracle monitoring: Number of freelist groups allocated
Field Name: FREELIST_GROUPS
Data Element: ORA_FREELIST_GROUPS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREELIST_GROUPS

ORA_DBA_TABLES-LOGGING table field - Oracle monitoring: Logging attribute

Description: Oracle monitoring: Logging attribute
Field Name: LOGGING
Data Element: ORA_LOGGINGA
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGGING

ORA_DBA_TABLES-BACKED_UP table field - Oracle monitoring: Has table been backed up since last chang

Description: Oracle monitoring: Has table been backed up since last chang
Field Name: BACKED_UP
Data Element: ORA_BACKED_UP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BACKED_UP

ORA_DBA_TABLES-NUM_ROWS table field - Oracle monitoring: Number of rows in the table

Description: Oracle monitoring: Number of rows in the table
Field Name: NUM_ROWS
Data Element: ORA_NUM_ROWS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_ROWS

ORA_DBA_TABLES-BLOCKS table field - Oracle monitoring: Number of used data blocks in the table

Description: Oracle monitoring: Number of used data blocks in the table
Field Name: BLOCKS
Data Element: ORA_BLOCKS_USED
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKS

ORA_DBA_TABLES-EMPTY_BLOCKS table field - Oracle monitoring: Number of empty (never used) data blocks

Description: Oracle monitoring: Number of empty (never used) data blocks
Field Name: EMPTY_BLOCKS
Data Element: ORA_EMPTY_BLOCKS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPTY_BLOCKS

ORA_DBA_TABLES-AVG_SPACE table field - Oracle monitoring: avg. free space (bytes) in a data block

Description: Oracle monitoring: avg. free space (bytes) in a data block
Field Name: AVG_SPACE
Data Element: ORA_AVG_SPACE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_SPACE

ORA_DBA_TABLES-CHAIN_CNT table field - Oracle monitoring: Number of rows in table that are chained

Description: Oracle monitoring: Number of rows in table that are chained
Field Name: CHAIN_CNT
Data Element: ORA_CHAIN_CNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHAIN_CNT

ORA_DBA_TABLES-AVG_ROW_LEN table field - Oracle monitoring: Average length of a row in table (bytes)

Description: Oracle monitoring: Average length of a row in table (bytes)
Field Name: AVG_ROW_LEN
Data Element: ORA_AVG_ROW_LEN
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_ROW_LEN

ORA_DBA_TABLES-AVG_SPACE_FREE table field - Oracle monitoring: avg. freespace of all blocks on freelist

Description: Oracle monitoring: avg. freespace of all blocks on freelist
Field Name: AVG_SPACE_FREE
Data Element: ORA_AVG_SPACE_FREE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_SPACE_FREE

ORA_DBA_TABLES-NUM_FREELIST_BLK table field - Oracle monitoring: number of blocks on the freelist

Description: Oracle monitoring: number of blocks on the freelist
Field Name: NUM_FREELIST_BLK
Data Element: ORA_NUM_FREELIST_BLK
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_FREELIST_BLK

ORA_DBA_TABLES-DEGREE table field - Oracle monitoring: number of threads per instance for scan

Description: Oracle monitoring: number of threads per instance for scan
Field Name: DEGREE
Data Element: ORA_DEGREE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEGREE

ORA_DBA_TABLES-INSTANCES table field - Oracle monitoring:inst. across which table is to be scanned

Description: Oracle monitoring:inst. across which table is to be scanned
Field Name: INSTANCES
Data Element: ORA_INSTANCES
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCES

ORA_DBA_TABLES-CACHE table field - Oracle monitoring:Whether the cluster is to be cached in buf

Description: Oracle monitoring:Whether the cluster is to be cached in buf
Field Name: CACHE
Data Element: ORA_CACHE_DBA
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_5
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHE

ORA_DBA_TABLES-TABLE_LOCK table field - Oracle monitoring: Whether table locking is enabled or disab

Description: Oracle monitoring: Whether table locking is enabled or disab
Field Name: TABLE_LOCK
Data Element: ORA_TABLE_LOCK
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_LOCK

ORA_DBA_TABLES-SAMPLE_SIZE table field - Oracle monitoring: Sample size used in analyzing this table

Description: Oracle monitoring: Sample size used in analyzing this table
Field Name: SAMPLE_SIZE
Data Element: ORA_SAMPLE_SIZE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAMPLE_SIZE

ORA_DBA_TABLES-LAST_ANALYZED_D table field - Oracle monitoring: Date of last table analysis (date field)

Description: Oracle monitoring: Date of last table analysis (date field)
Field Name: LAST_ANALYZED_D
Data Element: ORA_LAST_ANALYZED_D
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ANALYZED_D

ORA_DBA_TABLES-LAST_ANALYZED_T table field - Oracle monitoring: Date of last table analysis (time field)

Description: Oracle monitoring: Date of last table analysis (time field)
Field Name: LAST_ANALYZED_T
Data Element: ORA_LAST_ANALYZED_T
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ANALYZED_T

ORA_DBA_TABLES-PARTITIONED table field - Oracle monitoring: Indicates whether table is partitioned

Description: Oracle monitoring: Indicates whether table is partitioned
Field Name: PARTITIONED
Data Element: ORA_PARTITIONED
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITIONED

ORA_DBA_TABLES-IOT_TYPE table field - Oracle monitoring: IOT type

Description: Oracle monitoring: IOT type
Field Name: IOT_TYPE
Data Element: ORA_IOT_TYPE
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOT_TYPE

ORA_DBA_TABLES-TEMPORARY_DBA table field - Oracle monitoring: data visible which is placed by this sess

Description: Oracle monitoring: data visible which is placed by this sess
Field Name: TEMPORARY_DBA
Data Element: ORA_TEMPORARY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEMPORARY_DBA

ORA_DBA_TABLES-SECONDARY table field - Oracle monitoring: Is trigger a secondary object

Description: Oracle monitoring: Is trigger a secondary object
Field Name: SECONDARY
Data Element: ORA_SECONDARY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SECONDARY

ORA_DBA_TABLES-NESTED table field - Oracle monitoring: Is the table a nested table?

Description: Oracle monitoring: Is the table a nested table?
Field Name: NESTED
Data Element: ORA_NESTED
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NESTED

ORA_DBA_TABLES-BUFFER_POOL table field - Oracle monitoring: The default buffer pool for the object

Description: Oracle monitoring: The default buffer pool for the object
Field Name: BUFFER_POOL
Data Element: ORA_BUFFER_POOL
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_7
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFER_POOL

ORA_DBA_TABLES-ROW_MOVEMENT table field - Oracle monitoring: partitioned row movement is enabled ?

Description: Oracle monitoring: partitioned row movement is enabled ?
Field Name: ROW_MOVEMENT
Data Element: ORA_ROW_MOVEMENT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_MOVEMENT

ORA_DBA_TABLES-GLOBAL_STATS table field - Oracle monitoring: Stats collected for whole table or estima

Description: Oracle monitoring: Stats collected for whole table or estima
Field Name: GLOBAL_STATS
Data Element: ORA_GLOBAL_STATS
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GLOBAL_STATS

ORA_DBA_TABLES-USER_STATS table field - Oracle monitoring: Were statistics entered directly by user?

Description: Oracle monitoring: Were statistics entered directly by user?
Field Name: USER_STATS
Data Element: ORA_USER_STATS
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_STATS

ORA_DBA_TABLES-DURATION table field - Oracle monitoring: duration of a temporary table

Description: Oracle monitoring: duration of a temporary table
Field Name: DURATION
Data Element: ORA_DURATION
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_15
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DURATION

ORA_DBA_TABLES-SKIP_CORRUPT table field - Oracle monitoring: If Oracle ignores blocks marked corrupt

Description: Oracle monitoring: If Oracle ignores blocks marked corrupt
Field Name: SKIP_CORRUPT
Data Element: ORA_SKIP_CORRUPT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SKIP_CORRUPT

ORA_DBA_TABLES-MONITORING table field - Oracle monitoring: table has the MONITORING attribute set

Description: Oracle monitoring: table has the MONITORING attribute set
Field Name: MONITORING
Data Element: ORA_MONITORING
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MONITORING

ORA_DBA_TABLES-CLUSTER_OWNER table field - Oracle monitoring: Cluster owner

Description: Oracle monitoring: Cluster owner
Field Name: CLUSTER_OWNER
Data Element: ORA_CLUSTER_OWNER
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLUSTER_OWNER

ORA_DBA_TABLES-DEPENDENCIES table field - Oracle monitoring: Dependencies

Description: Oracle monitoring: Dependencies
Field Name: DEPENDENCIES
Data Element: ORA_DEPENDENCIES
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEPENDENCIES

ORA_DBA_TABLES-COMPRESSION table field - Oracle monitoring: Compression

Description: Oracle monitoring: Compression
Field Name: COMPRESSION
Data Element: ORA_COMPRESSION
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPRESSION


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table