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
- 6591 Views
- I also Faced
- E-Mail Answers
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
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?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What authentication modes does sql server support? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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?
internal architecture
Where would you look for errors from the database engine?
What purpose does the model database server? : sql server DBA
How do you trace the traffic hitting a sql server? : 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
What is transparent data encryption? : sql server DBA
what functionality does oracle provide to secure sensitive information?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
