| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: CPU upgrade caused application slow down
Hi,
The reorganized table is certain to use the original index/access path, as I used dbms_stats to import back the old statistics after reorgnize it. And according to statspack report, SQL using that table does not have highere cost.
So this should not cause the application slow down. If sql execution path changed , then the change in response time is not 5%, maybe 500% :).
And as CPU time is only around 10% of total response time, It is ok if the reponse time does not speedup with the CPU upgrade, but at least it should not slow down.
Feel strange.
Thanks
Zhu Chao.
> That table that you re-organized, is it being accessed using indexes?
>
> -----Original Message-----
> From: zhu chao [mailto:chao_ping_at_vip.163.com]
> Sent: Friday, April 30, 2004 10:41 PM
> To: oracle-l_at_freelists.org
> Subject: Re: CPU upgrade caused application slow down
>
>
> Hi,
> Our middleware is tuxedo here, and we measure the response time by
> txrpt(the tool that tuxedo used to generate performance report).
> Middlware and DB Server are in different subnetwork.5% performance
> degration is ok for us. I just feel strange and want to know why, as =
> almost
> all application response time slow down.
>
> Regards
> Zhu Chao.
>
>
> ----- Original Message -----=20
> From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM>
> To: <oracle-l_at_freelists.org>
> Sent: Friday, April 30, 2004 9:32 PM
> Subject: RE: CPU upgrade caused application slow down
>
>
> > You have to be more precise describing what slowed down. What is your =
> =3D
> > way of measuring the application response time?
> > Is the app running on the server hosting the DB?=3D20
> >
> > That table that you re-organized, is it being accessed using indexes?
> >
> > Waleed
> >
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Apr 30 2004 - 22:09:59 CDT
 |
 |