ORA_ISQ_DETAIL - Index Storage Quality - Objects of a Workingset
Index Storage Quality - Objects of a Workingset information is stored in SAP table ORA_ISQ_DETAIL.
It is part of development package S_DBMON_ORA in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle".
It is part of development package S_DBMON_ORA in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle".
Fields for table ORA_ISQ_DETAIL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| ID | Workingset ID | X | ORA_ISQ_ID | CHAR | 30 | |
| PARTITION_NAME | not used | X | ORA_ISQ_PARTITION_NAME | CHAR | 30 | |
| INDEX_NAME | Index Name | X | ORA_ISQ_INDEX_NAME | CHAR | 30 | |
| TABLE_NAME | Table Name | X | ORA_ISQ_TABLE_NAME | CHAR | 30 | |
| TABLESPACE_NAME | Tablespace Name | X | ORA_ISQ_TABLESPACE_NAME | CHAR | 30 | |
| FREELIST_GROUPS | Freelist Groups | ORA_ISQ_FREELIST_GROUPS | INT4 | 4 | ||
| INI_TRANS | ini trans | ORA_ISQ_INI_TRANS | INT4 | 4 | ||
| PCT_FREE | pct free | ORA_ISQ_PCT_FREE | INT4 | 4 | ||
| ACTION | Object Action | ORA_ISQ_ACTION | CHAR | 3 | ||
| METHOD | Object Method | ORA_ISQ_METHOD | CHAR | 3 | ||
| STATUS | Status | ORA_ISQ_STATUS | CHAR | 3 | ||
| RC | Returncode | ORA_ISQ_RC | INT4 | 4 | ||
| TRIALCOUNT | Lock Counter | ORA_ISQ_TRIALCOUNT | INT4 | 4 | ||
| KB | Size in KB | ORA_ISQ_KB | DEC | 12 | ||
| PRIORITY | Priority | ORA_ISQ_PRIORITY | INT4 | 4 | ||
| WP_PID | OS Workprocess Identifier | ORA_ISQ_WP_PID | CHAR | 8 | ||
| START_DATE | Start Date | ORA_ISQ_START_DATE | DATS | 8 | ||
| START_TIME | Start Time | ORA_ISQ_START_TIME | TIMS | 6 | ||
| WAIT_STAMP | Lock Wait Timestamp | ORA_ISQ_WAIT_STAMP | CHAR | 14 | ||
| INDEX_TYPE | not used | ORA_ISQ_INDEX_TYPE | CHAR | 5 |