Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Enqueue Wait Events - TM - SSX
It turns out that the the culprit was the missing indexes on FK
constraints.
Two new tables were added in the new release: TABLE_A (child table to BORROWER) and TABLE_B (child table to TABLE_A). Both tables were added with FK constraints referencing the parent tables; however, indexes were not created on the FK's.
These tables were overlooked for 2 reasons:
1) Both tables were empty.
2) The monitoring did not capture any reference to these tables.
Lesson learned: the answer was always right there - just didn't look carefully enough.
Thanks all for your valuable feedback.
Regards,
Kevin Lee.
Received on Thu Feb 09 2006 - 00:36:47 CST