What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
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
how can you process messages in order asynchronously?
What is the importance of a recovery model? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
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.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What is dcl? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is the use of ocr?
What is the difference between dropping a database and taking a database offline? : sql server DBA
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.
what is the role of dip user in our database?