Tuning

[Rohit]

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

[marist89]

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.

[pando]

hmm how can you base tuning on V$RESOURCE_LIMIT

[stmontgo]

set make_go_fast=true

[Mr.Hanky]

I would install a VF22 Turbo, some 650cc fuel injectors ans a Walbro fuel pump on that bad boy.



MH

[zainalj]

i would go for RB25 twin turbo.. too cheap too fast

[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

[nagarjuna]

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..

[pando]

and shall I ask again, how can you base tuning on v$resource_limit