Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8

    Exclamation Unanswered: init.ora setting for this server

    Hy Guys, what i need is simply a init.ora config file for this PC:


    Dual Penthium III CPU
    1Gb of RAM
    3 HD - 35GB SCSI 1

    The Db structure is made up with 6 tables with at least 5 milion of record for each and 50 others small tables for decodifics. All tables are joined and indexed.

    When i execute a SQL-query that involve 5 tables (2 big and 3 small), to do some calculation, i have to wait 45 minutes for every record.
    I thinks that this performance problem is due to the changes, made from others people, to the settings of init.ora file.

    The parameters are:

    db_block_buffers = ???
    db_block_size = ???
    db_file_multiblock_read_count = ???
    db_files = ???
    distributed_transactions = ???
    global_names = TRUE
    java_pool_size = ???
    large_pool_size = ???
    log_buffer = ???
    log_checkpoint_interval = ???
    log_checkpoint_timeout = ???
    max_dump_file_size = ???
    max_enabled_roles = ???
    open_cursors = ???
    parallel_max_servers = ???
    processes = ???
    shared_pool_size = ???
    sort_area_retained_size = ???
    sort_area_size = ???

    A short description about the meaning of these parameters would be helpfull.


    Thank you very very much.
    Last edited by interceptor; 01-11-05 at 03:16.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    restore the old settings from the backup if then performance was sufficient ..
    otherwise post some more semantic sugar about the data model, disk layout and current settings of your init.ora and check if all your indexes are valid
    check the plan table
    set dbms_system.sql_trace_in_session (sid, serial#, true); prior running your query
    set analyze the trace file with tkprof

  3. #3
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8
    Quote Originally Posted by osy45
    restore the old settings from the backup if then performance was sufficient ..
    otherwise post some more semantic sugar about the data model, disk layout and current settings of your init.ora and check if all your indexes are valid
    check the plan table
    set dbms_system.sql_trace_in_session (sid, serial#, true); prior running your query
    set analyze the trace file with tkprof

    The backup doesen't exist

Posting Permissions

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