SAP Workload Monitoring Tool Tables
Are you looking for the right table related to SAP Workload Monitoring Tool 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 Workload Monitoring Tool (BC-CCM-MON-TUN) module.
Top 10 tables in Workload Monitoring Tool
| Table | Description |
|---|---|
| SGLWLCUST1 | User Parameters for Workload Transactions |
| SWNCT_TREX | TMC: TREX Statistics |
| GVD_SERVERLIST | Oracle Monitoring: Snapshot table for the R/3 serverlist |
| DBVSE | Table for Oracle DB Snapshots of V$SYSTEM_EVENT |
| GVD_DB_CACHE_ADV | Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) |
| GVD_OBJECT_DEPEN | Oracle monitoring: copy of GV$OBJECT_DEPENDENCY |
| EWOSS | Technical settings for transaction OSS1 |
| GVD_TEMPFILE | Copy of GV$TEMPFILE |
| GVD_SQLTEXT | Copy of GV$SQLTEXT (currently not provided with snapshots) |
| SAPWLROLED | SAP Workload: Storage of User-Specific ST03N Role |
List of tables in Workload Monitoring Tool
| Table | Description |
|---|---|
| SGLWLCUST1 | User Parameters for Workload Transactions |
| SWNCT_TREX | TMC: TREX Statistics |
| GVD_SERVERLIST | Oracle Monitoring: Snapshot table for the R/3 serverlist |
| DBVSE | Table for Oracle DB Snapshots of V$SYSTEM_EVENT |
| GVD_DB_CACHE_ADV | Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) |
| GVD_OBJECT_DEPEN | Oracle monitoring: copy of GV$OBJECT_DEPENDENCY |
| EWOSS | Technical settings for transaction OSS1 |
| GVD_TEMPFILE | Copy of GV$TEMPFILE |
| GVD_SQLTEXT | Copy of GV$SQLTEXT (currently not provided with snapshots) |
| SAPWLROLED | SAP Workload: Storage of User-Specific ST03N Role |
| SAPWLT000 | SAP workload: statistics data |
| SAPWLT001 | SAP workload: Table statistics |
| BUFCHECK | Exception table of tables that cannot be buffered |
| GVD_LATCH | Copy of GV$LATCH |
| GVD_SESSTAT | Snapshot table for GV$SESSTAT (curr. not provided w. snaps) |
| SAPBWPRFLS | BW Workload: Relation of Workload Profile and Class Names |
| SAPWLTREEG | SAP Workload: Nodes for ST03G Tree Controls |
| AMDT | Control Table for Application Monitor / DB Storage |
| ORA_SAP_AUXSTATS | Oracle monitor: Copy of SAP_AUXSTATS |
| ORA_SAPKCBFWAIT | Copy of SAP$KCBFWAIT |
| SWNCMONI | SAP Workload NW Collector: Data Clusters |
| DBSTATHINF | INFORMIX update statistical information |
| GVD_PARAMETER2 | Copy of GV$PARAMETER2 (currently not provided with snapshot |
| PAHI_PARAM_SEL | Select the Parameters to Be recorded |
| GVD_SESS_IO | Copy of GV$SESS_IO (currently not provided with snapshots) |
| DBSTATHORA | Actual size of tables on the database (history) |
| GVD_LATCHCHILDS | Copy of GV$LATCH_CHILDREN |
| AMRH | Application Monitor: Hierarchy acc. to TCODE/REPORT |
| EWTABB | Table for EarlyWatch Report |
| SWLN3CMPIF | Non-R/3 Statistic: Action Type and Service Type Information |
| GVD_SHAR_P_ADV | Oracle Monitoring: Copy of gv$shared_pool_advice |
| SGLWLSLIST | SAP Workload: User-Specific System List for Global Analysis |
| SAPWLDMTHD | SAP Workload: Dynamically-Called Method for Events |
| GVD_SEGSTAT | Oracle monitoring: Copy of GV$SEGSTAT |
| ORA_TABLESPACES | Oracle monitor: Copy of DBA_TABLESPACES |
| MONI | Monitor table MONI |
| SAPWLSERV | SAP Workload: Table of active servers |
| GVD_DATABASE | Copy of GV$DATABASE (currently not provided with snapshots) |
| SAPWLREORG | SAP Workload: Reorganization control |
| GVD_SGARESIZEOPS | Oracle Monitoring: Copy of GV$SGA_RESIZE_OPS |
| AMSP | SQL trace position info in application monitor |
| DBSTATIORA | Actual size of indices on the database |
| SGLWLPRFLS | SAP Workload: Profile Codes and Class Names |
| TNETMAC | Maintenance of mac addresses in SAP network monitor |
| SWNC_SETTINGS | Collector Settings |
| SAPWLCOLPA | SAP Workload: Parameters for Workload and Collector Control |
| SWNCT_TABREC | TMC: Table Access Aggregate |
| ST04N_ANAT | Detailed analyses in ST04N (Node names) |
| SWNCT_FRONTEND | TMC: Frontend Aggregate |
| SAPWLTREET | SAP Workload: Text Field for ST03G Trees |
| DBSTATTINF | INFORMIX update statistical information |
| SWNCT_AHITLISTRT | TMC: Application Statistics, Hit List by Response Times |
| SWNCT_WEBSD | TMC: Web Client Destinations Aggregate |
| SWNCT_DBCON | TMC: Database Connection Aggregate |
| SWNCCOLLPARAM | SAP Workload NW Collector: Collector Parameters |
| SWNCT_RFCSRV | TMC: RFC Server Aggregate |
| GVD_PX_SESSION | Oracle monitoring: Copy of GV$PX_SESSION |
| ORA_DBA_EXTENTS | Copy of DBA_EXTENTS (currently not provided with snapshots) |
| SWNCT_EXTSYST | TMC: Statistics from External Systems |
| SWLN3MOIDX | Non-R/3 Statistic: Index of Existing Aggregates |
| GVD_DATAGUARD_ST | Copy of GV$DATAGUARD_STATUS |
| SWNCT_RFCCLID | TMC: RFC Client Destination Aggregate |
| TCOLL | Configuration: Data collection for performance monitoring |
| ORA_SNAPSHOT | Master data of an oracle monitor snapshot |
| SWLN3PARAM | Non-R/3 Statistic: Control Parameters |
| SWNC_TCOLL_LOG | Log of the SWNC TCOLL Runner (CL_SWNC_TCOLL_RUNNER) |
| SWNCT_TCDET | TMC: Transaction Detail Aggregate |
| GST04SRVRS | List of all R/3 instances with DB |
| GVD_WPTOTALINFO | Oracle Monitoring: Workprocess Information snapshot table |
| GVD_SGACURRRESIZ | Oracle monitoring: Snapshot table for GV$SGA_CURRENT_RESIZE |
| SWNCT_USERWLOAD | TMC: Billing Statistics |
| GVD_PROCESS | Copy of GV$PROCESS |
| USER_DIR | Table used to store user def. directories to be used in al11 |
| SWLN3WORKL | Non-R/3 Statistic: Summarized Statistic Data (Aggregates) |
| TUNE1 | Tune: Maximum Puffer Sizes/Directory Entries Reached |
| SWNCT_HITLISTDB | TMC: Hit Lists by Database Access |
| GVD_PARAMETER | Copy of GV$PARAMETER |
| SWNCT_AHITLISTDB | TMC: Application Statistics, Hit List by Database Access |
| ORA_DBA_SEGMENTS | Copy of DBA_SEGMENTS (currently not provided with snapshots) |
| ST04N_ANA | Detailed analyses in ST04N |
| GVD_BUFF_POOL_ST | Oracle Monitoring: Copy of gv$buffer_pool_statistics |
| SWNCT_TASKTYPE | SWNC: TMC Task Type Profile |
| SWNCCOLLPERFTOT | Performance Data of the Workload Collector |
| AMSK | SQL trace header info in application monitor |
| GVD_SQLAREA | Copy of GV$SQLAREA (currently not provided with snapshots) |
| SWNCCOLLPERF | Performance Data of the Workload Collector |
| ORA_DBA_OBJECTS | Copy of DBA_OBJECTS (currently not provided with snapshots) |
| SWNCCOLLPATXT | SAP Workload NW Collector: Collector Parameters |
| TSHM0 | Name texts for shared memory segments |
| GVD_PGA_TARGET_A | Copy of GV$PGA_TARGET_ADVICE |
| ST04N_LIM | Limiting values for lights in oracle main monitor |
| GVD_UNDOSTAT | Oracle monitoring: copy of GV$UNDOSTAT |
| SWNCT_RFCSRVD | TMC: RFC Server Destination Aggregate |
| SWNCT_RFCCLI | TMC: RFC Client Aggregate |
| SWNCUI_SEL | Selections for Data Evaluation |
| GVD_ROWCACHE | Oracle monitoring: Copy of GV$ROWCACHE |
| TNETMONINF | Network Monitor:Configuration data and work information |
| DBSTAIHORA | Actual size of indices on the database (history) |
| DBSTATIADA | Actual size of indices on the database |
| GVD_SGADYNCOMP | Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON |
| TSTAM | Application object tables |
| EARLY | Monitor table MONI |
| GVD_PGASTAT | Copy of GV$PGASTAT |
| SWNCCOLLCOMPRESS | SAP Workload NW Collector: Aggregate Compression Parameters |
| GVD_SESSION_WAIT | Oracle monitoring: Copy of GV$SESSION_WAIT |
| GVD_SQL | Copy of GV$SQL (currently not provided with snapshots) |
| SWNCT_MEMORY | TMC: Memory Consumption Aggregate |
| SWNCT_USERTCODE | SWNC: TMC User Code Profile |
| GVD_SGA | Oracle monitoring: Snapshot table for GV$SGA |
| DBCHK | Exceptions for data base checks |
| DBSTATTADA | Actual size of tables on the database |
| PAHI | History of system, DB and SAP parameter |
| SWNCT_VMC | TMC: VMC Aggregate |
| GVD_SGASTAT | Oracle monitoring: Snapshot table for GV$SGASTAT |
| SAPWLGTCTRL | Control Table: Dialog Response Times Without GUI Time |
| SWNCT_FE | TMC: HTTP FE Statistics |
| GVD_WAITSTAT | Oracle Monitoring: Copy of GV$WAITSTAT |
| DBSNP | Database snapshots |
| SWNCT_WEBCD | TMC: Web Client Destinations Aggregate |
| ORA_DBA_TABLES | Copy of DBA_TABLES (currently not provided with snapshots) |
| GVD_LOGFILE | Oracle monitoring: Copy of GV$LOGFILE |
| SWNCT_APPSTAT | TMC: Application Statistics |
| SAPWLT002 | SAP workload: RFC statistics data |
| GVD_PGA_TARGET_H | Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM |
| SWNCT_HITLISTRT | TMC: Hit Lists by Response Time |
| SWNCT_WEBS | TMC: Web Server Aggregate |
| AMDS | Effective size of tables and indexes in the database |
| GVD_SQL_WA_ACTIV | Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE |
| GVD_SEGMENT_STAT | Copy of GV$SEGMENT_STATISTICS (curr. not provided w. snaps) |
| SWNCT_DBPROC | TMC: Database Procedures Aggregate |
| GVD_LIBRARYCACHE | Oracle monitoring: Copy of GV$LIBRARYCACHE |
| WPTOTLIUSR | User settings in global work process overview |
| GVD_SESSION | Oracle monitoring: Snapshot table for GV$SESSION |
| TUNEOPSGEN | table for generate decision |
| TSTAMK | Classification of SAP Tables by Expected Size in Production |
| GVD_ENQUEUE_STAT | Copy of GV$ENQUEUE_STAT |
| GVD_SESSION_EVT | Oracle monitoring: copy of GV$SESSION_EVENT |
| DBSTATTORA | Actual size of tables on the database |
| SWNCT_WEBC | TMC: Web Client Aggregate |
| ORA_HISTPAR | Parameter values for oracle history collector |
| TAME0 | Application Monitor: Table - Event |
| GVD_LOCK_ACTIVTY | Copy of GV$LOCK_ACTIVITY |
| GVD_SGADYNFREE | Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_FREE_M |
| GVD_SYSTEM_EVENT | Copy of GVSSYSTEM_EVENT |
| SAPWLROLES | SAP Workload: Table for User-Specific Parameters |
| GVD_SQL_WA_HISTO | Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM |
| SWNCMONIINDEX | SAP Workload NW Collector: Data Cluster Index Table |
| ORA_RESUMABLE | Oracle monitor: Copy of DBA_RESUMABLE |
| SWNCT_SPOOLACT | TMC: Spool Activity Aggregate |
| GVD_LATCHHOLDER | Copy of GV$LATCHHOLDER (currently not provided with snapsh) |
| DBSTATHADA | Actual size of tables on the database (history) |
| GVD_SYSSTAT | Copy of GV$SYSTAT |
| GVD_SQL_WORKAREA | Oracle Monitoring: Copy of GV$SQL_WORKAREA |
| TRS35 | Control Table RSSTAT35 Collector Run |
| DBSTAIHADA | Actual size of indices on the database (history) |
| GVD_LOCK | Copy of GV$LOCK |
| SWNCCOLLPACKSIZE | SAP Workload NW Collector: Automatic Package Sizes |
| GVD_LATCHNAME | Copy of GV$LATCHNAME (currently not provided with snapshots) |
| SWNCGLOBDEST | SAP Workload NW Collector: GLOB_STAT RFC Destinations |
| ORA_IDLE_EVENTS | Oracle: Idle events |
| GVD_LOCKED_OBJEC | Copy of GV$LOCKED_OBJECT |
| GVD_LATCH_MISSES | Copy of GV$LATCH_MISSES |
| EWJOBSCHED | Scheduling parameters for EarlyWatch background jobs |
| GVD_BGPROCESS | Oracle monitoring: Copy of GV$BGPROCESS |
| SWNCCOLLSTORAGE | Aggregate Storage |
| GVD_DATAFILE | Copy of GV$DATAFILE |
| TSEXC | Standard Values for Performance Monitoring |
| GVD_FILESTAT | Copy of GV$FILESTAT |
| GVD_LATCH_PARENT | Copy of GV$LATCH_PARENT (currently not provided with snaps) |
| SWLN3CMPIT | Non-R/3 Statistic: Action Type and Service Type Information |