How would you determine what sessions are connected and what resources they are

How would you determine what sessions are connected and what
resources they are waiting for?

Question Posted / guest

2 Answers
8749 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you determine what sessions are connected and what resources they are waiting for?..

Answer / 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

How would you determine what sessions are connected and what resources they are waiting for?..

Answer / santo

Query v$sesstat or v$waitstat views.

Is This Answer Correct ?

3 Yes

2 No

Post New Answer

More DB Administration Interview Questions

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers

What is replication? : sql server DBA

0 Answers

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

What view would you use to look at the size of a data file?

3 Answers

What is the difference between online backup & offline backup?

3 Answers CSC,

What are the different types of indexes available in sql server? : sql server DBA

0 Answers

Can you redefine a table online?

0 Answers Oracle,

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

How can we see the database version in os level

6 Answers Oracle,

how can you communicate with operating system files from oracle?

0 Answers Oracle,

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here