sys.v$lock v$locked

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

Question Posted / braj123

Answer Posted / braj123

sys.v$lock
v$locked_object

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why would you use sql agent? : sql server DBA

1064

What is a system database and what is a user database? : sql server DBA

1196

What the different topologies in which replication can be configured? : sql server DBA

1244

What is dbcc? : sql server DBA

1260

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4415

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2176

what is a crs resource?

1146

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1060

Explain about your sql server dba experience? : sql server DBA

1067

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1022

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1083

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1963

Query processing is slow(eg select query)how will u solve that

7871

Why does Oracle not permit the use of PCTUSED with indexes?

2922

What purpose does the model database server? : sql server DBA

1153