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
8756 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

any body know about orawaves do they really provide placements in their unique placement program

1 Answers TCS,

how can you record information about current session?

0 Answers Oracle,

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers IBM,

Name a tablespace automatically created when you create a database.

5 Answers

Can we take incremental backups in datapump?

1 Answers

what is rebuild index??

2 Answers IBM, Sapient,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

how can you schedule a job in database?

0 Answers Oracle,

how will you see when the database was started using sql prompt?

2 Answers IBM,

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

Why would you use sql agent? : sql server DBA

0 Answers

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

0 Answers

For more DB Administration Interview Questions Click Here