select count(*) from v$session where username like ''

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

Question Posted / diksha

Answer Posted / diksha

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you trace the traffic hitting a sql server? : sql server DBA

1565

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?

3408

what are the benefits of flashback feature?

1021

Which autogrowth database setting is good? : sql server DBA

1152

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2033

Why would you call update statistics? : sql server DBA

988

how to restore files with rman?

2302

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

1065

What would you do with an "in-doubt" distributed transaction?

1885

how can you enable flashback feature?

949

What is the difference between clustered and non-clustered index? : sql server DBA

1088

what is ora 24313?what is the procedure to exclude that error?

2568

What is the default fill factor value? : sql server DBA

1126

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1973

what is the use of ocr?

1031