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

Answer Posted / braj123

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

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2199


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1847


What is the importance of a recovery model? : sql server DBA

781


how can you find out if a table can be redefined?

796


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

786


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1790


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

1664


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

839


Where do you find the default index fill factor and how to change it? : sql server DBA

819


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

1166


Why would you use sql agent? : sql server DBA

780


how can you record information about current session?

744


how does an oracle clusterware manage crs resources?

786


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4063


What are the different types of indexes available in sql server? : sql server DBA

823