Re: Drop user takes too long
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 22 Dec 2001 22:45:50 GMT
Message-ID: <H18V7.1929$6p.15889_at_rwcrnsc54>
Date: Sat, 22 Dec 2001 22:45:50 GMT
Message-ID: <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
> 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 Sat Dec 22 2001 - 23:45:50 CET