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
- 6597 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
how does an oracle clusterware manage crs resources?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How would you go about verifying the network name that the local_listener is currently using?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Why does Oracle not permit the use of PCTUSED with indexes?
what are the benefits of flashback feature?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Can you redefine a table online?
what is logical system in sap basis
What are the operating modes in which database mirroring runs? : sql server DBA
