Our super-slow speed database literacy, help us! Thank you Our database literacy super slow speed, we use the AIX server plus ORACLE817! The recent data on the reaction time obtuse! Generally will have to get any information out on March 5 minutes, or else a state of ruin! Old or up the database several times, there is a lot of space! XDJM you get help! Very urgent! Our super-slow speed database literacy, help us! Thank you Data slow response time? Made inquiries? Zhang table is a slow time or slow? Index did not play a role? Our super-slow speed database literacy, help us! Thank you If this issue is the recent sudden emergence of IO should consider whether there are problems, for example, on a HD RAID problems. Our super-slow speed database literacy, help us! Thank you Be statspack first. . Our super-slow speed database literacy, help us! Thank you I made inquiries at the time, and included some data, the data will not respond to half a day! This is a very recent development! Has not understand! Our super-slow speed database literacy, help us! Thank you 1. Look at the system log. 2. # Vmstat 2 100 Our super-slow speed database literacy, help us! Thank you Dean said the check doni Our super-slow speed database literacy, help us! Thank you Lovetjl Brother, how to check IO ah? Please advise! Our super-slow speed database literacy, help us! Thank you --> Kthr memory page faults cpu ----- ----------- ------------------------ ------------ ----------- R b avm fre Ampere pi po us subresonance sr cy in patch cs patch id wa 2 2 148794 189 0 0 0 0 0 0 131 1091 402 51 49 0 0 2 2 148780 159 0 18 0 0 0 0 177 973 423 56 44 0 0 2 2 148780 159 0 0 0 0 0 0 144 997 606 51 49 0 0 2 2 148794 145 0 0 0 0 0 0 147 1013 316 45 55 0 0 1 2 148808 149 0 0 0 9 40 0 129 275 58 14 86 0 0 2 2 148794 163 0 0 0 0 0 0 127 230 54 12 88 0 0 1 2 148794 172 0 0 0 4 42 0 136 304 55 13 87 0 0 1 2 148794 172 0 0 0 0 0 0 155 283 70 12 88 0 0 1 2 148794 172 0 0 0 0 0 0 154 272 61 14 86 0 0 2 2 148780 186 0 0 0 0 0 0 141 861 92 64 36 0 0 2 2 148815 151 0 0 0 0 0 0 131 889 144 51 49 0 0 2 2 148822 144 0 0 0 0 0 0 129 784 140 50 50 0 0 2 2 148808 158 0 0 0 0 0 0 131 845 142 53 47 0 0 2 2 148794 172 0 0 0 0 0 0 155 732 141 52 48 0 0 1 2 148780 186 0 0 0 0 0 0 139 234 63 10 90 0 0 1 2 148780 186 0 0 0 0 0 0 138 273 58 10 90 0 0 1 2 148808 158 0 0 0 0 0 0 128 278 56 10 90 0 0 1 2 148780 186 0 0 0 0 0 0 130 275 62 10 90 0 0 1 2 148787 179 0 0 0 0 0 0 130 276 53 8 92 0 0 1 2 148780 186 0 0 0 0 0 0 152 283 67 11 89 0 0 See no problem! Our super-slow speed database literacy, help us! Thank you Lovetjl Brother, how to check IO ah? Please enlighten I really understand! Our super-slow speed database literacy, help us! Thank you Kthr memory page faults cpu ----- ----------- ------------------------ ------------ ----------- Rb avm fre Ampere pi po us subresonance sr cy in patch cs patch id wa 2 2 148794 189 0 0 0 0 0 0 131 1091 402 51 49 0 0 2 2 148780 159 0 18 0 0 0 0 177 973 423 56 44 0 0 Note : The id continued to cpu 0, no free cpu, memory of the fre 170%, too small, the problem is serious. The po page normal. You do testing : #iostat # Topas # Cesar Os is the memory? Os is a swap? Oracle is the SGA? Os enough space for the file system? There are no spare space in the Oracle table? Oracle os and also look at the log (including error log), the positioning of the fastest. Recommendations read : "AIX resource monitoring tools and modulation" Address : http://www.www.lslnet.com/linux/jh/9/25840.html Our super-slow speed database literacy, help us! Thank you --> Master:/ #iostat Tty : tin tout avg-cpu user :%%% idle% iowait sys 0.2 3.5 18.7 8.4 66.7 6.2 "Disk history since boot not available. " Master:/ #sar Cesar Didtinction open /var/adm/sa/sa16 : 0551-201. Cesar : 0551-213 Try running /usr/lib/sa/sa1 "increment>;" number>; Big brother to help me! Our super-slow speed database literacy, help us! Thank you How inspection UNIX ah? Please advise, over Xianxie Our super-slow speed database literacy, help us! Thank you 20 ps aux|head look at the process in a large number of those who use cpu. [ Closed window ]