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
- 6551 Views
- I also Faced
- E-Mail Answers
Answer Posted / diksha
select count(*) from v$session where username like ''
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
who owns the operating system files created by the utl_file package?
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?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you record information about current session?
How do you open a cluster administrator? : sql server DBA
what are the performance views in an oracle rac environment?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the commands used in dcl? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
