SAP ABAP Class CL_ORA_DBC_SESSION_9 (Data Collector for SQL Request)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBCOCKPIT_ORA (Package) Oracle Monitoring with DBCOCKPIT Framework
Properties
Class CL_ORA_DBC_SESSION_9  
Short Description Data Collector for SQL Request    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package S_DBCOCKPIT_ORA   Oracle Monitoring with DBCOCKPIT Framework 
Created 20061127   SAP 
Last change 20070911   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_ORA_DBC_SESSION_9 has no forward declaration.
Interfaces
Class CL_ORA_DBC_SESSION_9 has no interface implemented.
Friends
Class CL_ORA_DBC_SESSION_9 has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 CON_REF Static Attribute Private Object reference (TYPE REF TO) CL_SQL_CONNECTION Connection Object for ADBC 20061127
2 ORA_VERSION Static Attribute Private Type reference (TYPE) STRING Database Release 20061127
Methods
# Method Level Visibility Method type Description Created on
1 BUILD_STATEMENT_BGPROCESS Static method Private Method Assemble SQL Statement for GV$PROCESS and GV$BGPROCESS 20061127
2 BUILD_STATEMENT_GORASESSION Static method Private Method Assemble SQL Statement for GV$SESSION + Other GV$ Tables 20061127
3 EXECUTE_QUERY_BGPROCESS_NAME Static method Private Method Create Background Process List 20061127
4 EXECUTE_QUERY_GORASESSION Static method Private Method Execute Query for GV$SESSION and Other GV$ Tables 20061127
5 GET_DATA_ORA_SESSION Static method Public Method Main Method for Data Extraction from GV$ Tables 20061127
6 GET_ORA_VERSION Static method Private Method Determine the ORACLE Version 20061127
Events
Class CL_ORA_DBC_SESSION_9 has no event.
Types
Class CL_ORA_DBC_SESSION_9 has no local type.
Method Signatures

Method BUILD_STATEMENT_BGPROCESS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_SQL Call by reference Type reference (TYPE) STRING 20061127

Method BUILD_STATEMENT_BGPROCESS on class CL_ORA_DBC_SESSION_9 has no exception.

Method BUILD_STATEMENT_GORASESSION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_SQL Call by reference Type reference (TYPE) STRING 20061127

Method BUILD_STATEMENT_GORASESSION on class CL_ORA_DBC_SESSION_9 has no exception.

Method EXECUTE_QUERY_BGPROCESS_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_ORA_GVBGPROCESS_NAME_T Call by reference Type reference (TYPE) GBGPROCESS_NAME_T Table Type for GBGPROCESS_NAME 20061127
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20061127

Method EXECUTE_QUERY_GORASESSION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_ORA_GVORASESSION_T Call by reference Type reference (TYPE) GORASESSION_T Table Type for GORASESSION 20061127
2 Importing I_ORA_GVBGPROCESS_NAME_T Call by reference Type reference (TYPE) GBGPROCESS_NAME_T Table Type for GBGPROCESS_NAME 20061127
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20061127

Method GET_DATA_ORA_SESSION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_ORA_GVORASESSION_T Call by reference Type reference (TYPE) GORASESSION_T Table Type for GORASESSION 20061127
2 Importing I_CON_NAME Call by reference Type reference (TYPE) DBCON_NAME 20061127

Method GET_DATA_ORA_SESSION on class CL_ORA_DBC_SESSION_9 has no exception.

Method GET_ORA_VERSION Signature

Method GET_ORA_VERSION on class CL_ORA_DBC_SESSION_9 has no parameter.
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20061127
History
Last changed by/on SAP  20070911 
SAP Release Created in 710