Re: Many indexes on a large table

Don't set the sort_area_size on the server/instance level, set it on the session level, i.e.

 alter session set sort_area_size=90000000;

If the indexes are all in a script as you say, put this line or one similar in as the first line of the script.

"George Barbour" <gbarbour_at_csc.com> wrote in message news:3cf60610$1_at_pull.gecm.com...
> Be aware that the sort area is allocated on per user basis so whatever
> youadd to sort_area_size will be multiplied by the amount of users connect
> to your instance.
>
> George Barbour.
> "Karl Larson" <karl.larson_at_cox.net> wrote in message
> news:%ffJ8.5857$ok.429750_at_news2.east.cox.net...
> > Set your sort_area_size for the process that creates the indexes very
> large.
> > This has worked well for me in the past with large indexes.
> >
> > "Walter Campino" <Walter_no_spam_Campino_at_iona.com> wrote in message
> > news:%2fJ8.4717$1y3.232720513_at_newssvr16.news.prodigy.com...
> > > I have a table with:
> > >
> > > 1) Rows of about 300 bytes each
> > > 2) 200 million rows
> > > 3) 20 indexes
> > >
> > > This table is part of a product, so the design is not open to change
(at
> > > least in the short run).
> > > At one stage in the batch-process of building this table, 20 indexes
are
> > > created.
> > > This is done in a very simple way... by issuing 20 CREATE INDEX
> > > statements.
> > > Each takes a little under an hour to complete, with 15 hours to create
> all
> > > 20 indexes.
> > >
> > > Questions:
> > >
> > > 1) Can I somehow build these in parallel (this is a 12 CPU machine,
and
> we
> > > can use them all)
> > > 2) Any other suggestions
> > >
> > > Thanks
> > >
> > > Walter [Please post replies to the newsgroup]
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Thu May 30 2002 - 19:09:42 CDT