DB_BLOCK_SIZE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DB_BLOCK_SIZE

  1. #1
    Join Date
    Jan 2001
    Posts
    72

    Lightbulb

    Hi if the
    DB_BLOCK_SIZE is not specified in the initialization parameter file, does that mean that it will default to 8k?

    I am running 8i on solaris

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Operating System Dependant. Check it up OS dependent documentation/metalink

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Hi

    When creating a database manually, you must/should specify the following params before starting the instance...

    db_name
    control_files
    db_block_size

    With best wishes.


  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    The default value is 2K.

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Tami,

    Thats true with old versions. Iam not sure with 8i and its more OS dependent. They stopped defaulting to 2k in 8i I guess. I never tried. Are you sure ?

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