Re: Rollback segment space allocation
Date: 11 Feb 1994 08:56:18 GMT
Message-ID: <2jfh7i$qfg_at_netserver.univ-lille1.fr>
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)
|>
|>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?
|>
|>BTW, this is a v6 database.
|>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.
-- ______________________________________________________________________________ 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 _/_/ _/_/ _/_/ _/_/ on _/_/ _/_/ _/_/ _/_/ DEC RISC ULTRIX v4.3 _/_/_/_/ . _/_/_/_/ . _/_/ . _/_/_/_/ . ** ______________________________________________________________________________Received on Fri Feb 11 1994 - 09:56:18 CET