OraFAQ Forum: Server Administration » View to check user connections

Home » RDBMS Server » Server Administration » View to check user connections (Oracle 11.2.0.3.0 , Linux 6)

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

View to check user connections [message #618022]

Sun, 06 July 2014 23:40

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

When we are ask to check how many user connections have establish currently,what view should we use to check from the following queries ?

1.select count(*) from v$session where status in ('ACTIVE','INACTIVE')

2.SELECT username,
       extended_timestamp,
       owner,
       obj_name,
       action_name
FROM   dba_audit_trail
WHERE  owner = 'AUDIT_TEST'
ORDER BY timestamp;

Regards,
Database admin

[Updated on: Sun, 06 July 2014 23:41]

Report message to a moderator

Re: View to check user connections [message #618023 is a reply to message #618022]

Sun, 06 July 2014 23:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Is application 3-tier as below?

EndUser<=>browser<=>Webserver<=>ApplicationServer<=>DatabaseServer

Report message to a moderator

Re: View to check user connections [message #618031 is a reply to message #618022]

Mon, 07 July 2014 00:16

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

Senior Member
Account Moderator

Database Reference
Check the 2 views you mentioned and tell us which one is to be used.

Report message to a moderator

Re: View to check user connections [message #618036 is a reply to message #618031]

Mon, 07 July 2014 01:01

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Blackswan/Michel,

When i reread my question i found it to be wrong.Let me correct it.

When we are ask to check how many user connections have establish currently,what view should we use to check. is that v$session or dba_audit_trail view ?

Quote:

Is application 3-tier as below?

EndUser<=>browser<=>Webserver<=>ApplicationServer<=>DatabaseServer

Yes

Report message to a moderator

Re: View to check user connections [message #618038 is a reply to message #618036]

Mon, 07 July 2014 01:27

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

Senior Member
Account Moderator

My answer does not change. Which view gives the current connections? Check the documentation.

Report message to a moderator

Re: View to check user connections [message #618045 is a reply to message #618038]

Mon, 07 July 2014 04:30

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Michel,

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

By default in 11.2, if you didn't deactivate it, connections are audited, so query dba_audit_session.

Regards,
Srinivas

Report message to a moderator

Re: View to check user connections [message #618046 is a reply to message #618045]

Mon, 07 July 2014 04:52

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

Senior Member
Account Moderator

Audit have both past and current connections, if you want only current ones then query v$session (you don't need v$sql to get just the connection information).

Report message to a moderator

Re: View to check user connections [message #618047 is a reply to message #618046]

Mon, 07 July 2014 04:55

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

First thing you should clarify is EXACTLY what the person asking the question wants to know because with a structure like the one balckswan described they could be asking at any level of the stack.

Report message to a moderator

Re: View to check user connections [message #618049 is a reply to message #618047]

Mon, 07 July 2014 05:03

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Quote:

Audit have both past and current connections, if you want only current ones then query v$session (you don't need v$sql to get just the connection information).

Michel information was useful to me. Thanks Michel

[Updated on: Mon, 07 July 2014 05:04]

Report message to a moderator

Previous Topic:	How do you rename User name and switch user to a new tablespace?
Next Topic:	Transportable tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:36:32 CST 2025