请问informix数据库的繁忙程度怎么检查?

shizier

请问informix数据库的繁忙程度怎么检查?命令是什么?与系统的cpu和内存有多大关系?谢谢.

wtwu

查看数据库当前的会话!!!!!!和数据库服务器CPU和内存的使用情况

shizier

请问查询会话的命令是什么?能否记录历史的?

wtwu

onstat -g act 查看当前活动的会话

shizier

请教楼上,onstat -g act 的结果里各项的含义.谢谢.

liaosnet

onstat -g act        Active Threads
SYNOPSIS
The onstat -g act command displays a list of the currently active (running) threads. The output is sorted by thread ID.

Running threads:
tid     tcb     rstcb   prty    status                  vp-class   name

7       a252d78  0        2     running                   1cpu    sm_poll
8       a267048  0        2     running                   7tli    tlitcppoll

COLUMN DEFINITIONS
Column Heading        Column Description        Format        See Also
tid        The thread id incrementally assigned by OnLine.        Dec        onstat -g ath
tcb        The in-memory address of the thread control block.        Hex       
rstcb        The in-memory address of the RSAM thread control block.        Hex       
prty        The internal priority of the thread.        Dec       
status        The status of the thread.        Str       
vp-class        The class of VP on which the thread is running.        Str        onstat -g sch
name        The name of the thread.        Str       
NOTES
•        There are never more threads running than there are virtual processors (VP).
•        A thread priority can range from 1 (lowest) to 4 (highest) with a default priority of 2.  Priorities are assigned internally by the server and are not tunable.
TUNING & MONITORING
The onstat -g act command is a quick place to identify if certain threads are actually running such as the KAIO thread, the poll and listener threads, and other threads as set in the configuration file.

shizier

谢谢,学习中.