Re: Enable 32K Block in 8K Block DB

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 29 Mar 2004 14:30:51 GMT
Message-ID: <vqW9c.149$6W6.8@nwrddc03.gnilink.net>

"Charles" <cdavis10717_at_comcast.net> wrote in message news:83dbb3cd.0403290528.7dae3736_at_posting.google.com... --snip--
> The database I am working with is a 1.8TB SAP R/3 oracle database. I
> wanted to reorganize its indices into 32K tablespaces since some
> Oracle Performance book author(s) have indicated that's a good idea
> for indices.
>
> Aside from that, SAP R/3 databases have thousands of tiny or empty
> tables defined in them, and I wanted to reorganize them onto 2K
> blocks.
>
> Then, I could better size the caches for these tables as I attempt to
> tune this database.
>
> That's the background incentive behind this request.
>
> But aside from starting a thread about databse tuning, I'd just like
> to learn the proper steps for enable the multiple block sizes so I at
> least have the option of using them, pending I comply with my AIX
> block size constraints.
>
> Thanks.
>
> Charles

Burleson alert!!!
Such an advice is usually given by him. And usually without any proof or specifics as to where/how it applies.

http://www.remote-dba.cc/s56.htm

His advice has already been debated here. Search Google groups for
32K index block size jonathan lewis oracle

and click on the link which goes "Myth revisited"

Anurag Received on Mon Mar 29 2004 - 08:30:51 CST