Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tough time dropping a user
Can you reproduce it consistently?
enable 10046 for your drop session, and you can find where oracle is
spending its time.
Maybe space management, quite likely, if you are using dictionary managed
tablespace.
If you suspect FK related, drop the FK constraint first see how long it
took, and drop user later.
On 10/10/05, Stephane Faroult <sfaroult_at_roughsea.com> wrote:
>
> Raj,
>
> Drop user objects first, it's usually MUCH faster.
>
> SF
>
> On Sun, 2005-10-09 at 23:23 -0700, raja rao wrote:
> >
> > Hi All,
> >
> > db: 9i
> > os: solaris 9
> >
> > Can some one help me in dropping a user.
> >
> > Its taking 5 hrs to drop the user.
> > It has got several FK relation with other schema objects.
> >
> > We are using "drop user obt cascade;"
> >
> >
> > Is there any fastest way to drop the user.
> >
> > Thanks in advance
> > Raj
> >
> > ______________________________________________________________________
> > Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
-- Regards Zhu Chao www.cnoug.org <http://www.cnoug.org> -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 10 2005 - 02:56:43 CDT