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
- 6430 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
Explain materialized views and how they are used.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you create a user-defined lock?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is dbcc? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you communicate with operating system files from oracle?
What happens on checkpoint? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
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
Where do you find the default index fill factor and how to change it? : sql server DBA
