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