How would you determine what sessions are connected and what
resources they are waiting for?
Answer Posted / santosh
You can use v$session and v$locks to view this. If you want
to see which process is taking long time you can query
v$session_longops
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you schedule a job in database?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
how can you create a user-defined lock?
What are the steps you will take to improve performance of a poor performing query?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
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
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is dbcc? : sql server DBA
How to start SQL Server in minimal configuration mode?
What is the default fill factor value? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA