Interested to Buy Any Domain ? << Click Here >> for more details...
How would you determine what sessions are connected and what
resources they are waiting for?
- 2 Answers
- 8745 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
What are the different sql server versions you have worked on? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How can you control the amount of free space in your index pages? : sql server DBA
What is dbcc? : sql server DBA
What purpose does the model database server? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What happens on checkpoint? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the default fill factor value? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
