SAP ABAP Table GTY_DETAIL_DB (Detailed Structure for Database Details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON (Application Component) Monitoring
     ⤷ SWNC_STADWD (Package) STAD (Single Statistics Records Display) with Web Dynpro UI

Basic Data

Table Category	INTTAB	Structure
Structure	GTY_DETAIL_DB	Table Relationship Diagram
Short Description	Detailed Structure for Database Details

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CONNECTION_NAME	☐	SWNCWDDB_CONN	SWNCDOMTXT30	CHAR	30	0	Name of a Logical Database Connection
2	DBCALLTI	☐	SWNCWDDBCALLTI	SWNCDOMDEC24	DEC	24	0	Time for Database Queries in ms
3	DBCALLS	☐	SWNCWDDBCALLS	SWNCDOMDEC12	DEC	12	0	Number of Database Queries
4	COMMITTI	☐	SWNCWDCOMMITTI	SWNCDOMDEC24	DEC	24	0	Time for COMMIT WORK in ms
5	DBPROCCNT	☐	SWNCWDDBPROCCNT	SWNCDOMDEC12	DEC	12	0	Number of Database Procedures Called
6	DBPROCTI	☐	SWNCWDDBPROCTI	SWNCDOMDEC24	DEC	24	0	Time Spent in Database Procedures in ms
7	RECCNT	☐	SWNCWDRECCNT	SWNCDOMDEC12	DEC	12	0	Number of Requested Database Table Records
8	BUFCALLS	☐	SWNCWDBUFCALLS	SWNCDOMDEC12	DEC	12	0	Number of Buffer Queries
9	PHYCALLS	☐	SWNCWDPHYCALLS	SWNCDOMDEC12	DEC	12	0	Number of Calls to the Database
10	AVTDB	☐	SWNCWDAVTDB	SWNCDOMDEC24	DEC	24	0	Average Duration of a Database Request in ms
11	READCNT	☐	SWNCWDREADCNT	SWNCDOMDEC12	DEC	12	0	Number of Requested Read Operations on the Database
12	READDIRREC	☐	SWNCWDREADDIRREC	SWNCDOMDEC12	DEC	12	0	Number of Directly Requested Records
13	READDIRCNT	☐	SWNCWDREADDIRCNT	SWNCDOMDEC12	DEC	12	0	Number of Direct Read Accesses to Database Tables
14	READDIRBUF	☐	SWNCWDREADDIRBUF	SWNCDOMDEC12	DEC	12	0	Number of Direct Read Accesses to Buffer
15	READDIRTI	☐	SWNCWDREADDIRTI	SWNCDOMDEC24	DEC	24	0	Time for Direct Read Requests in ms
16	AVTREADDIR	☐	SWNCWDAVTREADDIR	SWNCDOMDEC24	DEC	24	0	Average Time for a Direct Read Request
17	READSEQREC	☐	SWNCWDREADSEQREC	SWNCDOMDEC12	DEC	12	0	Number of Sequentially Requested Records
18	READSEQCNT	☐	SWNCWDREADSEQCNT	SWNCDOMDEC12	DEC	12	0	Number of Sequential Read Accesses to Database Tables
19	READSEQBUF	☐	SWNCWDREADSEQBUF	SWNCDOMDEC12	DEC	12	0	Number of Sequential Read Accesses to the Buffer
20	PHYREADCNT	☐	SWNCWDPHYREADCNT	SWNCDOMDEC12	DEC	12	0	Number of Update Operations on the Database
21	READSEQTI	☐	SWNCWDREADSEQTI	SWNCDOMDEC24	DEC	24	0	Time for Sequential Read Requests in ms
22	AVTREADSEQ	☐	SWNCWDAVTREADSEQ	SWNCDOMDEC24	DEC	24	0	Average Time for a Sequential Read Operation
23	UPDREC	☐	SWNCWDUPDREC	SWNCDOMDEC12	DEC	12	0	Number of Requested Table Records for Update
24	UPDCNT	☐	SWNCWDUPDCNT	SWNCDOMDEC12	DEC	12	0	Number of Updates Requested in the Database
25	PHYUPDCNT	☐	SWNCWDPHYUPDCNT	SWNCDOMDEC12	DEC	12	0	Number of Physical Read Operations on the Database
26	UPDTI	☐	SWNCWDUPDTI	SWNCDOMDEC24	DEC	24	0	Time for Update Requests in ms
27	AVTUPD	☐	SWNCWDAVTUPD	SWNCDOMDEC24	DEC	24	0	Average Time for an Update Request in ms
28	DELREC	☐	SWNCWDDELREC	SWNCDOMDEC12	DEC	12	0	Number of Table Records for Delete Requests
29	DELCNT	☐	SWNCWDDELCNT	SWNCDOMDEC12	DEC	12	0	Number of Requested Deletions in the Database
30	PHYDELCNT	☐	SWNCWDPHYDELCNT	SWNCDOMDEC12	DEC	12	0	Number of Physical Delete Operations on the Database
31	DELTI	☐	SWNCWDDELTI	SWNCDOMDEC24	DEC	24	0	Time for Deletion Requests in ms
32	AVTDEL	☐	SWNCWDAVTDEL	SWNCDOMDEC24	DEC	24	0	Average Time for a Delete Request in ms
33	INSREC	☐	SWNCWDINSREC	SWNCDOMDEC12	DEC	12	0	Nuber of Inserted Table Records
34	INSCNT	☐	SWNCWDINSCNT	SWNCDOMDEC12	DEC	12	0	Number of Requested Insert Operations on the Database
35	PHYINSCNT	☐	SWNCWDPHYINSCNT	SWNCDOMDEC12	DEC	12	0	Number of Physical Insert Operations on the DB
36	INSTI	☐	SWNCWDINSTI	SWNCDOMDEC24	DEC	24	0	Time for Insert Requests in ms
37	AVTINS	☐	SWNCWDAVTINS	SWNCDOMDEC24	DEC	24	0	Average Time for an Insert Request in ms
38	PHYREADDIR	☐	SWNCWDPHYREADDIR	SWNCDOMDEC12	DEC	12	0	Number of Direct Read Calls on the Database
39	CHNGCNT	☐	SWNCWDCHNGCNT	SWNCDOMDEC12	DEC	12	0	Number of Requested Changes in the Database
40	PHYCHNGCNT	☐	SWNCWDPHYCHNGCNT	SWNCDOMDEC12	DEC	12	0	Number of Changes Made in the Database
41	CHNGTI	☐	SWNCWDCHNGTI	SWNCDOMDEC24	DEC	24	0	Time for Read Requests in ms
42	READTI	☐	SWNCWDREADTI	SWNCDOMDEC24	DEC	24	0	Time for Change Requests in ms

History

Last changed by/on	SAP	20100420
SAP Release Created in	712