1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

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 a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 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,

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,




What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

Name a tablespace automatically created when you create a database.

5 Answers  

what r the types of backup?

5 Answers   CSC,

For more DB Administration Interview Questions Click Here
Categories