Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tunning an index build
Thanks. I do use nologging and parallel. I'll look at the sort_area_size if
pga_ parameters don't help
thank you
Gene Gurevich
"LS Cheng" <exriscer_at_gmail.c om> To Sent by: genegurevich_at_discover.com oracle-l-bounce_at_f cc reelists.org oracle-l_at_freelists.org Subject Re: tunning an index build 07/18/2007 12:26 PM Please respond to exriscer_at_gmail.co m
the faster way is rebuild nologging with parallel and big sort_area_size, there isnt much you can do
thanks
--
LSC
On 7/18/07, genegurevich_at_discover.com <genegurevich_at_discover.com > wrote:
Hi all:
I think I have posted on this issue before, but I can't find my old
Emails
so - sorry for the repeated question.
Here is the situation. I am running oracle 9208 and have a 40G table
with
a lot of indices - mostly bitmap
Their sizes are under 1G. These indices take about 20 to 30 minutes to
build. That seems to be too long.
I have just waited for 24 minutes to build a 82M index. The index is
parallelized 4 way, the table is
parallelized 6 ways. I have 2G sga and 1.5G pga. I do see a lot of IO
waits
(via vmstat) and I have UNIX
team looking into that. I think I have plenty of memory and the
parallelizm
should be enough for a small index.
Any thoughts on what else I should look at?
thank you
Gene Gurevich
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 18 2007 - 17:47:04 CDT
![]() |
![]() |