Re: Bad performance because of wrong characterset?

The "fun" part is that if the database will perform better after recreation for some reason, then the HP guys (and probably your bosses) will tell you, "we said so" or smth like that :)

Of course when performance goes bad again after a week, HP guys will probably ask for a block size change + db reorg ;)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 17, 2003 10:24 PM

> No characterset changed yet. They want us to recreate the database. the
> system is going live in a few weeks. I simply hate changing things because
> someone says so. It might be the quickest solution, but most probably not,
> and then it's a waste of time, energy etc.
>
> >Here's a wild guess. If the character set is changed, a 10 MB segment
> >(from the
> >first extent to high water mark) may become 20 MB or 5 MB. Then CBO
> >changes the
> >plan and it happens to be a bad one.
> >
> >Yong Huang
>
> Regards, Carel-Jan
>
> -- There will allwasy be another 10 last bugs --
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Carel-Jan
> INET: cjpengel.dbalert_at_xs4all.nl
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).