請問informix數(shù)據(jù)庫的繁忙程度怎么檢查?

shizier

請問informix數(shù)據(jù)庫的繁忙程度怎么檢查?命令是什么?與系統(tǒng)的cpu和內(nèi)存有多大關(guān)系?謝謝.

wtwu

查看數(shù)據(jù)庫當前的會話!!!!!!和數(shù)據(jù)庫服務(wù)器CPU和內(nèi)存的使用情況

shizier

請問查詢會話的命令是什么?能否記錄歷史的?

wtwu

onstat -g act 查看當前活動的會話

shizier

請教樓上,onstat -g act 的結(jié)果里各項的含義.謝謝.

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

謝謝,學習中.