What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
Answer Posted / braj123
select count(*) from v$session where user_name="**";
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the default fill factor value? : sql server DBA
what is a crs resource?
Explain materialized views and how they are used.
What is the default port no on which sql server listens? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the operating modes in which database mirroring runs? : 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
how to restore files with rman?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
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?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How do you open a cluster administrator? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?