What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
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
what are the differences of where and if in SAS?
how can you record information about current session?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you connect from 10g user to 11g user??
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different ways you can create databases in sql server? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How would you extract DDL of a table without using a GUI tool?
how can you get actual data change values from previous transactions in oracle?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What would you do with an "in-doubt" distributed transaction?
What the different components in replication and what is their use? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?