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

Thread: DB_BLOCK_SIZE change

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    DB_BLOCK_SIZE change

    Hi, I have just installed Oracle 9i and created an instance with db_block_size = 8192.. Can I modify this parameter to 16384 after the database has been created? I know that you cannot do this in previous versions of Oracle. I cannot seem to find this answer anywhere. Please help. Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    In 9i you can create additional tablespaces with a larger block size. However, if you just created the database, it would be better to recreate it with the larger block size. Practice makes perfect.
    this space intentionally left blank

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