Hi, Waleed: That is what I do everytime I reorgnized a table. The table that got reorgnized was an IOT table with Overflow segment. After table recreated, I move overflow segment to make it sorted. One more thing, the table is not a key table of the applications running on this server, thoug the table is pretty big in size. I guess the difference in response time is from the network layer.But I cannot prove it. No improvement in response is ok for CPU upgrade, as CPU time is just part of the total response time, but it should not get longer:(, right? Thanks Zhu Chao ----- Original Message ----- From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Saturday, May 01, 2004 11:26 AM Subject: RE: CPU upgrade caused application slow down > Wondering if you have one major index that gets used most of the time = > using range scan. > If this is true, then reorganizing the table might have damaged a little = > bit the clustering factor. > > If this is the case, then loading the table sorted on the columns used = > by that index should help a lot. > > Regards, > > Waleed ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------