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
- Carel-Jan <cjpengel.dbalert_at_xs4all.nl> wrote:
> At 10:34 17-11-03 -0800, you wrote:
>
> >Performance depends on a lot of things, such how much string operations you
> >got, what are the contents of your strings (are they mainly latin chars or
> >are there lots of asian ones etc..).
> >
> >Tanel.
>
> Thanks Tanel for your respond. I doubt whether a query will go from several
> minutes to seconds, even when a fixed-width single-byte characterset is
> chosen. I'm not supposed to interfere with this Service Desk project, but
> just couldn't keep my mouth shut when I heard HP scheduled a meeting for
> tomorrow (when I'm not there) and claimed that recreation of a database
> with the proper characterset would do the job. I suggested to do some
> tracing & analysis first, before start shooting at a moving target in the
> dark. And of course posted the question to this bunch of knowledgable people.
>
>
> Regards, Carel-Jan
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: yong321_at_yahoo.com
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).
Received on Mon Nov 17 2003 - 13:59:27 CST
