SAP ABAP Table ORA_S_GV_ACTIVE_SESSION_HIS (Oracle View: gv$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
Basic Data
Table Category | INTTAB | Structure |
Structure | ORA_S_GV_ACTIVE_SESSION_HIS | Table Relationship Diagram |
Short Description | Oracle View: gv$active_session_history |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | INST_ID | ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
2 | SAMPLE_ID | ORA_SAMPLE_ID | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: Sample ID (ID of sample data) | ||
3 | SAMPLE_TIME | ORA_SAMPLE_TIME | CHAR | 25 | 0 | Oracle monitoring: Sample timestamp | |||
4 | SESSION_ID | ORA_SESSION_ID | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: Session ID | ||
5 | SESSION_SERIAL | ORA_SERIAL | ORA_SERIAL | DEC | 22 | 0 | Oracle monitoring: SERIAL#: Session serial number | ||
6 | USER_ID | ORA_USER | ORA_USER | DEC | 22 | 0 | Oracle monitoring: USER#: Oracle user identifier | ||
7 | SQL_ID | ORA_SQL_ID | ORA_SQLID | CHAR | 13 | 0 | Oracle monitoring: SQL_ID | ||
8 | SQL_STATEMENT | ORA_SQLSTRING | ORA_SQLSTRING | CHAR | 64 | 0 | Oracle Monitoring: SQLSTRING | ||
9 | SQL_CHILD_NUMBER | ORA_SQLCHILDNUM | INT4 | 10 | 0 | Oracle monitoring: SQL child number | |||
10 | SQL_PLAN_HASH_VALUE | ORA_SQL_HASH_VALUE | ORA_SQL_HASH_VALUE | DEC | 22 | 0 | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | ||
11 | SQL_OPCODE | ORA_OPCODE | INT4 | 10 | 0 | Oracle Monitoring: Oracle OPCODE | |||
12 | SQL_OPNAME | ORA_OPNAME | CHAR | 64 | 0 | SQL command name | |||
13 | SQL_PLAN_LINE_ID | ORA_SQL_PLAN_LINE_ID | DEC | 22 | 0 | SQL plan line ID | |||
14 | SQL_PLAN_OPERATION | ORA_SQL_PLAN_OPERATION | CHAR | 30 | 0 | Plan operation name | |||
15 | SQL_PLAN_OPTIONS | ORA_SQL_PLAN_OPTIONS | CHAR | 30 | 0 | Plan operation options | |||
16 | SQL_EXEC_ID | ORA_SQL_EXEC_ID | DEC | 22 | 0 | SQL execution identifier | |||
17 | SQL_EXEC_START | ORA_SQL_EXEC_START | CHAR | 30 | 0 | Time when the execution of the SQL started | |||
18 | SERVICE_HASH | ORA_SERVICE_HASH | ORA_DEC_22 | DEC | 22 | 0 | Oracle Monitoring: Oracle Service Hash | ||
19 | SESSION_TYPE | ORA_SESSION_TYPE | CHAR | 10 | 0 | Oracle Monitoring: Oracle Session Type | |||
20 | SESSION_STATE | ORA_SESSION_STATE | CHAR | 7 | 0 | Oracle Monitoring: Oracle Session State | |||
21 | TOP_LEVEL_SQL_ID | ORA_TOP_LEVEL_SQL_ID | CHAR | 13 | 0 | SQL identifier of the top level SQL statement | |||
22 | TOP_LEVEL_SQL_OPCODE | ORA_TOP_LEVEL_SQL_OPCODE | DEC | 22 | 0 | Indicates what phase of operation the top level SQL stmt | |||
23 | QC_SESSION_ID | ORA_QC_SESSION_ID | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: Query Coordinator Session ID | ||
24 | QC_INSTANCE_ID | ORA_QC_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitoring: Query Coordinator Instance ID | ||
25 | BLOCKING_INST_ID | ORA_BLOCKING_INST_ID | DEC | 22 | 0 | Instance number of the blocker shown in BLOCKING_SESSION | |||
26 | BLOCKING_SESS_ID | ORA_BLOCKING_SESS_ID | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: Blocking session ID | ||
27 | BLOCKING_SESS_STATUS | ORA_BLOCKING_SESS_STATUS | CHAR | 11 | 0 | Oracle Monitoring: Blocking Session Status | |||
28 | BLOCKING_SESS_SERIAL | ORA_BLOCKING_SESS_SERIAL | ORA_SERIAL | DEC | 22 | 0 | Oracle monitoring: Blocking session serial number | ||
29 | EVENT | ORA_EVENT_NAME | CHAR | 64 | 0 | Oracle Monitoring: Oracle Event Name | |||
30 | EVENT_ID | ORA_EVENT_ID | CHAR | 38 | 0 | Oracle Monitoring: Oracle Event ID | |||
31 | EVENT_NUM | ORA_EVENT_NUMBER | INT4 | 10 | 0 | Oracle Monitoring: Oracle Event Number | |||
32 | SEQ_NUM | ORA_SEQ | ORA_SEQ | DEC | 22 | 0 | Oracle monitoring: SEQ# | ||
33 | P1 | ORA_P1 | ORA_P1 | DEC | 22 | 0 | Oracle monitoring: ORA_P1: First additional parameter | ||
34 | P2 | ORA_P2 | ORA_P2 | DEC | 22 | 0 | Oracle monitoring: ORA_P2: Second additional parameter | ||
35 | P3 | ORA_P3 | ORA_P3 | DEC | 22 | 0 | Oracle monitoring: ORA_P3: Third additional parameter | ||
36 | WAIT_CLASS | ORA_CLASS_NAME | CHAR64 | CHAR | 64 | 0 | ORA: Wait Class Name | ||
37 | WAIT_CLASS_ID | ORA_CLASS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: CLASS | ||
38 | WAIT_TIME | ORA_WAIT_TIME | ORA_WAIT_TIME | DEC | 22 | 0 | Oracle monitoring: Latch Wait Time | ||
39 | TIME_WAITED | ORA_TIME_WAITED | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: TIME_WAITED | ||
40 | CURRENT_OBJ | ORA_OBJECT_ID_2 | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Dictionary object number of the object | ||
41 | OBJECT_NAME | ORA_OBJECT_NAME | ORA_CHAR_30 | CHAR | 30 | 0 | Oracle monitoring: Name of the object | ||
42 | CURRENT_FILE | ORA_FILE | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: File# | ||
43 | CURRENT_BLOCK | ORA_BLOCK_ID | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Block number | ||
44 | CURRENT_ROW | ORA_CURRENT_ROW | DEC | 22 | 0 | Row identifier that the session is referencing | |||
45 | IN_CONNECTION_MGMT | ORA_IN_CONNECTION_MGMT | CHAR | 1 | 0 | Indicates whether the session was doing connection mngmt | |||
46 | IN_PARSE | ORA_IN_PARSE | CHAR | 1 | 0 | Indicates whether the session was parsing | |||
47 | IN_HARD_PARSE | ORA_IN_HARD_PARSE | CHAR | 1 | 0 | Indicates whether the session was hard parsing | |||
48 | IN_SQL_EXECUTION | ORA_IN_SQL_EXECUTION | CHAR | 1 | 0 | Indicates whether the session was executing SQL stmt | |||
49 | IN_PLSQL_EXECUTION | ORA_IN_PLSQL_EXECUTION | CHAR | 1 | 0 | Indicates whether the session was executing PL/SQL | |||
50 | IN_PLSQL_RPC | ORA_IN_PLSQL_RPC | CHAR | 1 | 0 | Indicates whether session was executing inbound PL/SQL RPC | |||
51 | IN_PLSQL_COMPILATION | ORA_IN_PLSQL_COMPILATION | CHAR | 1 | 0 | Indicates whether the session was compiling PL/SQL | |||
52 | IN_JAVA_EXECUTION | ORA_IN_JAVA_EXECUTION | CHAR | 1 | 0 | Indicates whether the session was executing Java | |||
53 | IN_BIND | ORA_IN_BIND | CHAR | 1 | 0 | Indicates whether the session was doing bind operations | |||
54 | IN_CURSOR_CLOSE | ORA_IN_CURSOR_CLOSE | CHAR | 1 | 0 | Indicates whether the session was closing a cursor | |||
55 | IN_SEQUENCE_LOAD | ORA_IN_SEQUENCE_LOAD | CHAR | 1 | 0 | Indicates whether the session is loading in sequence | |||
56 | TM_DELTA_TIME | ORA_TM_DELTA_TIME | DEC | 22 | 0 | Time interval (in microseconds) | |||
57 | TM_DELTA_CPU_TIME | ORA_TM_DELTA_CPU_TIME | DEC | 22 | 0 | Amount of time this session spent on CPU | |||
58 | TM_DELTA_DB_TIME | ORA_TM_DELTA_DB_TIME | DEC | 22 | 0 | Amount of time spent by this session in database calls | |||
59 | DELTA_TIME | ORA_DELTA_TIME | DEC | 22 | 0 | Time interval since session was sampled (microsec) | |||
60 | DELTA_READ_IO_REQUESTS | ORA_DELTA_READ_IO_REQUESTS | DEC | 22 | 0 | Number of read I/O requests made by this session | |||
61 | DELTA_WRITE_IO_REQUESTS | ORA_DELTA_WRITE_IO_REQUESTS | DEC | 22 | 0 | Number of write I/O requests made by this session | |||
62 | DELTA_READ_IO_BYTES | ORA_DELTA_READ_IO_BYTES | DEC | 22 | 0 | Number of I/O bytes read by this session | |||
63 | DELTA_WRITE_IO_BYTES | ORA_DELTA_WRITE_IO_BYTES | DEC | 22 | 0 | Number of I/O bytes written by this session | |||
64 | DELTA_INTERCONNECT_IO_BYTES | ORA_DELTA_INTERCONNECT_IO_BYTE | DEC | 22 | 0 | Number of I/O bytes sent over the I/O interconnect | |||
65 | PGA_ALLOCATED | ORA_PGA_ALLOCATED | DEC | 22 | 0 | Amount of PGA memory (in bytes) consumed by this session | |||
66 | TEMP_SPACE_ALLOCATED | ORA_TEMP_SPACE_ALLOCATED | DEC | 22 | 0 | Amount of TEMP memory (in bytes) consumed by this session | |||
67 | MACHINE | ORA_MACHINE | ORA_MACHINE | CHAR | 64 | 0 | Oracle monitoring: MACHINE: Operating system machine name | ||
68 | PORT | ORA_PORT | DEC | 22 | 0 | Client port number | |||
69 | PROGRAMX | ORA_PROGRAM | ORA_PROGRAM | CHAR | 48 | 0 | Oracle monitoring: PROGRAM: Operating system program name | ||
70 | MODULEX | ORA_MODULE | ORA_MODULE | CHAR | 48 | 0 | Oracle monitoring: MODULE: currently executing module | ||
71 | ACTION | ORA_ACTION | ORA_ACTION | CHAR | 32 | 0 | Oracle monitoring: ACTION: Currently executing action | ||
72 | CLIENT_ID | ORA_CLIENT_IDENTIFIER | ORA_CLIENT_IDENTIFIER | CHAR | 64 | 0 | Oracle monitoring: ORA_CLIENT_IDENTIFIER | ||
73 | SAMPLE_TIME_EXT | ORA_SAMPLE_TIME | CHAR | 25 | 0 | Oracle monitoring: Sample timestamp |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 710 |