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
- 6568 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 is the difference between clustered and non-clustered index? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How would you go about verifying the network name that the local_listener is currently using?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
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 high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what is the use of ocr?
Explain about your sql server dba experience? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
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
what is grd?
what are the benefits of flashback feature?
