Chinaunix

标题: 请问informix数据库的繁忙程度怎么检查? [打印本页]

作者: shizier 时间: 2007-10-12 14:07
标题: 请问informix数据库的繁忙程度怎么检查?
请问informix数据库的繁忙程度怎么检查?命令是什么?与系统的cpu和内存有多大关系?谢谢.

作者: wtwu 时间: 2007-10-13 21:50
查看数据库当前的会话!!!!!!和数据库服务器CPU和内存的使用情况

作者: shizier 时间: 2007-10-16 10:23
请问查询会话的命令是什么?能否记录历史的?

作者: wtwu 时间: 2007-10-16 15:54
onstat -g act 查看当前活动的会话

作者: shizier 时间: 2007-10-16 16:20
请教楼上,onstat -g act 的结果里各项的含义.谢谢.

作者: liaosnet 时间: 2007-10-16 17:23
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 时间: 2007-10-17 17:19
谢谢,学习中.

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)