Home » RDBMS Server » Server Administration » Session problem
Session problem [message #275868] Tue, 23 October 2007 02:03 Go to next message
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
Re: Session problem [message #275871 is a reply to message #275868] Tue, 23 October 2007 02:28 Go to previous messageGo to next message
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.
Re: Session problem [message #276208 is a reply to message #275868] Wed, 24 October 2007 06:42 Go to previous messageGo to next message
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
Re: Session problem [message #276241 is a reply to message #276208] Wed, 24 October 2007 08:43 Go to previous message
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
Previous Topic: fail to drop tablespace
Next Topic: AWR and statspack usage on Oracle 10g Database
Goto Forum:
  


Current Time: Sun Dec 11 04:37:29 CST 2016

Total time taken to generate the page: 0.04390 seconds