RE: How much time required to add constraint
From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 19 Dec 2011 07:14:44 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AC6299C_at_SMXC001.trivadis.com>
Hi Rich
Date: Mon, 19 Dec 2011 07:14:44 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AC6299C_at_SMXC001.trivadis.com>
Hi Rich
Also note that constraints can be validated in parallel.
Cheers,
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch
Date: Thu, 15 Dec 2011 11:15:47 -0800
Subject: Re: How much time required to add constraint(s)
From: Rich <richa03_at_gmail.com>
Thanks all - outstanding.
Now, I can roughly estimate time as well as avoid the lock.
Thanks again,
Rich
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 19 2011 - 01:14:44 CST