-
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
-
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
-
hmm how can you base tuning on V$RESOURCE_LIMIT
-
I'm stmontgo and I approve of this message
-
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.
-
i would go for RB25 twin turbo.. too cheap too fast
The man called Zorro
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|