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

How would you extract DDL of a table without using a GUI tool?

1 Answers  

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

how can you enable flashback feature?

1 Answers   Oracle,

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1 Answers  

what is the difference between catalog & nocatalog?

3 Answers   CSC,

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1 Answers  

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

how can you initialize log miner?

1 Answers   Oracle,

Can we take incremental backups in datapump?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories