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
- 6598 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / diksha
select count(*) from v$session where username like ''
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kishore
select count(*),username from v$session where group by username;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / braj123
select count(*) from v$session where user_name="**";
| Is This Answer Correct ? | 1 Yes | 2 No |
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to determine the service pack currently installed on SQL Server?
what is a user-defined lock?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
what is logical system in sap basis
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is the importance of a recovery model? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is the diffrence between core dba and apps dba?
How to make a replica of existing oracle server to another server?
What are the recovery models for a database? : sql server DBA
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
