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 / venkateswararao

1 Answers
3500 Views
I also Faced
E-Mail Answers

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

Answer / saraswathi muthuraman

SQL> select count(SID),USERNAME from v$session group by
USERNAME;

14
14 raghavan
2 P_21533
1 Saras

4 rows selected.

SQL>

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More Oracle General Interview Questions

How can you merge two tables in oracle?

0 Answers

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers British Telecom BT,

structural difference between bitmap and btree index ?

1 Answers Infosys,

How to create index-by table in oracle?

3 Answers

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers TCS,

what are Triggers?

7 Answers TCS,

what are stored procedures?

7 Answers TCS, Wells Fargo,

Please explan Why static query is more faster than dynamic query ?

2 Answers

How do I know if oracle client is installed on windows?

0 Answers

What are advantages fo Stored Procedures?

1 Answers

How do I learn what codesets are available in oracle?

0 Answers

Explain the use of constraints option in exp command.

0 Answers

For more Oracle General Interview Questions Click Here