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

Thread: Database block size in 9.2

  1. 09-18-2003, 12:39 AM #1
    newcomer
    newcomer is offline Member
    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
    Reply With Quote Reply With Quote
  2. 09-18-2003, 12:53 AM #2
    mdash
    mdash is offline Junior Member
    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
    Reply With Quote Reply With Quote
  3. 09-18-2003, 03:33 AM #3
    wengyan
    wengyan is offline Junior Member
    Join Date
    Aug 2002
    Posts
    10
    U can find the parameter in init.ora
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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