init.ora of TPC-C world record database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: init.ora of TPC-C world record database

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    init.ora of TPC-C world record database

    I was skimming the TPC benchmark disclosure report at http://www.tpc.org/results/FDR/TPCC/...050412_FDR.pdf

    Thought folks might be interested in the init.ora of the database. Tons of undocumented parameters..


    p_run.ora

    compatible = 10.1.0.0.0
    _NUMA_pool_size = 536870912
    _collect_undo_stats=false
    _awr_restrict_mode=true
    _db_writer_flush_imu=false
    timed_statistics = FALSE
    query_rewrite_enabled=false
    db_name = tpcc
    control_files = /home/oracle/db/control_001
    dml_locks = 500
    log_buffer = 67108864 # 1048576x cpu
    parallel_max_servers = 0
    parallel_min_servers = 0
    db_files = 3000
    fast_start_io_target = 0
    db_cache_size = 176000M
    db_2k_cache_size = 2048M
    db_16k_cache_size = 99000M
    db_keep_cache_size = 600000M
    db_recycle_cache_size = 64000M
    enqueue_resources = 60000
    processes = 2000
    sessions = 3000
    transactions = 2800
    shared_pool_size = 14000M
    cursor_space_for_time = TRUE
    db_block_size = 4096
    undo_management = auto
    UNDO_TABLESPACE = undo_1
    _db_cache_pre_warm=FALSE
    trace_enabled = FALSE
    db_block_checksum = FALSE
    trace_enabled = FALSE
    statistics_level = basic
    plsql_optimize_level = 2
    pga_aggregate_target = 0
    _undo_autotune = false
    undo_retention = 1
    _imu_pools = 358
    _optimizer_cache_stats = false
    _optimizer_cost_model = io
    fast_start_mttr_target = 0
    db_writer_processes = 16
    log_checkpoint_interval = 453701520
    log_checkpoints_to_alert = TRUE
    log_checkpoint_timeout = 1700
    java_pool_size = 0
    remote_login_passwordfile = shared
    disk_asynch_io = TRUE
    db_block_checking = FALSE
    cursor_space_for_time = TRUE
    lock_sga = TRUE
    replication_dependency_tracking = FALSE
    db_file_multiblock_read_count = 1
    _cursor_cache_frame_bind_memory = true
    max_dump_file_size=5M
    _db_writer_coalesce_area_size = 16777216
    aq_tm_processes = 0
    _kghdsidx_count = 1
    _ksmg_granule_size=268435456
    _two_pass=false
    _session_idle_bit_latches=3000
    utl_file_dir=*

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well a totally unrealistic parameter file - shows how worthwhile those tests are

  3. #3
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Not a _go_faster = true in sight. I always knew they weren't telling us everything.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    But at least they kept an eye on security.

    utl_file_dir=*
    this space intentionally left blank

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and one control file .....

    and if i read that right a 14gb shared pool and 176gb buffer cache

    and an undo retention of 1 second

    pile of junk...

  6. #6
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    and remote_login_passwordfile = shared would certainly raise our auditors eyebrows

  7. #7
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    LOL wonder what would happen if someone were to take that init.ora bring the memory stuff down to reasonable levels then throw it on a test box to see what would happen.hmmmmmmm
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    db_file_multiblock_read_count = 1
    Yeah, wouldn't want to risk any "dangerous" full table scans.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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