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

Thread: Tuning

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    Tuning

    This is the output of the

    SQL> select * from V$RESOURCE_LIMIT;

    RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
    ------------------------------ ------------------- --------------- ---------- ----------
    processes 86 211 350 350
    sessions 84 218 500 500
    enqueue_locks 19 46 5760 5760
    enqueue_resources 20 66 600 600
    _lm_procs 0 0 0 0
    lm_ress 0 0 0 UNLIMITED
    lm_locks 0 0 0 UNLIMITED
    lm_cache_ress 0 0 0 UNLIMITED
    dml_locks 0 94 500 500
    temporary_table_locks 0 10 UNLIMITED UNLIMITED
    transactions 1 35 550 550
    sort_segment_locks 0 13 UNLIMITED UNLIMITED
    max_rollback_segments 61 61 111 111
    distributed_transactions 1 4 137 137
    mts_max_servers 0 0 20 20
    parallel_max_servers 0 5 6 6

    What values do you suggest for better performance and how do we go about tuning ?

    thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Without knowing anything about your environment, any valuable data, any traces, any real information, I think you should at least triple every value except those that won't make a difference.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm how can you base tuning on V$RESOURCE_LIMIT

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    set make_go_fast=true
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    I would install a VF22 Turbo, some 650cc fuel injectors ans a Walbro fuel pump on that bad boy.



    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    i would go for RB25 twin turbo.. too cheap too fast
    The man called Zorro

  7. #7
    Join Date
    Aug 2002
    Posts
    176
    I am sorry I did not furnish enough details about our environment..

    We are on OLTP database with oracle 8.1.7 on Sun Solaris 5.8 on a Sun Sparc With 4 processors and 2 GB RAM.

    I was just wondering if the parameters were set appropriately or can they be changed cos the max_UTILIZATION show a lesser numer for eg the processes or the sessions.

    Pls do advice
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  8. #8
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by Rohit
    I am sorry I did not furnish enough details about our environment..

    We are on OLTP database with oracle 8.1.7 on Sun Solaris 5.8 on a Sun Sparc With 4 processors and 2 GB RAM.

    I was just wondering if the parameters were set appropriately or can they be changed cos the max_UTILIZATION show a lesser numer for eg the processes or the sessions.

    Pls do advice
    It depends.. depends on query response time. how users feelings.. if users are happy, dont touch the system..
    -nagarjuna

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    and shall I ask again, how can you base tuning on v$resource_limit

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