Re: NLS_LENGTH_SEMANTICS = CHAR import is too slow
From: TheBoss <TheBoss_at_invalid.nl>
Date: 07 May 2013 22:11:00 GMT
Message-ID: <XnsA1BA38F733C1TheBossUsenet_at_213.75.12.10>
ddf <oratune_at_msn.com> wrote in
news:86131c63-6f55-499b-afa9-6ff189957973_at_googlegroups.com:
> AL32UTF8
> mn lengths.
> 2UTF8.
> I think it has to do something with NLS_LENGTH_SEMANTICS. On the
> same
> rt took 2 hours; but in Al32UTF8 with NLS_LENGTH_SEMANTICS it is
> taking 1 day!!!
>
> Can you post any proof that the NLS_LENGTH_SEMANTICS setting is
> causing your 'problem'? It's SO easy to jump to conclusions and
> impossible to jump back. Possibly you should provide evidence of your
> findings rather than speculation.
>
> "Pardon me," said Milo to the first man who happened by; "can you tell
> me where I am?"
>
> "To be sure," said Canby; "you're on the Island of Conclusions. Make
> yourself at home. You're apt to be here for some time."
>
> "But how did we get here?" asked Milo, who was still a bit puzzled by
> being there at all.
>
> "You jumped, of course," explained Canby. "That's the way most
> everyone gets here. It's really quite simple: every time you decide
> something without having a good reason, you jump to Conclusions
> whether you like it or not. It's such an easy trip to make that I've
> been here hundreds of times."
>
> "But this is such an unpleasant-looking place," Milo remarked.
>
> "Yes, that's true," admitted Canby; "it does look much better from a
> distance."
>
> As he spoke, at least eight or nine more people sailed onto the island
> from every direction possible.
>
> "Well, I'm going to jump right back," announced the Humbug, who took
> two or three practice bends, leaped as far as he could, and landed in
> a heap two feet away.
>
> "That won't do at all," scolded Canby, helping him to his feet. "You
> can never jump away from Conclusions. Getting back is not so easy.
> That's why we're so terribly crowded here."
>
>
> David Fitzjarrell
>
Date: 07 May 2013 22:11:00 GMT
Message-ID: <XnsA1BA38F733C1TheBossUsenet_at_213.75.12.10>
ddf <oratune_at_msn.com> wrote in
news:86131c63-6f55-499b-afa9-6ff189957973_at_googlegroups.com:
> On Saturday, May 4, 2013 2:38:13 PM UTC-6, zigz..._at_yahoo.com wrote:
>> I am converting a database from its current character set >> WE8ISO88591 to
> AL32UTF8
>> >> I am using NLS_LENGTH_SEMANTICS to CHAR so I do not have to increase >> colu
> mn lengths.
>> >> >> >> I follow Oracle instructions: >> >> 144808.1 >> >> 313175.1 >> >> >> >> Except import which takes way too long. >> >> >> >> I took a full export of WE8ISO8859p1 Database and now importing it in >> AL3
> 2UTF8.
>> >> >> >> It is always difficult to prove where the slowness is coming from; >> but
> I think it has to do something with NLS_LENGTH_SEMANTICS. On the
> same
>> >> server; if new database was in WE8ISO8859P1, a 5 million row table >> impo
> rt took 2 hours; but in Al32UTF8 with NLS_LENGTH_SEMANTICS it is
> taking 1 day!!!
>> >> >> >> Any idea how to improve the performance of import.
>
> Can you post any proof that the NLS_LENGTH_SEMANTICS setting is
> causing your 'problem'? It's SO easy to jump to conclusions and
> impossible to jump back. Possibly you should provide evidence of your
> findings rather than speculation.
>
> "Pardon me," said Milo to the first man who happened by; "can you tell
> me where I am?"
>
> "To be sure," said Canby; "you're on the Island of Conclusions. Make
> yourself at home. You're apt to be here for some time."
>
> "But how did we get here?" asked Milo, who was still a bit puzzled by
> being there at all.
>
> "You jumped, of course," explained Canby. "That's the way most
> everyone gets here. It's really quite simple: every time you decide
> something without having a good reason, you jump to Conclusions
> whether you like it or not. It's such an easy trip to make that I've
> been here hundreds of times."
>
> "But this is such an unpleasant-looking place," Milo remarked.
>
> "Yes, that's true," admitted Canby; "it does look much better from a
> distance."
>
> As he spoke, at least eight or nine more people sailed onto the island
> from every direction possible.
>
> "Well, I'm going to jump right back," announced the Humbug, who took
> two or three practice bends, leaped as far as he could, and landed in
> a heap two feet away.
>
> "That won't do at all," scolded Canby, helping him to his feet. "You
> can never jump away from Conclusions. Getting back is not so easy.
> That's why we're so terribly crowded here."
>
>
> David Fitzjarrell
>
:-)
http://www.youtube.com/watch?v=Xmm7bMU459o [The Phantom Tollbooth: Chapter 13 - Unfortunate Conclusions] [fragment starts at about 8:50]
http://www.youtube.com/watch?v=Llg5VODW6n4 [The Phantom Tollbooth, 1970 film based on the book]
-- JeroenReceived on Wed May 08 2013 - 00:11:00 CEST