OraFAQ Forum: Performance Tuning » Processes and Sessions

Home » RDBMS Server » Performance Tuning » Processes and Sessions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Processes and Sessions [message #254558]

Fri, 27 July 2007 02:24

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Attachment: ConnectionPool.java
(Size: 6.44KB, Downloaded 1608 times)

Report message to a moderator

Re: Processes and Sessions [message #274512 is a reply to message #274483]

Tue, 16 October 2007 04:47

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 23:23:31 CST 2025