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@xxxxxxxxxxxx> 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. > > > -- > //www.freelists.org/webpage/oracle-l > -- Regards Zhu Chao www.cnoug.org <http://www.cnoug.org>