Re: Number of extents related with performance?

Hello Nuno,

        I am using block size 8K. In fact, the whole story is, I am DBA, and some developers complain about the performance of the database. I found that most of the tables they were using is 32K. Later, I truncated some tables, change the size of NEXT parameters of some large tables to a higer values, and then load the data again to these tables. After the above action, developers said the performance is improved. In fact, some papers mentioned that the performance is not related with the extent sizes (provided that no. of extents below 1000).

David

Nuno Souto wrote:
>
> On Sat, 30 Dec 2000 23:54:03 -0800, Jimmy <anonymous_at_anonymous.com>
> wrote:
>
> >
> >
> > I am using Oracle 8.0.6.1 and solaris 2.6.
> >
> > The result make me feel that the size of extents is so important in
> >creating the objects.
> >
> >
>
> Very strange. See if you can get a copy of the paper I mentioned.
> It's worth reading. Might be because of block size you're using, or
> the specific nature of the applications you have running.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Mon Jan 01 2001 - 19:21:51 CST