| How to balance the process and session? [message #289506] |
Sat, 22 December 2007 23:37  |
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 #289542 is a reply to message #289513] |
Sun, 23 December 2007 23:05  |
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 #289548 is a reply to message #289543] |
Sun, 23 December 2007 23:49 |
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 #289568 is a reply to message #289557] |
Mon, 24 December 2007 01:45 |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
