SAP ABAP Class CL_ORA_INFOSRV_ACTSESSHIST (Infoservice Service: Active Session History)
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
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 FrameworkProperties
| Class | CL_ORA_INFOSRV_ACTSESSHIST | |
| Short Description | Infoservice Service: Active Session History | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | S_DBMON_ORA_COCKPIT | Database Monitor for Oracle in Cockpit Framework |
| Created | 20050908 | SAP |
| Last change | 20070911 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_ORA_INFOSRV_ACTSESSHIST has no forward declaration.
Interfaces
Class CL_ORA_INFOSRV_ACTSESSHIST has no interface implemented.
Friends
Class CL_ORA_INFOSRV_ACTSESSHIST has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | GC_DATASOURCE_DBA |
Constant | Private | Type reference (TYPE) | ORA_ASH_DATASOURCE | '2' | Datasource dba view | 20051006 | |
| 2 | GC_DATASOURCE_GV |
Constant | Private | Type reference (TYPE) | ORA_ASH_DATASOURCE | '1' | Datasource gv$view | 20051006 | |
| 3 | GC_KEYFIGURE_ACTSESS |
Constant | Private | Type reference (TYPE) | ORA_ASH_KEYFIGURE | '1' | Key figure "active sessions" | 20051006 | |
| 4 | GC_KEYFIGURE_TIMWT |
Constant | Private | Type reference (TYPE) | ORA_ASH_KEYFIGURE | '2' | Key figure "time waited" | 20051006 | |
| 5 | GC_SERIESTYPE_WECLASS |
Constant | Private | Type reference (TYPE) | ORA_ASH_SERIESTYPE | '1' | Series type "wait event classes" | 20051006 | |
| 6 | GC_SERIESTYPE_WEVENT |
Constant | Private | Type reference (TYPE) | ORA_ASH_SERIESTYPE | '2' | Series type "wait events" | 20051006 | |
| 7 | GC_TIMEINTERVAL_10MIN |
Constant | Private | Type reference (TYPE) | ORA_ASH_TIMEINTERVAL | '5' | Time interval 10 minutes | 20051006 | |
| 8 | GC_TIMEINTERVAL_10SEC |
Constant | Private | Type reference (TYPE) | ORA_ASH_TIMEINTERVAL | '3' | Time interval 10 sec. | 20051006 | |
| 9 | GC_TIMEINTERVAL_MILLI |
Constant | Private | Type reference (TYPE) | ORA_ASH_TIMEINTERVAL | '1' | Time interval 1 millisec. | 20051006 | |
| 10 | GC_TIMEINTERVAL_MIN |
Constant | Private | Type reference (TYPE) | ORA_ASH_TIMEINTERVAL | '4' | Time interval 1 minute | 20051006 | |
| 11 | GC_TIMEINTERVAL_SEC |
Constant | Private | Type reference (TYPE) | ORA_ASH_TIMEINTERVAL | '2' | Time interval 1 sec | 20051006 | |
| 12 | GT_ACT_SESS_HIST |
Instance attribute | Private | Type reference (TYPE) | ORA_T_GV_ACTIVE_SESSION_HIS | table with ORA_S_GV_ACTIVE_SESSION_HIS data | 20050908 | ||
| 13 | GT_EVENT_NAME |
Instance attribute | Private | Type reference (TYPE) | ORA_T_V_EVENT_NAME | table with ORA_S_GV_EVENT_NAME data | 20050908 | ||
| 14 | G_DBREL |
Instance attribute | Private | Type reference (TYPE) | STRING | Oracle DB release as string | 20060308 | ||
| 15 | G_REMOTE_SYSTEM |
Instance attribute | Private | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20051125 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CONSTRUCTOR |
Instance method | Public | Constructor | constructor | 20050908 |
| 2 | GET_ACTIVE_SESSIONS_PER_INTERV |
Instance method | Public | Method | get active sessions per time interval | 20051006 |
| 3 | GET_ALL_WAIT_EVENTS |
Instance method | Public | Method | get all wait events | 20051004 |
| 4 | GET_ALL_WAIT_EVENT_CLASSES |
Instance method | Public | Method | get all wait event classes | 20051004 |
| 5 | GET_ENTIRE_SESSION_HIST |
Instance method | Public | Method | get entire session history table | 20050908 |
| 6 | GET_FILE_BLOCKNUMS |
Instance method | Public | Method | Get list of accessed blocks for a given file+time+selection | 20060217 |
| 7 | GET_FILE_STATS |
Instance method | Public | Method | Get the file stats | 20051114 |
| 8 | GET_SQL_INFO |
Instance method | Public | Method | Get info from GV$SQL | 20051117 |
| 9 | GET_SQL_TIMESTAMPS |
Instance method | Public | Method | Get list of timestamps for a given SQLstmt+time+selection | 20060217 |
| 10 | GET_TIME_WAITED_PER_INTERV |
Instance method | Public | Method | get time waited per interval | 20051006 |
| 11 | GET_WAIT_EVENTS |
Instance method | Public | Method | Get the Wait Event details | 20051117 |
| 12 | GET_Y_VALUE_PER_INTERV |
Instance method | Public | Method | get key figure (y value) per time interval | 20051010 |
Events
Class CL_ORA_INFOSRV_ACTSESSHIST has no event.
Types
Class CL_ORA_INFOSRV_ACTSESSHIST has no local type.
Method Signatures
Method CONSTRUCTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_DATASOURCE | Call by reference | Type reference (TYPE) | ORA_ASH_DATASOURCE | Datasource for active session history graphic | 20051025 | ||
| 2 | Importing |
I_DBREL | Call by reference | Type reference (TYPE) | STRING | Oracle DB release as string | 20060308 | ||
| 3 | Importing |
I_FROM_TIMESTAMP | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Relevant timestamp interval (from-value) | 20051024 | ||
| 4 | Importing |
I_REMOTE_SYSTEM | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20050908 | ||
| 5 | Importing |
I_TO_TIMESTAMP | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Relevant timestamp interval (to-value) | 20051024 |
Method CONSTRUCTOR on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_ACTIVE_SESSIONS_PER_INTERV Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_SELECTION | Call by reference | Type reference (TYPE) | ORA_S_ASH_SELECTION | Structure with selection information | 20051028 | ||
| 2 |  Returning |
RT_ASH_GDATA | Value transfer | Type reference (TYPE) | ORA_T_ASH_GRAPHDATA | Acquired ASH graphic data | 20051007 |
Method GET_ACTIVE_SESSIONS_PER_INTERV on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_ALL_WAIT_EVENTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
ET_WAIT_EVENTS | Value transfer | Type reference (TYPE) | ORA_T_WAITEVENT | Oracle wait events | 20051004 |
Method GET_ALL_WAIT_EVENTS on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_ALL_WAIT_EVENT_CLASSES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
ET_WAIT_EVENT_CLASSES | Value transfer | Type reference (TYPE) | ORA_T_WAITEVCLASS | Oracle wait event classes | 20051004 |
Method GET_ALL_WAIT_EVENT_CLASSES on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_ENTIRE_SESSION_HIST Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
ET_ACT_SESS_HIST | Value transfer | Type reference (TYPE) | ORA_T_GV_ACTIVE_SESSION_HIS | Table ORA_S_GV_ACTIVE_SESSION_HIS | 20050908 | ||
| 2 | Importing |
I_INST_ID | Call by reference | Type reference (TYPE) | ORA_INST_ID | Oracle monitor: Instance ID | 20050908 |
Method GET_ENTIRE_SESSION_HIST on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_FILE_BLOCKNUMS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
ET_BLOCKS | Call by reference | Type reference (TYPE) | ORA_T_ASH_BLOCKLIST | List of accesses blocks | 20060217 | ||
| 2 | Importing |
I_EVENT_NAME | Call by reference | Type reference (TYPE) | ORA_EVENT_NAME | Oracle Event Name or Event Class | 20060217 | ||
| 3 | Importing |
I_EVENT_TYPE | Call by reference | Type reference (TYPE) | ORA_EVENT_TYPE | Oracle Event Type 1=Event Class 2=Event Name | 20060217 | ||
| 4 | Importing |
I_FILE_HASH | Call by reference | Type reference (TYPE) | ORA_FILE | File# | 20060217 | ||
| 5 | Importing |
I_TIMESTAMP_FROM | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Sample timestamp "from" | 20060217 | ||
| 6 | Importing |
I_TIMESTAMP_TO | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Sample timestamp "to" | 20060217 |
Method GET_FILE_BLOCKNUMS on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_FILE_STATS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_FILE_INFO | Value transfer | Type reference (TYPE) | ORA_T_FILE_INFO | Table type for ORA_S_FILE_INFO | 20051114 | ||
| 2 | Importing |
I_EVENT_NAME | Value transfer | Type reference (TYPE) | ORA_EVENT_NAME | Oracle Monitoring: Oracle Event Name | 20051114 | ||
| 3 | Importing |
I_EVENT_TYPE | Value transfer | Type reference (TYPE) | ORA_EVENT_TYPE | Oracle Event Type 1=Event Class 2=Event Name | 20051114 | ||
| 4 | Importing |
I_TIMESTAMP_FROM | Value transfer | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20051125 | ||
| 5 | Importing |
I_TIMESTAMP_TO | Value transfer | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20051125 |
Method GET_FILE_STATS on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_SQL_INFO Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_SQL_INFO | Value transfer | Type reference (TYPE) | ORA_T_SQL_INFO | Table type of ORA_S_SQL_INFO | 20051117 | ||
| 2 | Importing |
I_EVENT_NAME | Value transfer | Type reference (TYPE) | ORA_EVENT_NAME | Oracle Monitoring: Oracle Event Name | 20051117 | ||
| 3 | Importing |
I_EVENT_TYPE | Value transfer | Type reference (TYPE) | ORA_EVENT_TYPE | Oracle Event Type 1=Event Class 2=Event Name | 20051117 | ||
| 4 | Importing |
I_TIMESTAMP_FROM | Value transfer | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20051125 | ||
| 5 | Importing |
I_TIMESTAMP_TO | Value transfer | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20051125 |
Method GET_SQL_INFO on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_SQL_TIMESTAMPS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_TIMESTAMPS | Call by reference | Type reference (TYPE) | ORA_T_ASH_SQLTSTAMP | List of timestamps (ASH monitor) | 20060217 | ||
| 2 | Importing |
I_EVENT_NAME | Call by reference | Type reference (TYPE) | ORA_EVENT_NAME | Oracle Event Name or Event Class | 20060217 | ||
| 3 | Importing |
I_EVENT_TYPE | Call by reference | Type reference (TYPE) | ORA_EVENT_TYPE | Oracle Event Type 1=Event Class 2=Event Name | 20060217 | ||
| 4 | Importing |
I_SQL_ID | Call by reference | Type reference (TYPE) | ORA_SQL_ID | SQL ID | 20060217 | ||
| 5 | Importing |
I_TIMESTAMP_FROM | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Sample timestamp "from" | 20060217 | ||
| 6 | Importing |
I_TIMESTAMP_TO | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Sample timestamp "to" | 20060217 |
Method GET_SQL_TIMESTAMPS on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_TIME_WAITED_PER_INTERV Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_SELECTION | Call by reference | Type reference (TYPE) | ORA_S_ASH_SELECTION | structure with selection information | 20051028 | ||
| 2 | Returning |
RT_ASH_GDATA | Value transfer | Type reference (TYPE) | ORA_T_ASH_GRAPHDATA | Acquired ASH graphic data | 20051007 |
Method GET_TIME_WAITED_PER_INTERV on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_WAIT_EVENTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_EVENT_INFO | Call by reference | Type reference (TYPE) | ORA_T_EVENT_INFO | Table type for ORA_S_EVENT_INFO | 20051117 | ||
| 2 | Importing |
I_EVENT_NAME | Call by reference | Type reference (TYPE) | ORA_EVENT_NAME | Oracle Monitoring: Oracle Event Name | 20051117 | ||
| 3 | Importing |
I_EVENT_TYPE | Call by reference | Type reference (TYPE) | ORA_EVENT_TYPE | Oracle Event Type 1=Event Class 2=Event Name | 20051117 | ||
| 4 | Importing |
I_TIMESTAMP_FROM | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20051124 | ||
| 5 | Importing |
I_TIMESTAMP_TO | Call by reference | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20051124 |
Method GET_WAIT_EVENTS on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
Method GET_Y_VALUE_PER_INTERV Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_SEL | Call by reference | Type reference (TYPE) | ORA_S_ASH_SELECTION | Structure with selection information | 20051028 | ||
| 2 | Returning |
RT_ASH_GDATA | Value transfer | Type reference (TYPE) | ORA_T_ASH_GRAPHDATA | Acquired ASH graphic data | 20051010 |
Method GET_Y_VALUE_PER_INTERV on class CL_ORA_INFOSRV_ACTSESSHIST has no exception.
History
| Last changed by/on | SAP | 20070911 |
| SAP Release Created in | 710 |
