Drop user takes too long

From: Eric Nguyen <nguyenq_at_supernet.ca>
Date: Sat, 22 Dec 2001 17:09:33 -0500
Message-ID: <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 Sat Dec 22 2001 - 23:09:33 CET

Original text of this message