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

2 Answers
6207 Views
I also Faced
E-Mail Answers

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

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers

Explain the concept of the DUAL table.

3 Answers

what r the types of backup?

5 Answers CSC,

How would you go about generating an EXPLAIN plan?

2 Answers

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

1 Answers

What types of replication are supported in sql server? : sql server DBA

0 Answers

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

0 Answers

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

1 Answers

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers Genpact,

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

For more DB Administration Interview Questions Click Here