How to view existing locks on the database?

Question Posted / sushma chaudhary

How to view existing locks on the database?..

Answer / Tarun Goel

To view existing locks on the database in Oracle, you can use the DBA_LOCKS view. Here's an example query:nn`SELECT * FROM dba_locks;`

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

How do I reset a sequence in oracle?

Hi Can any one tell me what are the API's used in requisition import.

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

After update how do u know how many records got updated

pls explain connect by prior with example and its real time use

"primary key=unique+null" is equal,reson?not,reason?

What is a Synonym ?

What is the difference between a hot backup and a cold backup in oracle?

what is normalisation?what are its uses?

How to select all columns of all rows from a table in oracle?

What is a Temporary Segment ?

does the query needs a hint to access a materialized view?

For more Oracle General Interview Questions Click Here