Re: Rollback segment space allocation
Date: 12 Feb 94 15:03:23 +1100
Message-ID: <1994Feb12.150323.1_at_cbr.hhcs.gov.au>
In article <2jfh7i$qfg_at_netserver.univ-lille1.fr>, noel_at_omega.univ-lille1.fr (Yves Noel) writes:
>
> In article <2jeo0p$b6_at_nwfocus.wa.com>, Mike Dickson <mdickson_at_halcyon.com> writes:
> |>The other day I dropped and recreated my rollback segments. I created
> |>my tablespace with 70M of space, and then I created 10 rollback segments
> |>using the command:
> |>
> |>create rollback segment r? tablespace rbs_tsp
> |>storage (initial 3M next 3M maxextents 2 pctincrease 0)
Rollback segments default to their MINIMUM of TWO EXTENTS so in your case you have ALSO specified that no growth can occur; are you sure you want to do this?
> |>
> |>I then stopped and started the database, using the new rollback segments.
> |>I immediately ran a space usage report on the tablespace, which reported
> |>that 60M were allocated. I was under the impression that when an object
> |>was created, only the initial extent was pre-allocated. Since this report
> |>was run before anyone could use the rollback segments. How come 60M were
> |>allocated, rather than 30M?
See above MINIMUM of 2 extents.
> |>
> |>BTW, this is a v6 database.
Same MINIMUM for ALL versions so far.
> |>Mike Dickson | mdickson_at_halycon.com
> |>Dir, Information Systems | (512)459-1000 voice
> |>Lutheran Social Services |
> |>408 W 45th | "When the going gets weird,
> |>Austin, Texas USA 78751 | the weird turn pro"
> |>
> Are you really sure you've used maxextents 2 and not MINEXTENTS 2 ???
> Because minextents 2 allocates (3 + 3)*10 = 60M.
This is what's happened but it's because his MINEXTENTS defaults to 2.
> --
> ______________________________________________________________________________
>
> Yves NOEL - Database Administrator
> C.I.T.I. (batiment M4) Mail : noel_at_univ-lille1.fr
> Universite des Sciences & Technologies de Lille Phone : (33) 20.43.42.70
> 59655 Villeneuve d'Ascq Cedex - FRANCE Fax : (33) 20.43.66.25
> ______________________________________________________________________________
>
> _/_/_/_/ _/_/_/_/ _/_/_/_/ _/_/_/_/ I use ORACLE v6.0.36
^^^^^^^^^^^^^^^^^^^
I support ORACLE v6.0.34, 6.0.37, 7.0.12, 7.0.13, and 7.0.15 ... shoot me now!
> _/_/ _/_/ _/_/ _/_/ on
> _/_/ _/_/ _/_/ _/_/ DEC RISC ULTRIX v4.3
> _/_/_/_/ . _/_/_/_/ . _/_/ . _/_/_/_/ . **
> ______________________________________________________________________________
-- Bruce... pihlab_at_cbr.hhcs.gov.au "If you swallow a live frog first thing in the morning ... Nothing worse will happen to either of you for the rest of the day." ******************************************************************* * Bruce Pihlamae -- Database Administration * * Commonwealth Department of Human Services and Health * * Canberra, Australia (W) 06-289-7056 * ******************************************************************* * These are my own thoughts and opinions, few that I have. * *******************************************************************Received on Sat Feb 12 1994 - 05:03:23 CET