Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i tunning
hi
dont set sort_area_size too big, I have tested and setting it higher than 50MB does NOT get you extra benefits
Parallelism normally 2xCPU does fine for me, may be you can try it
Joe wrote:
> Hi,
>
> Environment: Oracle 9i running on Windows 2000.
> Hardware: Dual AMD, 2 Gig Ram, RAID 5 disk array (ATA/100)
> Application: Datawarehousing
>
> I am process of evaluating Oracle 9i and SQL server for a datawarehouse
> application and have some questions on how to tune 9i to maximize
> performance on index building and sorting in general.
>
> There is a large fact table (80 million rows) that I am testing in both
> environments (SQL and Oracle). I am attempting to build an index on the
> table want to insure that I have things set up so that Oracle will use as
> much memory and processor as possible. When building indexes Oracle is
> using about 400MB or the 2 Gigs of RAM and only uses 10%-15% of one
> processsor and 0% of the other.
>
> Here is what I have done so far.
> - Created a temporary 4GB tablespace and set it to default for the user
> account I use.
> - increased the sort_area_size for the session to 1GB.
> - specify nologging and paralell 2 in the create index DDLs
>
> Is this the best I can do to maximize sort procesess?
>
> Joe
>
>
>
>
>
>
>
>
>
Received on Mon Jun 24 2002 - 14:41:42 CDT