Creating 32K Block Size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Creating 32K Block Size

  1. #1
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    max block size is platform dependent -- consult your oracle platform documentation for details.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203

    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

  4. #4
    Join Date
    Apr 2003
    Posts
    32
    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
  •  



Click Here to Expand Forum to Full Width