SAP ABAP Table ORA_ISQ_DETAIL (Index Storage Quality - Objects of a Workingset)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA (Package) Database Monitor for Oracle

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ORA_ISQ_DETAIL	Table Relationship Diagram
Short Description	Index Storage Quality - Objects of a Workingset

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ID	☑	ORA_ISQ_ID	ORA_ISQ_ID	CHAR	30	0	Workingset ID
2	PARTITION_NAME	☑	ORA_ISQ_PARTITION_NAME	ORA_ISQ_PARTITION_NAME	CHAR	30	0	not used
3	INDEX_NAME	☑	ORA_ISQ_INDEX_NAME	ORA_ISQ_INDEX_NAME	CHAR	30	0	Index Name
4	TABLE_NAME	☑	ORA_ISQ_TABLE_NAME	ORA_ISQ_TABLE_NAME	CHAR	30	0	Table Name
5	TABLESPACE_NAME	☑	ORA_ISQ_TABLESPACE_NAME	ORA_ISQ_TABLESPACE_NAME	CHAR	30	0	Tablespace Name
6	FREELIST_GROUPS	☐	ORA_ISQ_FREELIST_GROUPS	ORA_ISQ_FREELIST_GROUPS	INT4	10	0	Freelist Groups
7	INI_TRANS	☐	ORA_ISQ_INI_TRANS	ORA_ISQ_INI_TRANS	INT4	10	0	ini trans
8	PCT_FREE	☐	ORA_ISQ_PCT_FREE	ORA_ISQ_PCT_FREE	INT4	10	0	pct free
9	ACTION	☐	ORA_ISQ_ACTION	ORA_ISQ_ACTION	CHAR	3	0	Object Action
10	METHOD	☐	ORA_ISQ_METHOD	ORA_ISQ_METHOD	CHAR	3	0	Object Method
11	STATUS	☐	ORA_ISQ_STATUS	ORA_ISQ_STATUS	CHAR	3	0	Status
12	RC	☐	ORA_ISQ_RC	ORA_ISQ_RC	INT4	10	0	Returncode
13	TRIALCOUNT	☐	ORA_ISQ_TRIALCOUNT	ORA_ISQ_TRIALCOUNT	INT4	10	0	Lock Counter
14	KB	☐	ORA_ISQ_KB	ORA_ISQ_KB	DEC	22	0	Size in KB
15	PRIORITY	☐	ORA_ISQ_PRIORITY	ORA_ISQ_PRIORITY	INT4	10	0	Priority
16	WP_PID	☐	ORA_ISQ_WP_PID	ORA_ISQ_WP_PID	CHAR	8	0	OS Workprocess Identifier
17	START_DATE	☐	ORA_ISQ_START_DATE	ORA_ISQ_DATE	DATS	8	0	Start Date
18	START_TIME	☐	ORA_ISQ_START_TIME	ORA_ISQ_TIME	TIMS	6	0	Start Time
19	WAIT_STAMP	☐	ORA_ISQ_WAIT_STAMP	ORA_ISQ_WAIT_STAMP	CHAR	14	0	Lock Wait Timestamp
20	INDEX_TYPE	☐	ORA_ISQ_INDEX_TYPE	ORA_ISQ_INDEX_TYPE	CHAR	5	0	not used

History

Last changed by/on	SAP	20070308
SAP Release Created in	710