Re: Schema Placement for Purchased Apps

From: Howard J. Rogers <howardjr20002_at_yahoo.com.au>
Date: Thu, 10 Apr 2003 13:38:50 +1000
Message-ID: <Xw5la.10928$1s1.174289@newsfeeds.bigpond.com>

"Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message
> It used to be that the disk usage was also an issue, but it is not anymore
> because Oracle now allows you specify different block sizes for each
> tablespace, and so you can have one tablespace be 2k while another is 64k
in
> the same database.

And you'll cripple I/O operations in the process. Please visit www.ixora.com.au, and read Steve's advice on using the multiple block sizes feature in 9i. I'll give you the precis: don't, if you are running on a file system without direct I/O, because otherwise, the block size must match the filesystem buffer size exactly. And that doesn't change.

Block size is a function of filesystem, not whim, application type, or anything else.

Regards
HJR
> Combined with the ability to have multiple drive arrays
> with different RAID levels each, disk usage issues alone will not force
you
> to create another database/instance.
>
>
>
Received on Wed Apr 09 2003 - 22:38:50 CDT