SAP ABAP Class CL_DB6_ACTION_SQL_CACHE (SQL Cache Snapshot)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_DB6_ACTION_CONTROLLER	DB6: Abstract Action Controller	20100519
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DBA_ACTION_CONTROLLER_ALV	DBA Cockpit: Access to ALV object	20070926
3	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DBA_ACTION_CONTROLLER_SLCT	DBA Cockpit: Data Selection	20070927

Properties

Class	CL_DB6_ACTION_SQL_CACHE
Short Description	SQL Cache Snapshot
Super Class	CL_DB6_ACTION_CONTROLLER	DB6: Abstract Action Controller
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU6	DB6: Performance-Monitor (UNIX/Windows)
Created	20050208	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	DB6CC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_DBA_ACTION_CONTROLLER_ALV	☐	☐	DBA Cockpit: Access to ALV object	20070926
2	IF_DBA_ACTION_CONTROLLER_SLCT	☐	☐	DBA Cockpit: Data Selection	20070927

Friends

Class CL_DB6_ACTION_SQL_CACHE has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV		DB6: simple ALV abstraction	20050208
2	FIRST_DISPLAY	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE		20050209
3	NAV_REF	Instance attribute	Private	☐	Attribute reference (LIKE)				20050208
4	VIEW_DATA	Instance attribute	Private	☐	Type reference (TYPE)	DB6_VIEW_SQLCACHE		DB6: View Data of SQL Cache	20050208

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CALC_ACCESS_EFFICIENCY	Static method	Public	Method	calculate rows read / rows returned to appl.	20080730
2	CALC_BPGETS_PER_EXECUTION	Static method	Public	Method	calculate bp page reads per execution	20080730
3	CALC_BPGETS_PER_ROWRET	Static method	Public	Method	calculate bp page reads per row returned to appl.	20080730
4	NAVIGATE_FORWARD	Instance method	Private	Method	navigate to Source or EXPLAIN	20050208
5	RESELECT	Instance method	Private	Method	reselect data from cluster	20050209
6	SET_GRID_ATTRIBUTES	Instance method	Private	Method	set ALV Grid attributes	20050208
7	SHOW_FILTER	Instance method	Private	Method	call filter popup	20050209

Events

Class CL_DB6_ACTION_SQL_CACHE has no event.

Types

Class CL_DB6_ACTION_SQL_CACHE has no local type.

Method Signatures

Method CALC_ACCESS_EFFICIENCY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	DB6PMSQC-ACC_EFFICIENCY		Quality of Read Predicate (%)	20080730
2	Importing	ROWS_READ	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-RW_READ		rows_read: Rows Read	20080730
3	Importing	ROWS_RETURNED	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-ROWS_RETURNED			20080730

Method CALC_ACCESS_EFFICIENCY on class CL_DB6_ACTION_SQL_CACHE has no exception.

Method CALC_BPGETS_PER_EXECUTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	NUM_EXECUT	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-NUM_EXECUT		num_executions: Number of Executions	20080730
2	Importing	PL_COL_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_COL_LRS		pool_col_l_reads	20130617
3	Importing	PL_D_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_D_LRS		pool_data_l_reads	20080730
4	Importing	PL_I_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_I_LRS		pool_index_l_reads	20080730
5	Importing	PL_TD_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TD_LRS		pool_temp_data_l_reads	20080730
6	Importing	PL_TEMP_COL_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TEMP_COL_LRS		pool_temp_col_l_reads	20130617
7	Importing	PL_TEMP_XDA_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TEMP_XDA_LRS		pool_temp_xda_l_reads	20080730
8	Importing	PL_TI_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TI_LRS		pool_temp_index_l_reads	20080730
9	Importing	PL_XDA_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_XDA_LRS		pool_xda_l_reads	20080730
10	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	DB6PMSQC-BPGETS_ROWRET			20080730

Method CALC_BPGETS_PER_EXECUTION on class CL_DB6_ACTION_SQL_CACHE has no exception.

Method CALC_BPGETS_PER_ROWRET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PL_COL_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_COL_LRS		pool_xda_l_reads	20130614
2	Importing	PL_D_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_D_LRS		pool_data_l_reads	20080730
3	Importing	PL_I_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_I_LRS		pool_index_l_reads	20080730
4	Importing	PL_TD_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TD_LRS		pool_temp_data_l_reads	20080730
5	Importing	PL_TEMP_COL_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TEMP_COL_LRS		pool_temp_xda_l_reads	20130614
6	Importing	PL_TEMP_XDA_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TEMP_XDA_LRS		pool_temp_xda_l_reads	20080730
7	Importing	PL_TI_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_TI_LRS		pool_temp_index_l_reads	20080730
8	Importing	PL_XDA_LRS	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-PL_XDA_LRS		pool_xda_l_reads	20080730
9	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	DB6PMSQC-BPGETS_ROWRET			20080730
10	Importing	ROWS_RETURNED	Call by reference	☐	Type reference (TYPE)	DB6PMSQC-ROWS_RETURNED			20080730

Method CALC_BPGETS_PER_ROWRET on class CL_DB6_ACTION_SQL_CACHE has no exception.

Method NAVIGATE_FORWARD Signature

Method NAVIGATE_FORWARD on class CL_DB6_ACTION_SQL_CACHE has no parameter.
Method NAVIGATE_FORWARD on class CL_DB6_ACTION_SQL_CACHE has no exception.

Method RESELECT Signature

Method RESELECT on class CL_DB6_ACTION_SQL_CACHE has no parameter.
Method RESELECT on class CL_DB6_ACTION_SQL_CACHE has no exception.

Method SET_GRID_ATTRIBUTES Signature

Method SET_GRID_ATTRIBUTES on class CL_DB6_ACTION_SQL_CACHE has no parameter.
Method SET_GRID_ATTRIBUTES on class CL_DB6_ACTION_SQL_CACHE has no exception.

Method SHOW_FILTER Signature

Method SHOW_FILTER on class CL_DB6_ACTION_SQL_CACHE has no parameter.
Method SHOW_FILTER on class CL_DB6_ACTION_SQL_CACHE has no exception.

History

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