Re: Q: Shirinking rollback segments.....
Date: 1995/07/27
Message-ID: <milapier.8.000B8355_at_ge.hydro.qc.hq>#1/1
In article <9507140038.AA11549_at_softex1.cps.softex.br> softdes_at_cps.softex.br (Software Design Informatica Ltda) writes:
>From: softdes_at_cps.softex.br (Software Design Informatica Ltda)
>Subject: Q: Shirinking rollback segments.....
>Date: 13 Jul 1995 19:51:24 -0500
>Hi folks,
>do you know exactly when Oracle decides to shirink a rollback segment to
>the optimal size???
>Please, answer Cc: cnetto_at_cps.softex.br
>Regards,
>Carlos Netto
>cnetto_at_cps.softex.br
>--
>Software Design Informatica Ltda
>Client Server Consultants/Developers
>Oracle, SQLWindows, C++, MS-Windows & Unix
>Campinas - Brazil
>Phone: +55.192.54.6518
>Fax: +55.192.54.6518
It will shrink the RB (rollback) when at the beginning of a new transaction. It will check if it can shrink (did I overpass the shriking limits) it the limit is pass it will shrink it.
Michel Lapierre. DBA Received on Thu Jul 27 1995 - 00:00:00 CEST