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

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

More DB Administration Interview Questions

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

What background process refreshes materialized views?

what is the role of dip user in our database?

Why does Oracle not permit the use of PCTUSED with indexes?

what is the differnce between process and thread ?

what is the difference between catalog & nocatalog?

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

how can you schedule a job in database?

What are statistics, under what circumstances they go out of date, how do you update them?

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

How many packages we have in db

How do you troubleshoot errors in a sql server agent job? : sql server DBA

For more DB Administration Interview Questions Click Here