Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to balance the process and session?
How to balance the process and session? [message #289506] Sat, 22 December 2007 23:37 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

From the daily report, I recognize that the max session until now is about 400 sessions. The default parameter session in database is 170. I think I must increase the session to 400, and, I wonder about the process for each session. Between normal user calling application (all of application processes are 20 : JDBC thin client, VB, and the others...) and administration users, about 320 and 80 for each. Except the background process including DBWr, LWr,CKPT... How do I balance the process and session?

OS: Solaris 10
DB: 10.2.0
Application: OAS


Thank for reply!

[Updated on: Sat, 22 December 2007 23:41]

Report message to a moderator

Re: How to balance the process and session? [message #289513 is a reply to message #289506] Sun, 23 December 2007 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc:
Quote:

SESSIONS: Default value Derived: (1.1 * PROCESSES) + 5

I think this gives you a hint to answer your question.

Regards
Michel
Re: How to balance the process and session? [message #289542 is a reply to message #289513] Sun, 23 December 2007 23:05 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel!
I knew this formual, but every thing are not simply.
I understand this problem is not belonged to Database scope. And I consider about "process" and "session" carefully. For each user connect to Database by Oracle AS using OC4J with..

<data-source
		class="com.evermind.sql.DriverManagerDataSource"
		name="VNPBillingOracleDS"
		location="jdbc/VNPBillingOracleCoreDS"
		xa-location="jdbc/xa/VNPBillingOracleXADS"
		ejb-location="jdbc/VNPBilling"
		max-connections="30"
		min-connections="0"
		connection-driver="oracle.jdbc.driver.OracleDriver"
		username="COMMON"
		password="billing"
		url="jdbc:oracle:thin:@//192.10.10.67:1521/BILLING"
		inactivity-timeout="0"
	/>	


This mean that one user will be supported 30 maximum connections .Assuming 400 users connect concurrently to Database, I have to increase to 600 - sessions (!?). Each connection is reserved by server connection, ok, however, one session by many connection calling. Except some thing like :

- Background processes (without archivelog)
- Open_cursors, session_cached_cursors and cursor_sharing (application code never closes cursor, and cursor_sharing is set to FORCE).
- All of big tables is configured with partitions.
- All of Top SQL alway monitored.

And my question is:
- What is the best Database server between Dedicated and Shared Server?

- Should I using RAC?

Thank you!


Re: How to balance the process and session? [message #289543 is a reply to message #289506] Sun, 23 December 2007 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> What is the best Database server between Dedicated and Shared Server?

BEST? Based upon which metric?

Typically MTS is used when you are resource limited (not enough RAM).
IMO, it is cheaper in long run to add RAM & avoid complications of managing MTS.
There is no such thing as a free lunch.
As with anything involving computers...
You can have it Good, Fast or Cheap; pick any two & pay the price with the one not seleted.
Re: How to balance the process and session? [message #289548 is a reply to message #289543] Sun, 23 December 2007 23:49 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel!
Best in my situation.

I think, each mode Database server Shared Server and Dedicated Server has advantage by them self.

My current Database is 10g and OS is Solaris V890 Sparc, 4 CPU, 8GB RAM

SQL> select * from v$version
  2  ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


# prtconf | grep Memory
Memory size: 8192 Megabytes
Re: How to balance the process and session? [message #289557 is a reply to message #289548] Mon, 24 December 2007 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ana answered you not me.

As far I understand your environment, you only have 30 connections to the database as AS shares the connections/sessions to the database.
Your users only connect to the AS so it is irrelevant for database parameters.

Does your AS on the same server than the database?
If so, separate them on 2 servers then you don't have any problem.

Regards
Michel
Re: How to balance the process and session? [message #289568 is a reply to message #289557] Mon, 24 December 2007 01:45 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Oh, I am sorry, Michel. And..thank you, Anna!

Yes! OAS and Database are separate system machine.

And, you detected the problem exactly, Michel. Total CPU, Memory using, processes.. in both of OAS and DB servers are not overloaded.

SQL> @C:\Private\OraPrivate\DBA_Scripts\DBA_Scripts\DBA_Scripts\Session_Manageme
nt\sess_user_sessions.sql

Max sessions allowed Number of sessions Percent Utilization
-------------------- ------------------ -------------------
                 225                 67                 30%

    Oracle User Number of Logins Active Logins Inactive Logins
--------------- ---------------- ------------- ---------------
     CCS_ADMIN1               44             0              44
            SYS                2             1               1
      CCS_ADMIN                6             0               6
 [B.G. Process]               15            15               0
                ---------------- ------------- ---------------
sum                           67            16              51
SQL>


In Database, max sessiones and max processes are

SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     200
SQL> show parameter session

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------
java_max_sessionspace_size           integer     0
java_soft_sessionspace_limit         integer     0
license_max_sessions                 integer     0
license_sessions_warning             integer     0
logmnr_max_persistent_sessions       integer     1
session_cached_cursors               integer     40
session_max_open_files               integer     10
sessions                             integer     225
shared_server_sessions               integer
SQL>


The OAS system is at 2 machines with 2 URL connections as 192.10.10.68 and 192.10.10.69. While the OAS address's 190.10.10.68 works normally, the other 69 is very, very slow. I am very surprise because of 3 machines's CPU, RAM, backgroup processess..working normally.

[Updated on: Mon, 24 December 2007 01:51]

Report message to a moderator

Re: How to balance the process and session? [message #289572 is a reply to message #289568] Mon, 24 December 2007 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem has nothing to do with processes and sessions paramters.
Investigate where the time is spent.
Activate trace in your AS to see where time is larger in one AS and so on.

Regards
Michel
Re: How to balance the process and session? [message #289577 is a reply to message #289572] Mon, 24 December 2007 02:43 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel, for you advice!
I thought like you!

And, in the Oracle Application Server, does it has the feature load balancing like RAC?

Would you like to send me the address of Oracle IAS documentation?


[Updated on: Mon, 24 December 2007 02:53]

Report message to a moderator

Re: How to balance the process and session? [message #289582 is a reply to message #289577] Mon, 24 December 2007 03:01 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know OAS, I will move this topic to OAS forum.

All documentation is in otn (http://www.oracle.com/technology/index.html) and for OAS:
http://www.oracle.com/technology/documentation/appserver.html

Regards
Michel
Previous Topic: oracle application server control
Next Topic: How i make Configuration for oracle application Server 10g with form 10g?
Goto Forum:
  


Current Time: Thu Mar 28 07:34:46 CDT 2024