Which dictionary tables and/or views would you look at to diagnose a locking is

Which dictionary tables and/or views would you look at to
diagnose a locking issue?

Question Posted / narmada kumari

Answers were Sorted based on User's Feedback

Which dictionary tables and/or views would you look at to diagnose a locking issue?..

Answer / braj123

sys.v$lock
v$locked_object

Is This Answer Correct ?

5 Yes

0 No

Which dictionary tables and/or views would you look at to diagnose a locking issue?..

Answer / sushma s

V$LOCKED_OBJECT

Is This Answer Correct ?

2 Yes

0 No

More DB Administration Interview Questions

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

How would you force a log switch?

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

When a user process fails, what background process cleans up after it?

How to make a replica of existing oracle server to another server?

internal architecture

Explain the use of setting GLOBAL_NAMES equal to TRUE.

What is database replicaion? What are the different types of replication you can set up in SQL Server?

How can you control the amount of free space in your index pages? : sql server DBA

how to restore files with rman?

what is grd?

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

For more DB Administration Interview Questions Click Here