Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

session_os_stats

The session_os_stats table contains database server session resource usage statistics.  One row is returned for each session connected to each server in the current IMA management domain.  Delta columns represent changes in counter values since the last interval.

 
Attribute Name Key Datatype Description
timestamp 0 date Date and time the data was collected
delta_seconds 0 integer4 Elapsed time (seconds) since the previous refresh.
server 1 varchar(64) Database server name.
session_index 0 varchar(16) Internal index for the current session.
session_id 2 varchar(16) Internal session identifier.
scb_owner 0 integer4 Internal identifier for session block owner.
pid 0 integer4 Process id of the database server.
ppid 0 integer4
session_type_s 0 varchar(32) Session type for the current session.
session_type 0 integer4 Numeric session type for the current session.
comm_ios 0 integer4 Count of messages exchanged between the client and the associated server session.
comm_ios_d 0 integer4 Count of messages exchanged between the client and the associated server session in the last interval.
client_type 0 integer4 Client type associated with the current session.
condition 0 integer4 Current session condition.
connect_time 0 integer4 Timestamp when the connection was established.
cpu_used 0 integer4 Cpu time consumed by the session in 10 millisecond ticks, divide by 100 to get cpu seconds.
cpu_used_d 0 integer4 Cpu time consumed by the session in 10 millisecond ticks in the last interval, divide by 100 to get cpu seconds.
disk_ios 0 integer4 Count of physical disk I/O operations initiated by the current session.
disk_ios_d 0 integer4 Count of physical disk I/O operations initiated by the current session in the last interval.
kernel_cpu_used 0 integer4 Kernel mode cpu ticks consumed by the current session.
kernel_cpu_used_d 0 integer4 Kernel mode cpu ticks consumed by the current session in the last interval.
lock_count 0 integer4 Count of locks currently held by the session.
lock_count_d 0 integer4 Number of locks acquired in the last interval
session_mask_s 0 varchar(64) Session mask for the current session.
stack_size 0 integer4 Execution stack size for the current session.
current_mode 0 integer4 Current session mode.
next_mode 0 integer4 Next session mode.
session_state_s 0 varchar(64) Current session state.
session_state 0 integer4 Current numeric session state.
username 0 varchar(64) Real user name of the client associated with the current session.
session_mask 0 integer4 Numeric mask for the current session.
wait_reason 0 varchar(16) If the session is in a wait state this is the wait reason.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.