Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003

    Unanswered: Startup Open Need Ideas

    Oracle 8i Release

    SVRMGR> startup open
    ORACLE instance started.
    Total System Global Area 838660256 bytes
    Fixed Size 73888 bytes
    Variable Size 804859904 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 172032 bytes
    Database mounted.
    Database opened.

    My memory in Top looks like this :
    2581496k av,
    1146872k used,
    1434624k free,
    0k shrd,
    43004k buff 281100k actv,
    696648k in_d,
    42808k in_c
    2624320k av,
    0k used,
    2624320k free
    971216k cached

    initSID.ora looks like this :

    db_block_size = 4096
    processes = 300
    parallel_max_servers = 16
    open_cursors = 500
    max_enabled_roles = 30
    db_block_buffers = 8192
    db_file_multiblock_read_count = 32
    shared_pool_size = 400004096
    large_pool_size = 400004096
    sort_area_size = 100004096
    sort_area_retained_size = 13100072
    log_buffer = 163840

    Database is really fast now but, I want to make sure it is perfect before I put it into production, it has two Intel 2.8 Xeons.
    This is when there are no users logged on, Any tips of optimizing my setup?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Any tips of optimizing my setup?
    Limit the total number of concurrent users to <= 4.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003


    LoL. I wish I could do that!

    I am going to have about 20-30 users on :-(

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts