Re: why does db_block_buffers always show 0

From: quarkman <quarkman_at_myrealbox.com>
Date: Wed, 20 Aug 2003 05:16:07 +1000
Message-ID: <oprt52g5bpzkogxn@haydn>

On Tue, 19 Aug 2003 13:52:31 GMT, Richard Foote <richard.foote_at_bigpond.com> wrote:

> "Mark D Powell" <Mark.Powell_at_eds.com> wrote in message

>
> Hi Mark,
>
> You have no choice, the block size of a temporary tablespace must be the
> default size.
>
> And as Howard has said in the past, the default block size should be
> based
> on the file system buffer size. If using raw, then generally a larger
> block
> size is best. With only very few and rare exceptions, multi block sizes
> provides flexibility with transportable tablespaces, it's not a database
> tuning feature per se.
>
> Cheers
>
> Richard
>

Gosh. Richard and I agree on something, without any qualifications or demur.

It's like he says. All of it!!

;-)
HJR Received on Tue Aug 19 2003 - 14:16:07 CDT