What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 3 Answers
- 5334 Views
- I also Faced
- E-Mail Answers
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
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you get actual data change values from previous transactions in oracle?
What are the different ways you can create databases in sql server? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What is the difference between clustered and non-clustered index? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What the different components in replication and what is their use? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
how can you schedule a job in database?
how can you initialize log miner?
What is the importance of a recovery model? : sql server DBA
what are the types of connection load-balancing?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
