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
- 6578 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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Why would you use sql agent? : sql server DBA
how does an oracle clusterware manage crs resources?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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
What are the operating modes in which database mirroring runs? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
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?
Why would you call update statistics? : sql server DBA
how can you connect from 10g user to 11g user??
what do you understand by fine-grained auditing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
