Re: How to get 8i to perform as well as 9i

From: Michael R <marothwell_at_yahoo.com>
Date: 28 Jul 2004 07:38:29 -0700
Message-ID: <b2b3ca26.0407280638.185d63c0@posting.google.com>

wy_at_fudan.edu (wy) wrote in message news:<e8d0244c.0407271802.1e9f16f7_at_posting.google.com>...
> can you try analyze table on 8i box,and see the result.
>
> wy.

I have analyzed the tables with a reasonable sample size (20% I think).

I checked out the HASH_AREA_SIZE and the SORT_AREA_SIZE are much smaller on the 8i box.

Met with the DBA's today, and the 9i upgrade is going to take place with-in the week, so I'll make sure they set the parms to a more "reasonable" value than the current 8i db.

Thanks for the help. Received on Wed Jul 28 2004 - 09:38:29 CDT