What SQL query from v$session can you run to show how many sessions are logged

What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?

Question Posted / narmada kumari

3 Answers
6590 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What SQL query from v$session can you run to show how many sessions are logged in as a particular u..

Answer / diksha

select count(*) from v$session where username like ''

Is This Answer Correct ?

1 Yes

0 No

What SQL query from v$session can you run to show how many sessions are logged in as a particular u..

Answer / kishore

select count(*),username from v$session where group by username;

Is This Answer Correct ?

0 Yes

0 No

What SQL query from v$session can you run to show how many sessions are logged in as a particular u..

Answer / braj123

select count(*) from v$session where user_name="**";

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More DB Administration Interview Questions

What is the difference between online backup & offline backup?

3 Answers CSC,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

one datafile is lost in standy side how can you recover that??

2 Answers

What are the commands used in dcl? : sql server DBA

0 Answers

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers EDS,

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

What is dcl? : sql server DBA

0 Answers

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers

For more DB Administration Interview Questions Click Here