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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are statistics, under what circumstances they go out of date, how do you update them?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What happens on checkpoint? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What types of replication are supported in sql server? : sql server DBA
What are the different sql server versions you have worked on? : 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 can a session indicate its interest in receiving alerts?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you implement fine-grained auditing?
what is ora 24313?what is the procedure to exclude that error?
What the different types of replication and why are they used? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA