Hi,
The following is the script to find out lock contention.There are only 3 locks which a DBA can tune i.e redo copy,redo allocation and redo writing.The ratio of all this 3 types of locks ie.(misses/gets)*100 and (immediate_misses/immediate_gets)*100 should be less than < 1%.

select substr(c.name,1,30),a.gets,a.misses,a.sleeps, a.immediate_gets,a.immediate_misses,b.pid
from v$latch a, v$latchholder b, v$latchname c
where a.addr = b.laddr(+)
and a.latch# = c.latch#
and (c.name like 'redo%' or c.name like 'row%' )
order by a.latch#

In case of any help please be free to ask me at [email protected]

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]