LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-01-2013, 11:56 PM   #1
shipon_97
Member
 
Registered: Oct 2005
Location: Bangladesh
Posts: 490

Rep: Reputation: 30
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 ... ...
 
Old 07-02-2013, 12:57 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,356

Rep: Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367
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).
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
SSH concurrent session limit and idle session time out lasygsd Linux - Newbie 3 10-30-2014 07:56 AM
make commands keep running after leaving a terminal session or ssh session Danny3031 Programming 18 01-30-2012 11:29 AM
Apache - Tomcat How to use session ID to confirm an active user session? klroller Linux - Server 4 10-08-2009 09:43 PM
Oracle 10g and Fedora 2.0 "Session lasted lesst than 10 seconds" ushradha Linux - Software 6 11-19-2004 10:04 PM


All times are GMT -5. The time now is 01:22 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration