| 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
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
-----Original Message-----
From: zhu chao [mailto:chao_ping_at_vip.163.com]
Sent: Friday, April 30, 2004 11:13 PM
To: oracle-l_at_freelists.org
Subject: 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 =
=3D
> almost
> all application response time slow down.
>
> Regards
> Zhu Chao.
>
>
> ----- Original Message -----=3D20
> 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
> =3D3D
> > way of measuring the application response time?
> > Is the app running on the server hosting the DB?=3D3D20
> >
> > 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------Received on Fri Apr 30 2004 - 22:23:23 CDT
 |
 |