Home » RDBMS Server » Server Administration » Limit session problem
icon4.gif  Limit session problem [message #196610] Fri, 06 October 2006 03:28 Go to next message
skstc
Messages: 3
Registered: October 2006
Location: THAILAND
Junior Member

Hi,
I just implemented 10g DB on Windows 2003 enterprise 32 bit version. DB server is Dual Xeon processor with dual core CPU and 4GB memory. As i known this specification can support about 200-400 session in the same time. But I got big problem!!. When i check the session (use select count(*) from v$session;) it only about 146-153 session. I can not connect to DB any more and when i look on web DB console the DB agent was down!!!.

Can anybody advice me to tunning DB that can support at least 250 connection in same time?

Please....help me..
Re: Limit session problem [message #196756 is a reply to message #196610] Sat, 07 October 2006 01:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

check it out.
sql>show parameter sessions
Re: Limit session problem [message #196772 is a reply to message #196756] Sat, 07 October 2006 04:14 Go to previous messageGo to next message
skstc
Messages: 3
Registered: October 2006
Location: THAILAND
Junior Member

this is parameter. How next?

SQL> show parameter sessions

NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 1000
license_sessions_warning integer 900
logmnr_max_persistent_sessions integer 1
sessions integer 3305
shared_server_sessions integer
SQL>

What can i do?
Re: Limit session problem [message #196800 is a reply to message #196772] Sat, 07 October 2006 10:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

dear sessions parameter is ok .
now plz. post what error u got when u try to connect.
( select count(*) from v$session.) views give u how many session connect to database.

reply.
icon9.gif  Re: Limit session problem [message #196854 is a reply to message #196800] Sun, 08 October 2006 11:23 Go to previous message
skstc
Messages: 3
Registered: October 2006
Location: THAILAND
Junior Member

Database connection failed for new comming connection, but the existing sessions it still ok. And database agent was down.

How can i do?
I need to try oracle on windows 64 bit version or Linux?
(maximum connection is about 250-300 connection in the same time).
Previous Topic: Oracle XE - Can't "Go to Database Home" ?
Next Topic: mts_servers in 8i
Goto Forum:
  


Current Time: Wed Dec 07 20:03:42 CST 2016

Total time taken to generate the page: 0.13159 seconds