OraFAQ Forum: Server Administration » number of connection for a user

Home » RDBMS Server » Server Administration » number of connection for a user (Oracle 11gr2,Linux 5)

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

number of connection for a user [message #594366]

Tue, 27 August 2013 23:43

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

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

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/

Report message to a moderator

Re: number of connection for a user [message #594371 is a reply to message #594366]

Wed, 28 August 2013 00:49

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: number of connection for a user [message #594373 is a reply to message #594371]

Wed, 28 August 2013 01:00

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: number of connection for a user [message #594379 is a reply to message #594377]

Wed, 28 August 2013 01:40

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If this is the running query then join v$session and v$sql.

Regards
Michel

Report message to a moderator

Re: number of connection for a user [message #594479 is a reply to message #594381]

Thu, 29 August 2013 01:31

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

Thank you

Report message to a moderator

Re: number of connection for a user [message #594646 is a reply to message #594479]

Sat, 31 August 2013 23:33

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

Michel,

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

Thanks

Report message to a moderator

Re: number of connection for a user [message #594648 is a reply to message #594646]

Sat, 31 August 2013 23:44

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?

Report message to a moderator

Re: number of connection for a user [message #594651 is a reply to message #594648]

Sun, 01 September 2013 00:34

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

This applies to you as well

Report message to a moderator

Re: number of connection for a user [message #594652 is a reply to message #594651]

Sun, 01 September 2013 00:38

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.

Report message to a moderator

Re: number of connection for a user [message #594655 is a reply to message #594652]

Sun, 01 September 2013 01:05

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: number of connection for a user [message #594656 is a reply to message #594652]

Sun, 01 September 2013 01:32

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

myphotosus@gmail.com

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

John Watson
Messages: 8960
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);

Report message to a moderator

Re: number of connection for a user [message #594675 is a reply to message #594659]

Sun, 01 September 2013 09:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/mv/msg/189306/594630/136107/#msg_594630

Report message to a moderator

Previous Topic:	Collect object stats
Next Topic:	DB link access to user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:50:57 CST 2024