Re: Index building takes VERY long
Date: Fri, 10 Aug 2001 16:41:20 -0400
Message-ID: <ECXc7.887$Fn4.131281_at_news.shore.net>
You can increase "sort_area_size" before creating index, that should help.
HTH. Guang
"Patrick Schlaepfer" <patrick_at_schlaepfer.com> wrote in message
news:a7c128ac.0108100653.3c294422_at_posting.google.com...
> Do have installed 9i (9.0.1.0.0) on Solaris 2.7 host.
> Ultra1/167 (640Mb ram)
> Now we I try to build the following index:
>
> create index mytab_ind on www_html_search(term_sort) indextype is
> ctxsys.context parameters ('datastore my2_chemstore section group
my2_chemstore')
> tablespace www;
>
> system isn't finished after 3hrs. Table does have about 230'000
> rows. Can't use nologging. Where, or which tablespace use
> oracle during building index, and then where is the index put.
> Is there possibility to "monitor" index creation, so I could
> see if there is something going on.
>
> Pat
Received on Fri Aug 10 2001 - 22:41:20 CEST