Interested to Buy Any Domain ? << Click Here >> for more details...
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 3 Answers
- 6582 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
select count(*),username from v$session where group by username;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
how can you enable flashback feature?
what is ora 24313?what is the procedure to exclude that error?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is dcl? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what do you understand by fine-grained auditing?
how can you process messages in order asynchronously?
what are the types of connection load-balancing?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
