Re: How much time required to add constraint(s)

From: Tim Gorman <>
Date: Thu, 15 Dec 2011 16:46:00 +0000
Message-ID: <W67224197058581323967560_at_webmail111>

Run it with SQL trace enabled and then browse through the "raw" trace file to get an idea of the recursive SQL that Oracle is generating underneath the ALTER TABLE command? Perhaps just search the phrase PARSING IN CURSOR to go from SQL text to SQL text, keeping in mind the values of the "dep=" field (i.e. recursive execution depth) on each line. You don't even have to wait until the ALTER TABLE completes -- you'll likely have a really good idea of going on right from the start. Hope this helps...

-----Original Message-----

From: Rich [] Sent: Thursday, December 15, 2011 09:37 AM To: 'Oracle-L Freelists'
Subject: How much time required to add constraint(s)

Hi list,I'm trying to determine how much time will be required to build aconstraint - something like:ALTER TABLE ADD CONSTRAINT FOREIGN KEY ()REFERENCES (

-- Received on Thu Dec 15 2011 - 10:46:00 CST

Original text of this message