SAP ABAP Table ORA_PERFORMANCE_DB_STRUCTURE (Oracle Structure for Sub-Monitor Performance Database)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ORA_PERFORMANCE_DB_STRUCTURE	Table Relationship Diagram
Short Description	Oracle Structure for Sub-Monitor Performance Database

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	INST_ID	☐	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
2	WEEKDAY	☐	ORA_GVD_SYSSTAT_WEEKDAY	ORA_GVD_SYSSTAT_WEEKDAY	CHAR	30	0	Data Element weekday for ORA_PERFORMANCE_DB_STRUCTURE
3	SNAPSHOT_DATE	☐	ORA_GVD_SYSSTAT_DATE	ORA_GVD_SYSSTAT_DATE	DATS	8	0	Date Element date for ORA_PERFORMANCE_DB_STRUCTURE
4	SNAPSHOT_TIME	☐	ORA_GVD_SYSSTAT_TIME	ORA_GVD_SYSSTAT_TIME	TIMS	6	0	Data Element time for ORA_PERFORMANCE_DB_STRUCTURE
5	USER_CALLS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
6	REC_CALLS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
7	USER_REC_CALLS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
8	USER_COMMITS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
9	USER_ROLLBACKS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
10	PARSERS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
11	READS_USER_CALLS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
12	LOGICAL_READS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
13	PHYSICAL_READS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
14	PHYS_READS_DIR	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
15	PHYS_R_DIR_LOB	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
16	BUFFER_QUALITY	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
17	PHYS_WRITES	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
18	T_FETCH_ROWID	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
19	T_FET_CON_ROW	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
20	SCAN_ROWS_GOT	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
21	SC_BLOCKS_GOT	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
22	REDO_BLO_WRIT	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
23	REDO_WR_TIME	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
24	AVG_R_WR_TIME	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
25	BUF_BUSY_WAITS	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
26	BUF_BUSY_W_TIM	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
27	AVG_BUF_B_W_TI	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT
28	FULL_TAB_SCAN	☐	ORA_GVD_SYSSTAT_VALUE	ORA_GVD_SYSSTAT_VALUE	DEC	22	2	Data Elemen for value-field from GVD_SYSSTAT

History

Last changed by/on	SAP	20070813
SAP Release Created in	700