SAP ABAP Class CL_STUN_ORA_SESSION (Data Collector for SQL Request)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
⤷
STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle⤷
STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DBProperties
| Class | CL_STUN_ORA_SESSION | |
| 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 | STUN_ORA | Objects for Performance Analysis (ST04): Oracle DB |
| Created | 20051129 | SAP |
| Last change | 20130531 | 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) |
Interfaces
Class CL_STUN_ORA_SESSION has no interface implemented.
Friends
Class CL_STUN_ORA_SESSION 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 | 20051129 | ||
| 2 | ORA_VERSION |
Static Attribute | Private | Type reference (TYPE) | STRING | Database Release | 20060419 |
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 | 20051129 |
| 2 | BUILD_STATEMENT_GORASESSION |
Static method | Private | Method | Assemble SQL Statement for GV$SESSION + Other GV$ Tables | 20051129 |
| 3 | EXECUTE_QUERY_BGPROCESS_NAME |
Static method | Private | Method | Create Background Process List | 20051129 |
| 4 | EXECUTE_QUERY_GORASESSION |
Static method | Private | Method | Execute Query for GV$SESSION and Other GV$ Tables | 20051129 |
| 5 | GET_DATA_ORA_SESSION |
Static method | Public | Method | Main Method for Data Extraction from GV$ Tables | 20051129 |
| 6 | GET_ORA_VERSION |
Static method | Private | Method | Determine the ORACLE Version | 20060314 |
Events
Class CL_STUN_ORA_SESSION has no event.
Types
Class CL_STUN_ORA_SESSION 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 | 20051129 |
Method BUILD_STATEMENT_BGPROCESS on class CL_STUN_ORA_SESSION 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 | 20051129 |
Method BUILD_STATEMENT_GORASESSION on class CL_STUN_ORA_SESSION 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 | Tabellentyp zu GBGPROCESS_NAME | 20051129 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_SQL_EXCEPTION |
20060711 |
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 | Tabellentyp für GORASESSION | 20051129 | ||
| 2 |  Importing |
I_ORA_GVBGPROCESS_NAME_T | Call by reference | Type reference (TYPE) | GBGPROCESS_NAME_T | Tabellentyp zu GBGPROCESS_NAME | 20051129 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
20051129 |
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 | Tabellentyp für GORASESSION | 20051129 | ||
| 2 | Importing |
I_CON_NAME | Call by reference | Type reference (TYPE) | DBCON_NAME | 20051129 |
Method GET_DATA_ORA_SESSION on class CL_STUN_ORA_SESSION has no exception.
Method GET_ORA_VERSION Signature
Method GET_ORA_VERSION on class CL_STUN_ORA_SESSION has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
20060711 |
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 710 |
