Re: Schema Placement for Purchased Apps

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Thu, 10 Apr 2003 07:46:00 -0700
Message-ID: <oNmdnToA7OE1HgijXTWcoA@giganews.com>

> Net result, if you have a file system buffer, match it exactly. Otherwise,
> bigger is usually better, whatever the nature of your application.

As long as you mean <tablespace_block_size> * <db_multi_block_read_count> == <os_buffer> then I aggree and was really what I was trying to say, maybe I did not say it exactly right.

Anyway, here a couple good links:

On the rlationship between O/S blocks and DB block size:

http://asktom.oracle.com/pls/ask/f?p=4950:8:25860528027466240::NO::F4950_P8_ DISPLAYID,F4950_P8_CRITERIA:596265435454, On the benefits to be gained (and a couple drawbacks) from using larger block sizes:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:329017235 004 Received on Thu Apr 10 2003 - 09:46:00 CDT