Re: extremely long

Create a massive rollback segment, then in SQL*Plus, do a:

set transaction <???> <specify rollback seg to use>; commit;

(sorry, I cant quite remember the syntax)

then start the drops.

This will force the session to use the large rollback seg.

Make sure you dont have archive logging ON, if your archive_dest becomes full the DB will hang.

Apart from that, kill all jobs on server, clear out the rollback segs and temp seg, startup DB in restricted mode and start the drops again.

howard lee wrote in message <6q6i7i$f5t2_at_news.hk.linkage.net>...
>hi
>
>where a try to drop packages from my oracle server, it hangs up after i
>deleted several packages. all i can do is to shutdown the instance and
>start it up again. then i can survive for serveral more deletions before
>hanging up again. i have already increased temp segment and rbs to 100M
>each. but nothing improved.
>
>could anyone give me some advice?
>
>thanks
>howard
>
>
Received on Tue Aug 04 1998 - 04:12:27 CDT