1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

What happens on checkpoint? : sql server DBA

0 Answers  

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

Can we take incremental backups in datapump?

1 Answers  

What are the commands used in dcl? : sql server DBA

0 Answers  




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

3 Answers  

What are the recovery models for a database? : sql server DBA

0 Answers  

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

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

1 Answers   TCS,

For more DB Administration Interview Questions Click Here
Categories