my init param
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: my init param

  1. #1
    Join Date
    Apr 2001
    Posts
    126

    my init param

    can i consider giving these values for DB size of >30GB and
    5000 trans per day by >30 users (30 x 5000 trans) RAM size of 2-4GB

    db_block_size=7000
    shared_pool_size=209714200
    java_pool_size= 10485600
    log_buffer= 1637400
    sort_area_size= 2047000
    sort_area_retained_size= 1023000

  2. #2
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    Wink

    Try out these, I got them as a tip from someone

    O7_DICTIONARY_ACCESSIBILITY=TRUE
    bitmap_merge_area_size=1048576
    db_block_size=4096
    db_cache_size=1543503872
    db_writer_processes=2
    java_pool_size=117440512
    large_pool_size=67108864
    sga_max_size=2735708800
    shared_pool_reserved_size=42781900
    shared_pool_size=855638016 sort_area_retained_size=512000
    sort_area_size=1024000
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

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