How would you determine what sessions are connected and what
resources they are waiting for?
- 2 Answers
- 7764 Views
- I also Faced
- E-Mail Answers
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
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what is asm?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the default fill factor value? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Where would you look for errors from the database engine?
What are the commands used in dcl? : sql server DBA
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 the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
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?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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 is the use of recording information about current session?
Why would you use sql agent? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
