OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Session problem

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

Session problem [message #275868]

Tue, 23 October 2007 02:03

manoop
Messages: 8
Registered: October 2007

Junior Member

Hi friends,

We have a web application with Oracle 10g as backend.
The problem we are facing is that if we have more than 300 sessions
,ORA-12500- TNS Failed to start dedicated process
error is displayed

The sessions are getting killed only after 2-3 minutes after the connection is slosed

Any work around for this issue?

Thanks,

Manoop

Report message to a moderator

Re: Session problem [message #275871 is a reply to message #275868]

Tue, 23 October 2007 02:28

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

See the OS parameter settings such as maxuproc. There may be a limit.

Report message to a moderator

Re: Session problem [message #276208 is a reply to message #275868]

Wed, 24 October 2007 06:42

manoop
Messages: 8
Registered: October 2007

Junior Member

Can we do anything in the front end.
The session is getting killed after 2-3 minutes.We want that to be killed once we close the connection.

Regards
Manoop

Report message to a moderator

Re: Session problem [message #276241 is a reply to message #276208]

Wed, 24 October 2007 08:43

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

Senior Member

NO,
YOu can't do anything on front end side.
you should enable Network tracing on Server >>> sqlnet.ora<<< file.
and findout bottleneck.

Regards
Mohammed Taj

Report message to a moderator

Previous Topic:	fail to drop tablespace
Next Topic:	AWR and statspack usage on Oracle 10g Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:49:31 CST 2024