NT Cluster size and Oracle data block size

Hi Steve:

I have two drive. One is NTFS and another is FAT. The NTFS is 4K and the FAT is 2K. So which one should be the right size for Oracle data block?

Best regards,

> The cluster size may be specified when a partition is formatted, but
> normally it is just allowed to default.
> Here is an extract from the NT help page for the format command.
>
> /a:unitsize
> Specifies the allocation unit size to use on NTFS disks. Use one of the
> following values for unitsize. If unitsize is not specified, it will be
> choosen based on disk size.
>
> 512 Creates 512 bytes per cluster, 1024 bytes per file record. Default
> if disk is less than 512 meg.
> 1024 Creates 1024 bytes per cluster, 1024 bytes per file record.
Default
> if disk is 512MB to 1G.
> 2048 Creates 2048 bytes per cluster, 2048 bytes per file record.
Default
> if disk is 1G to 2G.
> 4096 Creates 4096 bytes per cluster, 4096 bytes per file record.
Default
> if disk is over 2G.

> Steve
> >
> > Platform: NT 4
> > Database: Oracle 8
> >
> > I read one of an article concerning the tuning of database. It said
that
> > the db_block_size should be the same as the size of the NT cluster. My
> > problem is how to find out the size of the NT cluster?
> >
> > Also, I'm quite confused about the db_block_size, db_block_buffers,
> > share_pool_size, log_buffer. Can anyone explain the terms for me,
please?
> >
> > If I have:
> >
> > RAM - 256m
> > 4 database instances (two of them not active).
> > 1 of the instance is CASE repository.
> >
> > What is the best size for share_pool_size

--
Best regards, Received on Sat Sep 12 1998 - 13:16:22 CDT