| Lots of 'Row Lock Waits" on the indexes, but no on the based table [message #271510] |
Mon, 01 October 2007 15:45  |
wqhhust
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
After I run the AWR report, I found there are lots of "'Row Lock Waits" on the 4 indexes of one table. But the strange thing is that there is no such wait on the base table.
(the stats shown in the section of Segments by Row Lock Waits)
How can it be like that? Under what condition will the "'Row Lock Waits" happens to index but not on the base table?
|
|
|
|
|
|
| Re: Lots of 'Row Lock Waits" on the indexes, but no on the based table [message #271523 is a reply to message #271515] |
Mon, 01 October 2007 17:20  |
wqhhust
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
create table test1 as select * from dba_objects
create index idx_test1 on test1(owner)
first
session 1:
select * from test1 where owner='SYS' for update
then
session 2:
update test1 set owner='test'
I found the incearsed value of "row lock waits" is 2 instead of 1.
That meant the following query result jump from x to x+2 instead to x+1.
select value from v$segment_statistics where statistic_name='row lock waits' and object_name='TEST1'
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
