Re: rollback segs question

From: <satar_at_my-dejanews.com>
Date: Wed, 14 Oct 1998 23:36:56 GMT
Message-ID: <703cio$n7e$1@nnrp1.dejanews.com>

Even though there is no transaction activity taking place, rollback segments do take up room. They are at thier Optimal size when there is no transaction activity. As long as you have other public rollback segments located on another tablespace, then you will be OK as long as they can meet the stress of your system. But why do you want to drop and re-create? If you are using version 7.2 or higher, you can resize the datafiles to be bigger. You can also just add another datafile to the tablespace to make it bigger.

Good Luck,
Satar

In article <7030f0$jgg$1_at_news3.infoave.net>, "Larry Schenavar" <schenavar_at_northstate.net> wrote:
> I have a tablespace used exclusively for rollback segs that shows full even
> with no transaction activity. Can a rollback tablespace be dropped and
> rebuilt without any serious problems with the database?
>
> -- Thanks
>
> --
> ==============================
> Larry Schenavar
> Infrastructure Specialist /DB
> Electronic Data Systems, Inc
>
> Email: schenavar_at_northstate.net
> ==============================
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 14 1998 - 18:36:56 CDT