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
6403 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

How would you force a log switch?

4 Answers

How many memory layers are in the shared pool?

3 Answers

What purpose does the model database server? : sql server DBA

0 Answers

How to make a replica of existing oracle server to another server?

3 Answers

Can we take incremental backups in datapump?

1 Answers

What is blocking and how would you troubleshoot it?

1 Answers

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

3 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

the process of adding a cpu in sql server is called..?

2 Answers TCS,

what is asm?

0 Answers Oracle,

What is a system database and what is a user database? : sql server DBA

0 Answers

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

For more DB Administration Interview Questions Click Here