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

What are the steps you will take to improve performance of a poor performing query?

What the different types of replication and why are they used? : sql server DBA

what is the difference between off-line back up and on-line back up in ibm db2 udb?

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

How do you resize a data file?

How do you add a data file to a tablespace?

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

When creating a user, what permissions must you grant to allow them to connect to the database?

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

What happens on checkpoint? : sql server DBA

How can you rebuild an index?

Name a tablespace automatically created when you create a database.

For more DB Administration Interview Questions Click Here