oracle session and OS cpu !
Dear Friends ,
I am using oracle in redhat Ent Linux 5 . I have 8 cpu with 8 gb ram . My question is very basic level ques . suppose my oracle database has 8 user session and have 8 cpu on the os . Now when 4 user connect at a time in oracle db , then what happen ? Does only 4 cpu is working for the 4 sessions or 8 cpu totally balance the 4 user's job ? Again if 10 users connect at a time in the DB , then what happen, 8 users take 8 cpu or 10 cpu and the 2 other users wait for in queue ? waiting for ur kind reply ... ... |
The workload is automatically shared by the scheduler in Linux across the cpus/cores as required.
The Ora DB SW will be running on one or more cores and the user jobs will vary depending on whether they are in I/O mode (waiting for disk/network input/output) or actively processing ('runnable') http://slack-linux.blogspot.com.au/2...ate-codes.html https://prutser.wordpress.com/2012/0...verage-part-1/ Basically, don't worry about scheduling. You may need to check the load average (see top cmd) and diskspace regularly (df -h), inc swap space (top). |
All times are GMT -5. The time now is 11:21 PM. |