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

What column differentiates the V$ views to the GV$ views and how?

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

What type of index should you use on a fact table?

What are the different ways of moving data or databases between servers and databases in SQL Server?

You have just compiled a PL/SQL package but got errors, how would you view the errors?

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

What authentication modes does sql server support? : sql server DBA

What are the commands you'd issue to show the explain plan for "select * from dual"?

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

how can you enable flashback feature?

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

Describe what redo logs are.

For more DB Administration Interview Questions Click Here