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
⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Properties
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 |