What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 3 Answers
- 5581 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
What is dbcc? : sql server DBA
What the different components in replication and what is their use? : 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 the importance of a recovery model? : sql server DBA
what do you understand by fine-grained auditing?
who owns the operating system files created by the utl_file package?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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?
How would you go about verifying the network name that the local_listener is currently using?
Why would you call update statistics? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different sql server versions you have worked on? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
