Re: Schema Placement for Purchased Apps

From: Howard J. Rogers <howardjr20002_at_yahoo.com.au>
Date: Fri, 11 Apr 2003 07:57:57 +1000
Message-ID: <pDlla.11488$1s1.179754@newsfeeds.bigpond.com>

"Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message news:oNmdnToA7OE1HgijXTWcoA_at_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.
>

That's not what I meant, actually. It's not what Steve Adams means, either.

> 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

Tom's advice on one of your links is 'standard Oracle', which is not surprising considering where the advice is hosted. It doesn't happen to be technically correct, however.

Regards
HJR Received on Thu Apr 10 2003 - 16:57:57 CDT