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
- 6592 Views
- I also Faced
- E-Mail Answers
Answer Posted / diksha
select count(*) from v$session where username like ''
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain about your sql server dba experience? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Why would you use sql agent? : sql server DBA
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
How would you go about verifying the network name that the local_listener is currently using?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you communicate with operating system files from oracle?
What are the steps you will take to improve performance of a poor performing query?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the importance of a recovery model? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What purpose does the model database server? : sql server DBA
what is the use of recording information about current session?
