Re: How much time required to add constraint(s)
- From: "Tim Gorman" <tim@xxxxxxxxx>
- To: richa03@xxxxxxxxx, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Dec 2011 16:46:00 +0000
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 [mailto:richa03@xxxxxxxxx]
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 (
--
//www.freelists.org/webpage/oracle-l
Other related posts:
