-
Creating 32K Block Size
Hi,
I tried to create a database with 32K block size, but i am getting the following error.
-----------------------------------------------------------------
$ sh UDRV61.sh
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.3.0, 64 bit - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production
SVRMGR> SVRMGR> Connected.
SVRMGR> SVRMGR> ORA-00374: parameter db_block_size = 32768 invalid, valid range [2048..16384]
SVRMGR> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> CREATE DATABASE "UDRV6"
*
ORA-01034: ORACLE not available
SVRMGR>
Server Manager complete.
--------------------------------------------------------------------
Does this mean we cannot create a database with block size greater than 16k.
Thanks
Suvashish
-
max block size is platform dependent -- consult your oracle platform documentation for details.
-
Re: Creating 32K Block Size
Originally posted by dsuva
SVRMGR> SVRMGR> ORA-00374: parameter db_block_size = 32768 invalid, valid range [2048..16384]
Looks like you'd have to select a block size between the two mentioned sizes. Depending on my application OLTP and DSS, I either use 8k or 16k... mind you it depends on what sort of block contention you want and the size of the database and the frequency of updates etc.... and many other considerations.
Cheers,
OCP 8i, 9i DBA
Brisbane Australia
-
db_block_size is operating system dependent.
Appropriate values for 8i are:
2048 � 16384 Linux, Solaris 32-bit
2048 � 32768 AIX, HPUX, Tru64, Solaris 64-bit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|