OraFAQ Forum: Server Administration » how to find how many connections are opened by each session in DB

Home » RDBMS Server » Server Administration » how to find how many connections are opened by each session in DB

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

how to find how many connections are opened by each session in DB [message #329550]

Wed, 25 June 2008 15:21

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
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!

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	drop a synonym
Next Topic:	to find the last executed statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 02:29:22 CST 2024