Database Management Technology 
The dbms_server_stats_prim table contains database server level statistics including, semaphore operations, disk and buffered io rates, logging operations, and locking operations. All counters are accumulated over the life of the server. Resource usage statistics represent activity generated by all connected sessions.
| Attribute Name | Key | Datatype | Description |
| server | 1 | varchar(64) | Server name. |
| cpu_time | 0 | integer4 | Accumulated cpu time for server process. |
| active_session | 0 | integer4 | Server session which is currently active. |
| error_code | 0 | integer4 | Code for major error in the server. |
| event_mask | 0 | integer4 | Mask of outstanding event waits. |
| idle_time | 0 | integer4 | Number of queues where task is idle. |
| state_mask | 0 | integer4 | Server state mask 0x001 CS_NOSLICE_MASK, 0x0002 CS_ADD_MASK, 0x0004 CS_SHUTDOWN_MASK, 0x0008 CS_FINALSHUT_MASK, 0x0010 CS_ACCNTING_MASK, 0x0020 CS_CPUSTAT_MASK |
| active_count | 0 | integer4 | Number of server threads currently active. |
| session_count | 0 | integer4 | Number of sessions connected to the server. |
| quantums | 0 | integer4 | Count of quantums passed. |
| ready_mask | 0 | integer4 | Bit mask of the priority ready queue. |
| cs_smms_count | 0 | integer4 | Single processor requests for shared semaphore access. |
| smmsx_count | 0 | integer4 | Multiprocessor collisions on shared vs. exclusive semaphore requests. |
| smmx_count | 0 | integer4 | Multiprocessor requests for exclusive semaphores. |
| smmxx_count | 0 | integer4 | Multiprocessor collisions on exclusive vs. exclusive semaphores. |
| smss_count | 0 | integer4 | Single processor requests for shared semaphores. |
| smssx_count | 0 | integer4 | Single processor collisions on shared vs. exclusive semaphores. |
| smsx_count | 0 | integer4 | Collisions on shared vs. exclusive semaphores. |
| smsxx_count | 0 | integer4 | Single processor collisions on exclusive vs. exclusive semaphores. |
| state | 0 | integer4 | State of server, 0x00 CS_UNINIT, 0x10 CS_INITIALIZING, 0x20 CS_PROCESSING, 0x25 CS_SWITCHING, 0x30 IDLING, 0x40 CS_CLOSING, 0x50 CS_TERMINATING, 0x60 CS_ERROR |
| stk_count | 0 | integer4 | Count of allocated session stacks. |
| stk_list | 0 | integer4 | List of know session stacks. |
| stksize | 0 | integer4 | Size of session stack. |
| svcb | 0 | integer4 | Anchor for underlying code. |
| to_list | 0 | integer4 | List of waiting events with timeouts. |
| toq_cnt | 0 | integer4 | Number of timer queue scans this time. |
| user_sessions | 0 | integer4 | Count of user sessions connected to the server. |
| bio_done | 0 | integer4 | Count of client communication messages processed. |
| bio_idle | 0 | integer4 | Count of client communication messages processed while idle. |
| bio_time | 0 | integer4 | Count or processor ticks while in BIO state. |
| bio_waits | 0 | integer4 | Count of waits on BIO operations. |
| dio_done | 0 | integer4 | Count of disk operations performed by the server process. |
| dio_idle | 0 | integer4 | Count of disk operations performed by server while idle. |
| dio_time | 0 | integer4 | Count of processor ticks while in DIO state. |
| dio_waits | 0 | integer4 | Count of waits on DIO operations. |
| lg_done | 0 | integer4 | Count of log operations performed by the server. |
| lg_idle | 0 | integer4 | Count of log operations performed while server is idle. |
| lg_time | 0 | integer4 | Count of processor ticks while server is performing logging operations. |
| lg_waits | 0 | integer4 | Count of waits on log operations. |
| lk_done | 0 | integer4 | Count of lock operations performed by the server. |
| lk_idle | 0 | integer4 | Count of lock operations performed while server is idle. |
| lk_time | 0 | integer4 | Count of processor ticks while server is performing locking operations. |
| lk_waits | 0 | integer4 | Count of waits on locking operations. |
| tm_done | 0 | integer4 | Count of timer operations performed by the server. |
| tm_idle | 0 | integer4 | Count of timer operations performed by server while idle. |
| tm_time | 0 | integer4 | Count of processor ticks while performing timer operations. |
| tm_waits | 0 | integer4 | Count of waits on timer operations. |
| wt_list | 0 | integer4 | List of sessions waiting for an event. |
