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