Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop user slow

390968Jan 31 2006 — edited Jan 31 2006
Hi,
We have an application in development mode right now. We currently have oracle installed locally on each developer's machine. The first thing we do when we "start" the application is drop the oracle user (using a more priveleged user).
drop user clm cascade;
This is just our approach to start clean. We've got a couple procedures, triggers, etc. Then we recreate the user and all of their objects and initialize the database with some data. The problem I'm having is that on my machine (the other 2 developers do not have this problem), this drop user command takes over 1 minute. The whole time the command is running, I can see the hard drive running like crazy. I assume it's doing some backups in case it needs to do a rollback. However, I'd like to throw these precautions out the window. I've read up on the recycle bin and I don't think it's that because it isn't turned on. I've tried to learn as much as I can about other things (like initialization parameters) that may be causing this problem, but I'm getting confused. I tried creating a separate tablespace for that user and then dropping that first, but that still didn't help. Then I saw that the drop table command has an optional purge keywork. However, drop user doesn't have this. Does anyone know what else I can try?
Thanks
Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2006
Added on Jan 31 2006
4 comments
2,172 views