ORA_ISQ_HISTORY - Index Storage Quality - Objectshistory Data
Index Storage Quality - Objectshistory Data information is stored in SAP table ORA_ISQ_HISTORY.
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_HISTORY
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CONNECTION_NAME | Connection Name | X | ORA_ISQ_CONNECTION_NAME | CHAR | 30 | |
| PARTITION_NAME | not used | X | ORA_ISQ_PARTITION_NAME | CHAR | 30 | |
| INDEX_NAME | Index Name | X | ORA_ISQ_INDEX_NAME | CHAR | 30 | |
| ID | Workingset ID | X | ORA_ISQ_ID | CHAR | 30 | |
| ID_START_DATE | Start Date | X | ORA_ISQ_START_DATE | DATS | 8 | |
| ID_START_TIME | Start Time | X | ORA_ISQ_START_TIME | TIMS | 6 | |
| ACTION | Object Action | X | ORA_ISQ_ACTION | CHAR | 3 | |
| METHOD | Object Method | X | ORA_ISQ_METHOD | CHAR | 3 | |
| TABLE_NAME | Table Name | X | ORA_ISQ_TABLE_NAME | CHAR | 30 | |
| TABLESPACE_NAME | Tablespace Name | X | ORA_ISQ_TABLESPACE_NAME | CHAR | 30 | |
| START_DATE | Start Date | ORA_ISQ_START_DATE | DATS | 8 | ||
| START_TIME | Start Time | ORA_ISQ_START_TIME | TIMS | 6 | ||
| END_DATE | End Date | ORA_ISQ_END_DATE | DATS | 8 | ||
| END_TIME | End Time | ORA_ISQ_END_TIME | TIMS | 6 | ||
| DURATION | Duration in seconds | ORA_ISQ_DURATION | INT4 | 4 | ||
| DATA | Data | ORA_ISQ_DATA | DEC | 12 | ||
| KB | Size in KB | ORA_ISQ_KB | DEC | 12 | ||
| INDEX_TYPE | not used | ORA_ISQ_INDEX_TYPE | CHAR | 5 |