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
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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?
What is the importance of a recovery model? : sql server DBA
how can you find out if a table can be redefined?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What would you do with an "in-doubt" distributed transaction?
What purpose does the model database server? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
how can you record information about current session?
how does an oracle clusterware manage crs resources?
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
What are the different types of indexes available in sql server? : sql server DBA