Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!195.62.100.242.MISMATCH!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.fsmpi.rwth-aachen.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: NLS_LENGTH_SEMANTICS = CHAR import is too slow Date: Sun, 5 May 2013 09:10:30 +0000 (UTC) Organization: solani.org Lines: 17 Message-ID: References: <1ef17e20-4b53-4c36-8227-849b4719d318@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1367745030 19330 eJwFwQkRADAIAzBLMJ6BnJWj/iUsCUvNuZ6RHgzyCQYRqB4v1X59LgQUMcqpWtCcXF3rEfsmMxFZ (5 May 2013 09:10:30 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Sun, 5 May 2013 09:10:30 +0000 (UTC) User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) X-User-ID: eJwNx8kRACEIBMCUcAdGDIdjyT8ErX61gYu1lUa1eWDpzp5U2PEKYGlyGO/1eUiQv3RIO0b3BRIjENI= Cancel-Lock: sha1:nnh9S7nLxFVdLwo9CUGocXgMwi4= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXRGkL5zgY/59ggkNjyQk6BnOyVoerYdvjqilmfqmFCljzBnsFR/mPbz0EfhA/ Xref: news.cambrium.nl On Sat, 04 May 2013 19:26:24 -0700, zigzagdna wrote: > 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. You are funny. You made a diagnosis and now are looking for something "worth while". Try with the tuning process. If you need help, try attaching a 10046 trace file. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com