Home » RDBMS Server » Server Administration » ORA-00020: maximum number of processes (400) exceeded (Oracle 11gr2,Linux)
ORA-00020: maximum number of processes (400) exceeded [message #592611] Fri, 09 August 2013 18:29 Go to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi,

To investigate further on this error ,i want to find how many user connections got established
during the error time and their details like machine,username,program,status etc in database ?

Thank you
Re: ORA-00020: maximum number of processes (400) exceeded [message #592616 is a reply to message #592611] Fri, 09 August 2013 19:58 Go to previous messageGo to next message
BlackSwan
Messages: 22677
Registered: January 2009
Senior Member
AUDIT CREATE SESSION

or query V$SESSION while the problem occurs
Re: ORA-00020: maximum number of processes (400) exceeded [message #592618 is a reply to message #592616] Fri, 09 August 2013 20:07 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi Black,

Let me rephrase my sentence.

Could you tell me how to find how many connections got established and their details like
machine , username etc.. for a specified time in database. ( say for example if i want to find connection details 2 hours ago )
Re: ORA-00020: maximum number of processes (400) exceeded [message #592619 is a reply to message #592618] Fri, 09 August 2013 20:14 Go to previous messageGo to next message
BlackSwan
Messages: 22677
Registered: January 2009
Senior Member
Default DB configuration does not record these details.
If you desire to capture & record such details, then YOU must put into place code to meet your requirements.

your request is like trying to determine how your son drove your car while he was out with his friends last night.
The car does not log such operational details as delivered from the factory.

[Updated on: Fri, 09 August 2013 20:16]

Report message to a moderator

Re: ORA-00020: maximum number of processes (400) exceeded [message #592620 is a reply to message #592618] Fri, 09 August 2013 21:14 Go to previous messageGo to next message
John Watson
Messages: 4473
Registered: January 2010
Location: Global Village
Senior Member
Logon is audited by default, so unless you have turned it off you'll find all this in the audit trail, look at dba_audit_session.
Re: ORA-00020: maximum number of processes (400) exceeded [message #592712 is a reply to message #592619] Sun, 11 August 2013 10:23 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Black,

Quote:
your request is like trying to determine how your son drove your car while he was out with his friends last night.
The car does not log such operational details as delivered from the factory.

I will not ask him such things unless he has droven the car flawlessly.Moreover lets be professional in what we are
discussing in forum rather than involving our families as an example son,daughter etc.

Hi John,
Quote:
Logon is audited by default, so unless you have turned it off you'll find all this in the audit trail, look at dba_audit_session.

Thanks for hint. Smile

[Updated on: Sun, 11 August 2013 10:25]

Report message to a moderator

Re: ORA-00020: maximum number of processes (400) exceeded [message #592845 is a reply to message #592712] Mon, 12 August 2013 12:42 Go to previous message
joy_division
Messages: 4502
Registered: February 2005
Location: East Coast USA
Senior Member
suhasdba wrote on Sun, 11 August 2013 11:23
Black,

Quote:
your request is like trying to determine how your son drove your car while he was out with his friends last night.
The car does not log such operational details as delivered from the factory.

I will not ask him such things unless he has droven the car flawlessly.Moreover lets be professional in what we are
discussing in forum rather than involving our families as an example son,daughter etc.


I guess you didn't understand the analogy.
Previous Topic: Displaying session level parameters
Next Topic: ORA-01157: cannot identify/lock data file 201
Goto Forum:
  


Current Time: Wed Aug 20 00:25:16 CDT 2014

Total time taken to generate the page: 0.06112 seconds