Home » RDBMS Server » Performance Tuning » Processes and Sessions
Processes and Sessions [message #254558] Fri, 27 July 2007 02:24 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Friends,

we are running oracle 9iRAC and it is in dedicated server mode. In the init.ora file the Processes and Sessions parameter has been set to 400.
If I want to increase this parameter, which factor/s should be taken into consideration?

Thank you,
Dirish

Report message to a moderator

Re: Processes and Sessions [message #254567 is a reply to message #254558] Fri, 27 July 2007 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have any problem with the current settings?

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #254578 is a reply to message #254567] Fri, 27 July 2007 03:13 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Sir,

Actually we fear that this could be a problem in the coming days as the number of users are increasing due to the launch of a new project.

Thx

Report message to a moderator

Re: Processes and Sessions [message #254587 is a reply to message #254578] Fri, 27 July 2007 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Will you have more than 400 concurrent sessions?

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #254611 is a reply to message #254587] Fri, 27 July 2007 04:47 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
yes Sir,

we are expecting more that 400 concurrent connections.

Report message to a moderator

Re: Processes and Sessions [message #254614 is a reply to message #254611] Fri, 27 July 2007 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So update to the maximum number of concurrent sessions you think you will have.

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #254619 is a reply to message #254614] Fri, 27 July 2007 05:09 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Sir,

don't you think that factors such as memory,swap,SGA, etc should be taken into consideration before increasing this parameter?

Or what factors should be taken into consideration if any?


Thank you,

Dirish

Report message to a moderator

Re: Processes and Sessions [message #254666 is a reply to message #254619] Fri, 27 July 2007 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you need to have more concurrent sessions then you need to have the memory to handle them unless you switch to shared server mode.
Btw, processes/sessions parameter are not what use the more memory when you have more processes.

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #270916 is a reply to message #254666] Fri, 28 September 2007 07:13 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Michel,

actually I have 3GB physical memory, sga_max_size=600MB, processes and sessions 400.

due to the increasing number of users, I want to increase the processes and sessions to 600.

What do you suggest. Also the 400 was set when the server had only 2GB memory.


Thanks

Report message to a moderator

Re: Processes and Sessions [message #271214 is a reply to message #270916] Sun, 30 September 2007 20:25 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello dirish,

dirish
actually I have 3GB physical memory, sga_max_size=600MB, processes and sessions 400


If you have 3GB of physical memory... and you use 600MB to SGA... what are the usages with the rest of this physical memory?

Regards,


mson77

Report message to a moderator

Re: Processes and Sessions [message #271516 is a reply to message #271214] Mon, 01 October 2007 16:42 Go to previous messageGo to next message
OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico
Junior Member
dirish,

Despite the fact Oracle reserves SGA as shared memory segment, each process has its own memory assignment. Keep a carefull monitoring of swaping/paging after load increase.

Regards
Ignacio

[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]

[Updated on: Thu, 11 October 2007 12:40] by Moderator

Report message to a moderator

Re: Processes and Sessions [message #271811 is a reply to message #271516] Wed, 03 October 2007 01:12 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Friends,

earlier I had 2 GB mem, 600 MB SGA and 400 processes and sessions on the server.

now i have 3GB mem. Do you think this will cause a problem if I change the sga size to 1000MB and processes and sessions to 600.

Also, I had (2 GB mem) 400 open_cursors. Can I increase it to 600.

Can I include the parameter "CLOSE_CACHED_OPEN_CURSORS = TRUE" to my init file.



Thank you,
Dirish

[Updated on: Wed, 03 October 2007 01:17]

Report message to a moderator

Re: Processes and Sessions [message #271817 is a reply to message #271811] Wed, 03 October 2007 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And your OS is?

Quote:
Do you think this will cause a problem if I change the sga size to 1000MB and processes and sessions to 600.

Maybe or maybe not. Who knows what is your OS and what is the server workload and other things like that?

CLOSE_CACHED_OPEN_CURSORS? this parameter is obsolete since 8 years. Try to find a newer documentation.

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #271831 is a reply to message #271817] Wed, 03 October 2007 01:49 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
OS: solaris8 with oracle9

Thx

Report message to a moderator

Re: Processes and Sessions [message #271852 is a reply to message #271831] Wed, 03 October 2007 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, now detail the workload, how many processes, how much memory used, how much CPU used, and so on during a whole working day long.

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #271861 is a reply to message #271852] Wed, 03 October 2007 03:25 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Michel,

I gathered these statistics (average) for the past week:

from v$process: 370 (over total of 400/processes and sessions)
from v$open_cursor: 350 (over total of 400/open_cursors)
CPU Utilisation: 80%
Physical Memory Usage: 65% (over total of 3GB)
SGA Usage: 300MB (over total of 600MB)


Thank you,
Dirish

Report message to a moderator

Re: Processes and Sessions [message #272174 is a reply to message #254558] Thu, 04 October 2007 03:08 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Michel,

have you been able to go through the detaols I sent.


Thank you,
Dirish

Report message to a moderator

Re: Processes and Sessions [message #272176 is a reply to message #272174] Thu, 04 October 2007 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not sufficient and all what you can posted will be not sufficient, you have to see how is the detailed workload all along the day. Average is not sufficient.

Regards
Michel

Report message to a moderator

Processes and Sessions [message #274483 is a reply to message #254558] Tue, 16 October 2007 03:51 Go to previous messageGo to next message
JoinNepal
Messages: 33
Registered: October 2003
Member
Hi,
having great problem with Process exceed. have a look on my connection code. May be it is wrong.
Code for connection pool is attached.
========
Hope to hear from you soon.
Thanks.
Regards,
JoinNepal

Report message to a moderator

Re: Processes and Sessions [message #274512 is a reply to message #274483] Tue, 16 October 2007 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start a new topic.

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #274733 is a reply to message #274512] Wed, 17 October 2007 00:58 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Guys,

sorry was on leave.

Your piece of code seems fine.

Can you please check the number of processes in your parameter file and check it in the v$process.

Thx

Report message to a moderator

Re: Processes and Sessions [message #274745 is a reply to message #274733] Wed, 17 October 2007 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Question

Can I check my parameters? Yes I can.

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #274753 is a reply to message #274745] Wed, 17 October 2007 01:24 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Will you please send me the figures.

e.g: if the processes parameter you have 500 and v$process this reached 600.

Thx

Report message to a moderator

Re: Processes and Sessions [message #274766 is a reply to message #274753] Wed, 17 October 2007 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have around 1400 instances, which one do you want?

Regards
Michel

Report message to a moderator

Re: Processes and Sessions [message #275042 is a reply to message #274766] Thu, 18 October 2007 02:54 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
I need the instance for which you are running this piece of code

Report message to a moderator

Re: Processes and Sessions [message #275045 is a reply to message #275042] Thu, 18 October 2007 02:58 Go to previous message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which piece of code?

Regadrs
Michel

Report message to a moderator

Previous Topic: Interpretation of Alert Log Errors
Next Topic: DB Block Buffer value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 25 01:58:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.