Re: ORA-00054 (alter table add partition)
From: Kurt Franke <Kurt-Franke_at_web.de>
Date: Fri, 16 Oct 2009 16:57:13 +0200
Message-Id: <1318621159_at_web.de>
Date: Fri, 16 Oct 2009 16:57:13 +0200
Message-Id: <1318621159_at_web.de>
>
> When we start our application for the first time creates 100 range
> partitions with 10 hash subpartitions for a table.
>
> We have observed that only 90 partitions are getting created and for
> remaining partitions we are getting "ORA-00054 : resource busy and
> acquire with NOWAIT specified" exceptions.
>
may be a problem with dml_locks parameter not large enough (i.e. 900) ?
regards
kf
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 16 2009 - 09:57:13 CDT