SAP Oracle Database Monitors Tables
Are you looking for the right table related to SAP Oracle Database Monitors Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Oracle Database Monitors (BC-CCM-MON-ORA) module.
Top 10 tables in Oracle Database Monitors
| Table | Description |
|---|---|
| ORA_ISQ_DETAIL | Index Storage Quality - Objects of a Workingset |
| DB02_COLL_PLAN | Oracle monitoring: List of coll. functions for DB02 |
| ORA_SQLC_HEAD | ORA: SQL Command Editor Header Table |
| ORA_STT_DATA | DBACockpit: Data table for RSORASTT |
| ORA_SQLC_STMT | Table with statements used by the SQL Command Editor |
| INDEX_STAT | index_stats Cache: Result of VALIDATE Index (Oracle) |
| ORA_ISQ_PARAM | Index Storage Quality - Parameters |
| GVD_SPPARAMETER | Oracle Monitoring: Copy of GV$SPPARAMETER |
| ORATSPINFO | Tablespace Information |
| ORA_ISQ_HISTORY | Index Storage Quality - Objectshistory Data |
List of tables in Oracle Database Monitors
| Table | Description |
|---|---|
| ORA_ISQ_DETAIL | Index Storage Quality - Objects of a Workingset |
| DB02_COLL_PLAN | Oracle monitoring: List of coll. functions for DB02 |
| ORA_SQLC_HEAD | ORA: SQL Command Editor Header Table |
| ORA_STT_DATA | DBACockpit: Data table for RSORASTT |
| ORA_SQLC_STMT | Table with statements used by the SQL Command Editor |
| INDEX_STAT | index_stats Cache: Result of VALIDATE Index (Oracle) |
| ORA_ISQ_PARAM | Index Storage Quality - Parameters |
| GVD_SPPARAMETER | Oracle Monitoring: Copy of GV$SPPARAMETER |
| ORATSPINFO | Tablespace Information |
| ORA_ISQ_HISTORY | Index Storage Quality - Objectshistory Data |
| ORAINDINFO | Information About the Storage Quality of the Indexes |
| ORA_DBA_TCOL | Oracle monitoring: Transparent table for table columns |
| DB02_COLL_LOG | Oracle monitoring: DB02 collector log |
| GVD_INSTANCE | Copy of GV$INSTANCE |
| TCS_GSETID | TimeChartSimple: IDs of stored graphic settings (customizg) |
| DB02N_ANAT | Detailed analyses in ST04N (Node names) |
| TCS_GSETTING | TimeChartSimple: Graphic settings |
| ORA_SQLCN_STMT | Oracle SQL Command Editor statement |
| ORA_SQLCN_STMTID | Oracle SQL Command Editor statement IDs |
| ORA_MON_DBCON | Oracle monitoring: list of external Oracle connections |
| ORA_FEAT_USED | ORA: Used Oracle Features for DBACockpit |
| ORA_JSEL_STMT | Oracle 'arbitrary join select monitor' statement |
| ORA_DBA_TCOLUMNS | Oracle monitoring: Transparent table for table columns |
| DB02N_ANA | Detailed analyses in ST04N |
| ORA_ASHGSETID | Oracle ASH monitor graphic settings |
| ORA_IND_QLTY | Oracle monitoring: Index storage quality |
| STIMEDEVENTS | Table to determine the order and the name of the event |
| ORA_SQLC_DATA | ORA: SQL Command Editor Data Table |
| TIME_STAT_AWR | Temporary table for AWR Graphics monitor |
| ORAISQCTRL | RSORAISQ Index Storage Quality Maintenance Control Table |
| ORA_ISQ_HEADER | Index Storage Quality - Header of a Workingset |
| ORA_STT_HEAD | DBACockpit: Header table for RSORASTT |
| ORA_DBH_CONFIG | Oracle DBH Settings |
| ORA_JSEL_STMTID | Oracle 'arbitrary join select monitor' statement IDs |
| GVD_CURR_BLKSRV | copy of gv$current_block_server |
| GVD_MANGD_STANBY | copy of GV$MANAGED_STANDBY (currently not provided w. snaps) |
| ORA_ASHGSET | Oracle ASH monitor graphic settings |