OraFAQ Forum: Server Administration » Limit session problem

Home » RDBMS Server » Server Administration » Limit session problem

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

Limit session problem [message #196610]

Fri, 06 October 2006 03:28

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..

Report message to a moderator

Re: Limit session problem [message #196756 is a reply to message #196610]

Sat, 07 October 2006 01:11

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

check it out.
sql>show parameter sessions

Report message to a moderator

Re: Limit session problem [message #196772 is a reply to message #196756]

Sat, 07 October 2006 04:14

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?

Report message to a moderator

Re: Limit session problem [message #196800 is a reply to message #196772]

Sat, 07 October 2006 10:42

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.

Report message to a moderator

Re: Limit session problem [message #196854 is a reply to message #196800]

Sun, 08 October 2006 11:23

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).

Report message to a moderator

Previous Topic:	Oracle XE - Can't "Go to Database Home" ?
Next Topic:	mts_servers in 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:41:38 CDT 2024