Re: setting size of log_checkpoint_interval ?

Petra Hein/Gerald Bauer wrote:
>
> Hi,
>
> Setting the size of log_checkpoint_interval I need to know the exact size of
> an operating system block.
> We are running AIX 4.3.3. How can I determine th size of an operating system
> block ?
>
> Thanks,
> Gerald

Steve Adams' site has a wealth of information.

        http://www.ixora.com.au/home.htm

You may have to run pre-requisite scripts to establish syonyms for the x$ views.

        http://www.ixora.com.au/scripts/sql/create_xviews.sql

Here's one that's of interest to you:

        http://www.ixora.com.au/scripts/sql/log_block_size.sql

For W2K - I obtained the following:

SQL> select
  2 max(l.lebsz) log_block_size
  3 from
  4 sys.x_$kccle l
  5 where
  6 l.inst_id = userenv('Instance')
  7 /

LOG_BLOCK_SIZE

           512

1 row selected.

hth,

Paul Received on Sat May 19 2001 - 12:50:45 CDT