estimate progress of constraint creation?
From: Adric Norris <landstander668_at_gmail.com>
Date: Tue, 24 Jan 2012 11:31:24 -0600
Message-ID: <CAJueESrw4ar7bGyE04zz4zchODi=1aLsDKSgbNka9do2KxfmQA_at_mail.gmail.com>
Anyone know a good way to estimate the overall progress of a constraint creation/validation? We're in the process of adding a number of NOT NULL constraints that were inadvertently dropped from a large partitioned table (during a database migration), and the process is taking a *very* long time. The v$session_longops view isn't much help, because it simply shows
"Table Scan: (stale or locked) obj#134849" over and over... presumably
these are the individual partition scans. Under normal circumstances I'd create these constraints as DISABLE NOVALIDATE, and then alter them with RELY. Sadly, Oracle doesn't seem to allow the use of RELY with NOT NULL constraints. :(
Date: Tue, 24 Jan 2012 11:31:24 -0600
Message-ID: <CAJueESrw4ar7bGyE04zz4zchODi=1aLsDKSgbNka9do2KxfmQA_at_mail.gmail.com>
Anyone know a good way to estimate the overall progress of a constraint creation/validation? We're in the process of adding a number of NOT NULL constraints that were inadvertently dropped from a large partitioned table (during a database migration), and the process is taking a *very* long time. The v$session_longops view isn't much help, because it simply shows
"Table Scan: (stale or locked) obj#134849" over and over... presumably
these are the individual partition scans. Under normal circumstances I'd create these constraints as DISABLE NOVALIDATE, and then alter them with RELY. Sadly, Oracle doesn't seem to allow the use of RELY with NOT NULL constraints. :(
At this point, I don't think there's any way to speed the constraint creation up. Learning of a way to estimate the percentage complete, however, would make me very happy. Any suggestions?
Thanx!
--Received on Tue Jan 24 2012 - 11:31:24 CST
"I'm too sexy for my code." -Awk Sed Fred
-- http://www.freelists.org/webpage/oracle-l