DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

How can you find out how many users are currentl

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How can you find out how many users are currently logged into the database? How can you find their operating system id?

Level: high
Expected answer: There are several ways. One is to look at the v$session or v$process views. Another way is to check the current_logins parameter in the v$sysstat view. Another if you are on UNIX is to do a "ps -ef|grep oracle|wc -l? command, but this only works against a single instance installation.

(Continued on next question...)

Other Job Interview Questions