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

why we use cursors

1 Answers

what is a crs resource?

0 Answers Oracle,

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

What the different components in replication and what is their use? : sql server DBA

0 Answers

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

what is ora 600?

1 Answers

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 the use of ocr?

0 Answers Oracle,

how can you find out if a table can be redefined?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here