Re: 9i multi cache buffer

You're asking me????

My advice on such matters is (1) consult your vendor and (2) consult Steve Adams, who says that HP-UX has an 8K block size. He goes on to say the following (which makes about as much sense to me as the output from top):

If your operating system is not listed in the table above, you should be able to work out the file system buffer size by studying the ratio of blks/s to r+w/s in the sar -d output for various buffered filesystems.

Let us know what the outcome is, so I can shut up about a 'right' block size.

Regards
HJR "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:aqrm06$p2s$1$8300dec7_at_news.demon.co.uk...
>
> See below
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____USA__________November 7/9 (Detroit)
> ____USA__________November 19/21 (Dallas)
> ____England______November 12/14
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> Howard J. Rogers wrote in message ...
> >
> >Under Oracle9i individual tablespaces can have a block size that
> differs
> >from the database block size. Of course, this should not be
> considered if
> >the database is using buffered I/O, because in that case the database
> block
> >size must match the file system buffer size exactly.
> >
>
> As far as I am aware, I can choose the file system block-size on my HP
> each time I add a filesystem - so is there a unit block size that is
> used
> to support the HP filesystem irrespective of the declared filesystem
> block
> size ? (e.g. the 4K that I think may be the default HP memory page
> size).
>
>
>
>
>
>
>
Received on Tue Nov 12 2002 - 19:24:37 CST