SAP ABAP Table LTC_PROTEC_STMT2 (Latch Monitoring)

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	LTC_PROTEC_STMT2	Table Relationship Diagram
Short Description	Latch Monitoring

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	CHILD_LATCH	☐	ORA_CHILD_LATCH	ORA_NUMBER	DEC	22	0	Oracle Monitoring: CHILD_LATCH: Child Latch Number
2	INST_ID	☐	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
3	ADDRESS	☐	ORA_ADDRESS	ORA_RAW_8	RAW	8	0	Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor
4	HASH_VALUE	☐	ORA_HASH_VALUE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment
5	USERNAME	☐	ORA_USERNAME	ORA_USERNAME	CHAR	30	0	Oracle monitoring: USERNAME: Oracle username
6	EXECUTIONS	☐	ORA_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: EXECUTIONS: # Executions
7	SQL_MODULE	☐	ORA_SQL_MODULE	ORA_CHAR_64	CHAR	64	0	Oracle Monitoring: MODULE: Name of Module Causing Parsing
8	SQL_TEXT	☐	ORA_SQL_TEXT	ORA_CHAR_1000	LCHR	1000	0	Oracle Monitoring: SQL_TEXT: SQL Text of current cursor
9	PARSE_CALLS	☐	ORA_PARSE_CALLS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: PARSE_CALLS: Number of Parse Calls
10	PCALLS_PER_EXE	☐	ORA_PCALLS_PER_EXEC		DEC	22	5	Oracle Monitoring: Parse Calls Per Executions in gv$sql
11	PARSE_CALLS_PCT	☐	ORA_PARSE_CALLS_PCT	PERCENTAGE	DEC	8	4	Oracle Monitoring: Parse Calls of gv$sql in percentage
12	CPU_TIME	☐	ORA_CPU_TIME	ORA_NUMBER	DEC	22	0	Oracle Monitoring: CPU_TIME
13	CPU_TIME_PER_EXE	☐	ORA_CPU_TIME_PER_EXEC		DEC	22	2	Oracle Monitoring: CPU Time per execution in ms
14	CPU_TIME_PCT	☐	ORA_CPU_TIME_PCT	PERCENTAGE	DEC	8	4	Oracle Monitoring: CPU Time in percentage
15	ELAPSED_TIME	☐	ORA_ELAPSED_TIME	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ELAPSED_TIME: in microseconds
16	ELAPSED_TIME_PER_EXE	☐	ORA_ELAPSED_TIME_PER_EXE		DEC	22	2	Oracle Monitoring: Elapsed Time Per Executions in Ms
17	ELAPSED_TIME_PCT	☐	ORA_ELAPSED_TIME_PCT	PERCENTAGE	DEC	8	4	Oracle Monitoring: Elapsed Time in Percentage
18	DISK_READS	☐	ORA_DISK_READS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor
19	DISK_READS_PER_EXE	☐	ORA_DISK_READS_PER_EXEC		DEC	22	5	Oracle Monitoring: Disk Reads per Executions
20	DISK_READS_PCT	☐	ORA_DISK_READS_PCT	PERCENTAGE	DEC	8	4	Oracle Monitoring: Disk Reads in Percentage
21	BUFFER_GETS	☐	ORA_BUFFER_GETS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor
22	BUFFER_GETS_PER_EXE	☐	ORA_BUFFER_GETS_PER_EXE		DEC	22	5	Oracle Monitoring: Buffer Gets per Executions
23	BUFFER_GETS_PCT	☐	ORA_BUFFER_GETS_PCT	PERCENTAGE	DEC	8	4	Oracle Monitoring: Buffer Gets In Percentage
24	ROWS_PROCESSED	☐	ORA_ROWS_PROCESSED	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned
25	ROWS_PROCESSED_PER_EXE	☐	ORA_ROWS_PROCESSED_PER_EXE		DEC	22	5	Oracle monitoring: Rows Processed per Executions
26	ACTION	☐	ORA_ACTION_LATCH	ORA_CHAR_64	CHAR	64	0	Oracle Monitoring: gv$sql action

History

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