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@xxxxxxxxxxx]
Sent: Friday, April 30, 2004 11:13 PM
To: oracle-l@xxxxxxxxxxxxx
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.

----- Original Message -----=20
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 =
=3D
> almost
> all application response time slow down.
>
> Regards
> Zhu Chao.
>
>
> ----- Original Message -----=3D20
> 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
> =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@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: