| View to check user connections [message #618022] |
Sun, 06 July 2014 23:40  |
|
|
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 #618036 is a reply to message #618031] |
Mon, 07 July 2014 01:01  |
|
|
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
|
|
|
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
