X-Received: by 10.224.10.6 with SMTP id n6mr26566298qan.4.1367720784889; Sat, 04 May 2013 19:26:24 -0700 (PDT) X-Received: by 10.49.37.39 with SMTP id v7mr1354679qej.27.1367720784809; Sat, 04 May 2013 19:26:24 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!82.197.223.108.MISMATCH!feeder2.cambriumusenet.nl!feed.tweaknews.nl!209.85.216.88.MISMATCH!m7no2217662qam.0!news-out.google.com!y6ni0qax.0!nntp.google.com!m7no2217658qam.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Sat, 4 May 2013 19:26:24 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=148.177.1.211; posting-account=PUA9dQoAAAAWB6fqjaJDJmTx7eb4x-f4 NNTP-Posting-Host: 148.177.1.211 References: <1ef17e20-4b53-4c36-8227-849b4719d318@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: NLS_LENGTH_SEMANTICS = CHAR import is too slow From: zigzagdna@yahoo.com Injection-Date: Sun, 05 May 2013 02:26:24 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: news.cambrium.nl On Saturday, May 4, 2013 5:48:25 PM UTC-4, Mladen Gogala wrote: > On Sat, 04 May 2013 13:38:13 -0700, zigzagdna wrote: > Any idea how to improve the performance of import. http://www.youtube.com/watch?v=B11QLCQk9Mo -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com I am looking for something worth while! I cannot find anything on internet on inner working of NLS_LENGTH_SEMANTICS=CHAR but there is something defintely present which makes import painfully slow.