Re: CBO & different execution plans

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 12 Mar 2007 15:18:43 -0700
Message-ID: <1173737923.186285@bubbleator.drizzle.com>

Matthias Hoys wrote:
> "joel garry" <joel-garry_at_home.com> wrote in message
> news:1173731351.669420.216270_at_c51g2000cwc.googlegroups.com...

>> On Mar 12, 12:26 pm, "Matthias Hoys" <a..._at_spam.com> wrote:
>>
>>> Our character set is WE8MSWIN1252, but I couldn't find a list of 
>>> supported
>>> character sets.
>>>
>> You can get some idea from the appendices in the Globalization Support
>> Guide.
>>
>> Metalink Note:306411.1 is pretty interesting, explaining what the
>> future may hold and recommended character sets.  Yours is one of them.
>>
>> jg
>> --
>> @home.com is bogus.
>> http://www.signonsandiego.com/uniontrib/20070310/news_1b10ams.html
>>

>
> Sorry, can't see what this Metalink note has to do with
> DBMS_ADVANCED_REWRITE ? I meant that I was looking for a list of character
> sets that dbms_advanced_rewrite supports, since Daniel mentioned in another
> post that was one of the causes of problems with the package. But maybe I
> should create a SR and ask the Oracle guys :-)
>
> Matthias

My experience with character sets was that I originally selected a character set that supported multibyte characters and had to change to WE8MSWIN1252 to get it to work.

The page: http://www.psoug.org/reference/character_sets.html is the result of that incident.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Mar 12 2007 - 17:18:43 CDT