select count(*) from v$session where user

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

Question Posted / braj123

Answer Posted / braj123

select count(*) from v$session where user_name="**";

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1036

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

1265

Which autogrowth database setting is good? : sql server DBA

1238

What are the commands you'd issue to show the explain plan for "select * from dual"?

2268

how can you initialize log miner?

1186

what is a user-defined lock?

1138

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2667

what do you understand by flashback feature of oracle?

1043

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

2013

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2025

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2782

what is grd?

1152

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2453

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1160

how can you get actual data change values from previous transactions in oracle?

1138