Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Enqueue Wait Events - TM - SSX

Re: Enqueue Wait Events - TM - SSX

From: ORAKLEE <oraklee_at_gmail.com>
Date: 8 Feb 2006 22:36:47 -0800
Message-ID: <1139467007.784947.149110@o13g2000cwo.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US