Home » RDBMS Server » Server Administration » number of connection for a user (Oracle 11gr2,Linux 5)
number of connection for a user [message #594366] Tue, 27 August 2013 23:43 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi,

How to determine number of connections establishing from application server to database server for a particular user and also query the user is running in database.

FYI
----
user -- application user created in database.
same user exist in application.

Thanks

[Updated on: Tue, 27 August 2013 23:44]

Report message to a moderator

Re: number of connection for a user [message #594367 is a reply to message #594366] Tue, 27 August 2013 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If application is 3-tier (utilizes application server), then only application can provide the needed details.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: number of connection for a user [message #594371 is a reply to message #594366] Wed, 28 August 2013 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How to determine number of connections establishing from application server to database server for a particular user


It depends on how the application connects to the database, with the end user account or with a common account?

Regards
Michel
Re: number of connection for a user [message #594373 is a reply to message #594371] Wed, 28 August 2013 01:00 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Quote:
It depends on how the application connects to the database, with the end user account or with a common account?

with the end user account

[Updated on: Wed, 28 August 2013 01:00]

Report message to a moderator

Re: number of connection for a user [message #594377 is a reply to message #594373] Wed, 28 August 2013 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
By default in 11.2, if you didn't deactivate it, connections are audited, so query dba_audit_session.

Regards
Michel
Re: number of connection for a user [message #594379 is a reply to message #594377] Wed, 28 August 2013 01:40 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

But michel i also want to know the query that is being used by the end user.

[Updated on: Wed, 28 August 2013 01:43]

Report message to a moderator

Re: number of connection for a user [message #594381 is a reply to message #594379] Wed, 28 August 2013 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If this is the running query then join v$session and v$sql.

Regards
Michel
Re: number of connection for a user [message #594479 is a reply to message #594381] Thu, 29 August 2013 01:31 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Thank you
Re: number of connection for a user [message #594646 is a reply to message #594479] Sat, 31 August 2013 23:33 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Michel,

can you provide me query for v$session and v$sql ?

Thanks
Re: number of connection for a user [message #594648 is a reply to message #594646] Sat, 31 August 2013 23:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
are you acknowledging that after 4+ years, you are still incapable to write simple SQL which joins two VIEWS or use GOOGLE yourself?
Re: number of connection for a user [message #594651 is a reply to message #594648] Sun, 01 September 2013 00:34 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

This applies to you as well
Re: number of connection for a user [message #594652 is a reply to message #594651] Sun, 01 September 2013 00:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Mohan10g wrote on Sat, 31 August 2013 22:34
This applies to you as well


not really, because I am not the one asking for assistance from strangers unlike you.
Re: number of connection for a user [message #594655 is a reply to message #594652] Sun, 01 September 2013 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/189306/594598/102589/#msg_594598

Re: number of connection for a user [message #594656 is a reply to message #594652] Sun, 01 September 2013 01:32 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Quote:
not really, because I am not the one asking for assistance from strangers unlike you.

This is not matter of asking question me or others. Whether we know the answer or capable to answer to his/her question does matter.

[Updated on: Sun, 01 September 2013 01:34]

Report message to a moderator

Re: number of connection for a user [message #594659 is a reply to message #594656] Sun, 01 September 2013 02:33 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Here's a starting point:

select username,sql_text from v$session join v$sql using (sql_id);
Re: number of connection for a user [message #594675 is a reply to message #594659] Sun, 01 September 2013 09:41 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/mv/msg/189306/594630/136107/#msg_594630
Previous Topic: Collect object stats
Next Topic: DB link access to user
Goto Forum:
  


Current Time: Thu Mar 28 07:07:11 CDT 2024