SAP ABAP Table ORA_S_TOP_SEGMENTS_STATS (Structure for quering statistics for selected table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors

Basic Data

Table Category	INTTAB	Structure
Structure	ORA_S_TOP_SEGMENTS_STATS	Table Relationship Diagram
Short Description	Structure for quering statistics for selected table

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	SQL_ID	☐			CHAR	50	0
2	ACT_SESS	☐			DEC	5	2
3	EXECUTIONS	☐			DEC	10	0
4	ELA_TIME_MS	☐			DEC	10	0
5	ELA_MS_PER_EXEC	☐			DEC	10	2
6	CPU_TIME_MS	☐			DEC	10	0
7	CPU_MS_PER_EXEC	☐			DEC	10	2
8	ROWS_PROC	☐			DEC	10	0
9	ROWS_PER_EXEC	☐			DEC	10	2
10	DISK_READS	☐			DEC	10	0
11	READS_PER_EXEC	☐			DEC	10	2
12	BUFFER_GETS	☐			DEC	10	0
13	GETS_PER_EXEC	☐			DEC	10	2
14	GETS_PER_ROW	☐			DEC	10	2
15	DIRECT_WRITES	☐			DEC	10	2
16	CL_TIME_MS	☐			DEC	10	2
17	CL_MS_PER_EXEC	☐			DEC	10	2
18	AVG_PARSE_MS	☐			DEC	10	2
19	PX_SERVERS	☐			DEC	10	0
20	MODULE	☐			CHAR	50	0
21	TABLES	☐			CHAR	100	0
22	SQL_TEXT	☐	ORACH30000	ORACH30000	CHAR	30000	0	SQL statement text

History

Last changed by/on	SAP	20140117
SAP Release Created in	740