Database block size in 9.2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database block size in 9.2

  1. #1
    Join Date
    May 2002
    Posts
    163

    Database block size in 9.2

    Hi,
    How to check the database block size in oracle? I can not see any db_block_size or db_cache_size parameter and value in init parameter file. It has only db_block_buffers. The database is oracle 9.2.0.4.0.

    Thanks
    Nwcomer
    Student

  2. #2
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    It should be .

    Connect to db & Just check in sqlprompt

    show parameter db_block_size

    show parameter db_cache_size

  3. #3
    Join Date
    Aug 2002
    Posts
    10
    U can find the parameter in init.ora

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