Home » RDBMS Server » Server Administration » how to find how many connections are opened by each session in DB
how to find how many connections are opened by each session in DB [message #329550] Wed, 25 June 2008 15:21 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
experts,

i got one problem with my database. i am getting this error while i am executing one package. please find the error message.

ORA-29278: SMTP transient error: 421-4.3.2 Connection rate limit exceeded
another error is

ORA-30678: too many open connections

how do i investigate this problem. i want to find how many open connections are opened by each user.

can any one provide suggestion to pin point the problem.
Re: ORA-29278: SMTP transient error: 421-4.3.2 Connection rate limit exceeded [message #329551 is a reply to message #329550] Wed, 25 June 2008 15:27 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Why do you refuse to follow Posting Guidelines?


30678, 00000, "too many open connections"
// *Cause:  An attempt to open a connection failed because too many
//          are already open by this session. The number of allowed
//          connections varies as some may be in use through other
//          components which share the same pool of allowed connections.
// *Action: Retry after closing some other connection. The number of
//          connections supported is currently not adjustable.

29278, 00000, "SMTP transient error: %s"
// *Cause:  A SMTP transient error occurred.
// *Action: Correct the error and retry the SMTP operation.


>i want to find how many open connections are opened by each user.
Modify the code that is opening the connections to update a counter.
how to find how many connections are opened by each session in DB [message #329554 is a reply to message #329550] Wed, 25 June 2008 15:40 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Experts,

i want to find how many open connections are opened by each session in the DB. which one is causing this issue. i am getting this error
ORA-30678: too many open connections

could you please suggest me how to get this info.

Re: how to find how many connections are opened by each session in DB [message #329555 is a reply to message #329550] Wed, 25 June 2008 15:44 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Do NOT cross/multi-post!
Re: how to find how many connections are opened by each session in DB [message #329560 is a reply to message #329555] Wed, 25 June 2008 16:55 Go to previous message
skumar.dba
Messages: 82
Registered: October 2007
Member
sorry my friend,

i did not understand why this error comes and where it is coming. i am seeing this error first time. could you please tell what could be the cause for this error.

29278, 00000, "SMTP transient error: %s"
// *Cause:  A SMTP transient error occurred.
// *Action: Correct the error and retry the SMTP operation.


>how do i correct this error
Correct the error and retry the SMTP operation
Previous Topic: drop a synonym
Next Topic: to find the last executed statement
Goto Forum:
  


Current Time: Fri Dec 09 04:08:57 CST 2016

Total time taken to generate the page: 0.11309 seconds