Re: CPU upgrade caused application slow down
- From: "zhu chao" <chao_ping@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 1 May 2004 11:12:56 +0800
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.
----- Original Message -----
From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, May 01, 2004 10:59 AM
Subject: RE: CPU upgrade caused application slow down
> That table that you re-organized, is it being accessed using indexes?
>
> -----Original Message-----
> From: zhu chao [mailto:chao_ping@xxxxxxxxxxx]
> Sent: Friday, April 30, 2004 10:41 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
>
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
