| onstat [ -abcdfghklmpstuxzBCDFRX ] [ -i ] [ -r [<seconds>] ] [ -o [<outfile>] ] [ <infile> ] | |
| -a | 显示所有信息 |
| -b | 显示缓冲区 |
| -c | 显示配置文件 |
| -d [update] | |
| 显示空间和区块（chunks） | |
| 要求服务器更新Blob对象区块统计 | |
| -f | 显示“dataskip”状态 |
| -g | 执行MT命令（MT命令见后） |
| -i | 进入交互模式 |
| -h | 显示缓冲区Hash链信息 |
| -j | 显示活跃的onpload过程的交互式状况 |
| -k | 显示锁 |
| -l | 显示日志信息（逻辑日志和物理日志，包括页地址） |
| -m | 显示OnLine系统消息日志的最后20行内容 |
| -p | 显示profile |
| -s | 显示latches |
| -t | 显示TBL空间 |
| -u | 显示用户线程 |
| 其中：flages字段的含义: 第一列：（S：等待mutex；Y：等待条件；L：等待锁；B：等待缓冲区；C：等待检查点；X：长事务清理；G：等待长缓冲写；T：等待事务） 第二列：（*：事务执行时，发生I/O错误） 第三列：（A：正在备份；B：操作已被记录在日志中；P：分布处理已准备好；C：正在提交；R：正在回滚） 第四列：（P：会话的主线索） 第五列：（R：在readrsam调用中；X：进程在关键分区） 第七列：（M：特殊监控；D：特殊线索；C：清理线索；F：特殊清页进程；B：特殊B+树清页线索） | |
| -x | 显示事务 |
| -z | profile统计清零 |
| -B | 显示所有缓冲区信息 |
| -C | 显示btree cleaner请求 |
| -D | 显示区块（chunk）空间和详细信息 |
| -F | 显示page flusher |
| -G | 显示全局事务（transaction）ID |
| -P | 显示分区缓冲区汇总 |
| -R | 显示LRU队列 |
| -T | 显示表空间信息 |
| -X | 显示所有分享和等待缓冲区信息 |
| -r | 周期性运行当前命令（单位为秒，默认为5） |
| -o | 将共享内在写入指定文件（默认为onstat.out） |
| MT COMMANDS: | |
| all | 显示所有MT信息 |
| ath | 显示所有线程 |
| wai | 显示等待线程 |
| act | 显示活跃线程 |
| rea | 显示准备线程 |
| sle | 显示所有睡眠线程 |
| spi | 显示自旋锁 |
| sch | 显示VP调度统计 |
| lmx | 显示所有锁定的mutexes |
| lsc | 显示轻度扫描信息 |
| wmx | 显示所有等待的mutexes |
| con | Print conditions with waiters |
| stk <tid> | |
| 转储指定线程的栈 | |
| glo | 显示MT全局信息 |
| mem [<pool name>|<session id>] | |
| 显示池（pool）统计数据 | |
| seg | 显示内存段统计数据 |
| rbm | Print block map for resident segment |
| nbm | Print block map for non-resident segments |
| afr <pool name|session id> | |
| Print allocated pool fragments | |
| ffr <pool name|session id> | |
| Print free pool fragments | |
| ufr <pool name|session id> | |
| Print pool usage breakdown | |
| iov | Print disk IO statistics by vp |
| iof | Print disk IO statistics by chunk/file |
| iog | Print AIO global information |
| iob | Print big buffer usage by IO VP class |
| ppf [<partition number> | 0] | |
| Print partition profiles | |
| tpf [<tid> | 0] | |
| Print thread profiles | |
| ntu | Print net user thread profile information |
| ntt | Print net user thread access times |
| ntm | Print net message information |
| ntd | Print net dispatch information |
| nss [<session id>] | |
| Print net shared memory status | |
| nsc [<client id>] | |
| Print net shared memory status | |
| nsd | Print net shared memory data |
| sts | Print max and current stack sizes |
| dic | Print dictionary cache information |
| opn [<tid>] | |
| Print open tables | |
| qst | Print queue statistics |
| wst | Print thread wait statistics |
| rwm | print Read/Write Mutex lists |
| ses [<session id>] | |
| Print session information | |
| sql [<session id>] | |
| Print SQL information | |
| stq [<session id>] | |
| Print stream queue information | |
| smb | Print smart-large-object usage |
| dri | Print data replication information |
| pos | Print /INFORMIXDIR/etc/.infos.DBSERVERNAME file |
| mgm | Print Memory Grant Manager information |
| lap | Print light append information |
| ddr | Print DDR log post processing information |
| env [ all | [<session-id>] ] [<variable-name>[,<variable-name>...]] | |
| Display environment variable settings. | |
| dmp <address> <length> | |
| Dump <length> bytes of shared memory starting at <address> | |
| src <pattern> <mask> | |
| Search memory for <pattern>, where <pattern>==(memory&<mask>) | |
| dll | Print dynamic library statistics |
| ssc [pool|all] | |
| Prints ssc pool summary, or statement cache summary and | |
| entries, including key only entries (all) | |
| stm [<sesson id>] | |
| Prints all prepared statements approximate memory usage in a session | |
| buf | Print profile information related to buffer pools. |
