Re: Drop user takes too long

Jim,

    That exactly my point,
SQL>drop user blah; -- 100 tables+ 200 indexes and I sit there, and watch for 2 hrs;
Any suffestions here. What should I change to make it run faster ? "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:H18V7.1929$6p.15889_at_rwcrnsc54...
> Do you mean:
>
> drop user blah;
>
> takes 2 hours?
> That seems very unusual.
> Jim
> "Eric Nguyen" <nguyenq_at_supernet.ca> wrote in message
> news:lm7V7.10999$xB4.1593624_at_brie.direct.ca...
> > Hi,
> > Can someone explain to me why Oracle needs 2 hours to drop a user ?
 I
> > have Oracle 8.1.7 on unixware , drop a user with 100 tables and 200
 indexes
> > takes normally 2 hours, same set up in Linux takes approx 15 minutes.
 Both
> > system have approx 700Meg SGA and 500 Meg Rollback segments on a 2GIG
 Ram
> > machines.
> >
> > I mean 2 hours is exetremely long, What should I verify in my setup
 ?
> >
> > Thanks for your help.
> >
> >
> >
> >
> >
> >
>
>
Received on Sun Dec 23 2001 - 21:45:16 CET