Sign Up Login


  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

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

How would you force a log switch?

4 Answers  

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

How to determine the service pack currently installed on SQL Server?

1 Answers  

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories