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
6704 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 cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

how can you find out if a table can be redefined?

0 Answers Oracle,

what is a crs resource?

0 Answers Oracle,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

How do you resize a data file?

2 Answers

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers

How do you open a cluster administrator? : sql server DBA

0 Answers

What is checkpoint?

3 Answers Accenture,

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers

For more DB Administration Interview Questions Click Here