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
- 6407 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 replication? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how to restore files with rman?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what are the performance views in an oracle rac environment?
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?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what do you understand by fine-grained auditing?
who owns the operating system files created by the utl_file package?
