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

Explain what partitioning is and what its benefit is.

2 Answers

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

what is asm?

0 Answers Oracle,

what is incremental checkpoint?

1 Answers CTS,

What authentication modes does sql server support? : sql server DBA

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

how can you implement fine-grained auditing?

0 Answers Oracle,

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

0 Answers

For more DB Administration Interview Questions Click Here