AIX常用的性能监控命令(转)
机器性能优化主要从四个方面去考虑:CPU,内存,磁盘I/O,网络。1, CPUsar命令可以使用sar命令来查看cpu的使用率。ibm150:[/]#sar 1 5AIX ibm150 ...
分析和压缩索引组织表的空间(from TOM‘s book)
ops$tkyte@ORA10GR1> analyze index iot_pk validate structure;dex analyzed.ops$tkyte@ORA10GR1> select lf_blks, br_blks, used_space,2 opt_cmpr_count, opt_cmpr_pctsave3 from index_stats;LF_BLKS BR_BLKS US...
关于订阅oracle错误消息队列
you use your own tool rather thanEnterprise Manager to display alerts, you must subscribe to the ALERT_QUE, read theALERT_QUE, and display an alert notification after setting the threshold levels for ...