OraFAQ Forum: Server Administration » Utilization of sessions parameters in RAC HP-UNIX server

Home » RDBMS Server » Server Administration » Utilization of sessions parameters in RAC HP-UNIX server (Oracle database 10g RAC)

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

Utilization of sessions parameters in RAC HP-UNIX server [message #647245]

Sun, 24 January 2016 03:17

ziadabuqasem
Messages: 5
Registered: January 2016

Junior Member

Dear ALL,

I have server HP-UNIX RAC 2 nodes installed oracle database 10g (8gb RAM on each node + 4 cores CPU)

we have an error always appear maximum number of session exceeded and I kill the inactive sessions to solve this issue temporary

I have the following parameters details on each node:

transaction parameter = 731
session parameter = 665
processes parameter = 600

If I want to increase the session parameter to 800 sessions on each session the server HP-UNIX will servive this
number of session how can I calculate the maximum number of sessions the server can handle ?
please help me.

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647246 is a reply to message #647245]

Sun, 24 January 2016 03:53

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

Senior Member
Account Moderator

It depends on what the sessions do, of course.
See how your server is currently loaded and applies a rule of three.
You can also investigate on connection pooling or shared servers to share the sessions/processes.

[Updated on: Sun, 24 January 2016 03:54]

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647248 is a reply to message #647246]

Sun, 24 January 2016 05:07

ziadabuqasem
Messages: 5
Registered: January 2016

Junior Member

the sessions more than 80% transactions DML commands and 20% only queries and reporting.

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647249 is a reply to message #647245]

Sun, 24 January 2016 05:12

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

800 sessions means 800 session server processes. If you think that your HP-UX may trouble managing that many processes, discuss it with your SAs. If it does, you could use multithreaded server.
Or upgrade: 11.x has the Database Resdent Connection Pool, 12.x has threaded execution.

And to do the moderator bit:

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647250 is a reply to message #647248]

Sun, 24 January 2016 05:46

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

Senior Member
Account Moderator

ziadabuqasem wrote on Sun, 24 January 2016 12:07

the sessions more than 80% transactions DML commands and 20% only queries and reporting.

How much CPU? How much load? How much IOs? Compare with what your server can support.
This is FIRST a question at OS level.

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647267 is a reply to message #647250]

Mon, 25 January 2016 01:13

ziadabuqasem
Messages: 5
Registered: January 2016

Junior Member

I checked the logical and physical memory in HP-UX

# swapinfo
             Kb      Kb      Kb   PCT  START/      Kb
TYPE      AVAIL    USED    FREE  USED   LIMIT RESERVE  PRI  NAME
dev     8388608 1318396 7070212   16%       0       -    1  /dev/vg00/lvol2
dev     16777216 1317740 15459476    8%       0       -    1  /dev/vg00/lvol9
reserve       - 9928048 -9928048
memory  7949164 5218248 2730916   66%

$top

System: kaashdb2                                      Mon Jan 25 10:09:26 2016
Load averages: 0.47, 0.40, 0.38
630 processes: 581 sleeping, 49 running
Cpu states:
CPU   LOAD   USER   NICE    SYS   IDLE  BLOCK  SWAIT   INTR   SSYS
 0    0.47   7.9%   0.0%   4.0%  88.1%   0.0%   0.0%   0.0%   0.0%
 2    0.48   8.9%   0.0%   0.0%  91.1%   0.0%   0.0%   0.0%   0.0%
 4    0.43   1.0%   0.0%   0.0%  99.0%   0.0%   0.0%   0.0%   0.0%
 6    0.49  33.0%   0.0%   0.0%  67.0%   0.0%   0.0%   0.0%   0.0%
---   ----  -----  -----  -----  -----  -----  -----  -----  -----
avg   0.47  12.9%   0.0%   1.0%  86.1%   0.0%   0.0%   0.0%   0.0%

System Page Size: 4Kbytes
Memory: 4004608K (1032384K) real, 9138756K (2374700K) virtual, 428620K free  Pag
e# 1/70

CPU TTY  PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND
 2   ? 22705 oracle   178 20  3416M  4768K sleep 1443:16 27.59 27.54 oracleKAASH
 4   ?  6540 oracle   178 20  3416M  5980K sleep    5:05 24.88 24.84 oracleKAASH
 2   ?  4141 oracle   178 20  3416M  5344K sleep    1:49 23.19 23.14 oracleKAASH
 2   ? 27920 oracle   178 20  3416M  7604K sleep    0:10 21.93 21.89 oracleKAASH
 2   ?  7310 oracle   178 20  3418M  6528K sleep    6:20 10.90 10.88 oracleKAASH
 6   ?  6877 oracle   178 20  3416M  5676K sleep    1:12  6.08  6.06 oracleKAASH
 4   ? 11407 oracle   178 20  3416M  9836K sleep    0:21  2.39  2.39 oracleKAAS

this is the result is this high load or low load on the resources ?
Can I increase the sessions 100 more?

[Updated on: Mon, 25 January 2016 01:19] by Moderator

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647269 is a reply to message #647267]

Mon, 25 January 2016 01:19

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

Senior Member
Account Moderator

Please read How to use [code] tags and make your code easier to read.
See how your post looks like now I formatted it, isn't is better?

Quote:

this is the result is this high load or low load on the resources ?

What is your opinion?

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647270 is a reply to message #647269]

Mon, 25 January 2016 01:29

ziadabuqasem
Messages: 5
Registered: January 2016

Junior Member

the used and available percentages result I think there is enough resources in the server
but there is any thing else I have to check before increase number of session or this enough?

what is your suggestion?

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647271 is a reply to message #647270]

Mon, 25 January 2016 02:08

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

Senior Member
Account Moderator

Do not think, prove, why do you think "there is enough resources in the server"?

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647273 is a reply to message #647271]

Mon, 25 January 2016 02:42

ziadabuqasem
Messages: 5
Registered: January 2016

Junior Member

Actually I dont have big experience in unix server administration
but from the percentage shown from the top & swapinfo command the usage percentage was not big

if you have experience in this issue inform me please.

Load averages: 0.47, 0.40, 0.38
630 processes: 581 sleeping, 49 running
Cpu states:
CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
0 0.47 7.9% 0.0% 4.0% 88.1% 0.0% 0.0% 0.0% 0.0%
2 0.48 8.9% 0.0% 0.0% 91.1% 0.0% 0.0% 0.0% 0.0%
4 0.43 1.0% 0.0% 0.0% 99.0% 0.0% 0.0% 0.0% 0.0%
6 0.49 33.0% 0.0% 0.0% 67.0% 0.0% 0.0% 0.0% 0.0%
--- ---- ----- ----- ----- ----- ----- ----- ----- -----
avg 0.47 12.9% 0.0% 1.0% 86.1% 0.0% 0.0% 0.0% 0.0%

System Page Size: 4Kbytes
Memory: 4004608K (1032384K) real, 9138756K (2374700K) virtual, 428620K free Pag
e# 1/70

Report message to a moderator

Re: Utilization of sessions parameters in RAC HP-UNIX server [message #647274 is a reply to message #647273]

Mon, 25 January 2016 02:50

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

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 25 January 2016 08:19

Please read How to use [code] tags and make your code easier to read.
See how your post looks like now I formatted it, isn't is better?
...

Report message to a moderator

Previous Topic:	Is it advisable to prepare catupgrd script for upgrading database
Next Topic:	Release Row Level Locking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:14:45 CST 2025