Many of our custom queries on this site utilize the CONSW tables within DPA. There is a CONSW table for each monitored instance, so the tables you will see are named CONSW_XX where XX is the ID value of the instance from the COND table.
This CONSW tables store the last 30 days of second-by-second detailed data. You can think of it as a fact table with several dimension tables hanging off it, i.e. a mini star schema. When the DPA product was first created, this was a main part of the architecture and the founders were nervous that others would figure out how the data was being stored. As a result, the column names in this table were obfuscated. Here is a description of those columns and the dimension tables they can be joined to for names of things, e.g. database names in SQL Server:
- XCUW – database user, join to CONU_XX to get name
- IXOY - multiple meanings based on monitored instance type
- SQL Server, MySQL, Postgres – database, join to CONO_XX
- Others - O/S user, join to CONO_XX
- PWMY – machine/IP, join to CONM_XX
- IZHO – SQL Hash, join to CONSS_XX for stats and CONST_XX for the text
- KXPI – P1 value from Oracle session
- IDSQ – P2 value from Oracle session
- KQTZ – P3 value from Oracle session
- KEEQ – wait type, join to CONEV_XX
- UDPW – Program/Application, join to CONPR_XX
- VDSI – SPID/SID of the session
- MDCP – Client Info value from Oracle session
- DBML – Module from Oracle session wait, join to CONMOD_XX
- RMAL – Action from Oracle session wait, join to CONACT_XX
- BLEE – Blockee SPID if blocking was occurring
- BLER – Blocker SPID if blocking was occurring
- ORPH – Plan handle, join to CONSPH_XX
- HGOB – Object, join to CONOBJ_XX
- CTFL – Filename, join to CONF_XX
- QP – Quick Poll interval in centiseconds, e.g. 100 = 1 second, 300 = 3 seconds of wait time
- D – date and time of measurement
