SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number of Locks

944709Aug 21 2012 — edited Aug 21 2012

All,

How to view the number of locks defined for a database? I am using Oracle 10g.

How to calculate the number of locks for a given sql select statement?

say for example,

select a.eno,b.ename,c.salary,d.dob,e.address
from a,b,c,d,e
where...
...
..

Assume all of them are row level locking.

I want to calculate the number of locks . How many locks will be held while running the above query?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2012

Added on Aug 21 2012

16 comments

668 views