InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Can You Find Out How Many Users Are Currently Logged Into The Database? How Can You Find Their Operating System Id? |
|
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. 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. |
|