RE: 5 gb rbs on Windows

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 26 Oct 2004 17:01:16 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9B61@AABO-EXCHANGE02.bos.il.pqe>

I'd expect that to create 200MB file.

But, if, after creating that tablespace, you then created a bunch of rollback segments, that creation of rollback segments could have caused the tablespace to grow, perhaps as large as 5GB.

How many rollback segments exist in this tablespace? How large are they?

-Mark

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of schauss_at_att.net
> Sent: Tuesday, October 26, 2004 4:55 PM
> To: oracle-l_at_freelists.org
> Subject: 5 gb rbs on Windows

>=20
>=20

> Environment:

>=20

> Windows XP professional
> Oracle 8.1.7.4

>=20

> Using Database Configuration Assistant, following my software vendor's
> instructions, I entered the following values for on Rollback tab:

>=20

> Name: RBS
> Size (mb): 200
> Autoextend ON
> Min Extent(kb): 10240
> Next (kb): 10240
> Storage:
> Initial (kb): 1024
> Next (kb): 1024
> Min:20

>=20

> The script generated looked like:

>=20

> REM ********** TABLESPACE FOR ROLLBACK **********
> CREATE TABLESPACE RBS DATAFILE=20
> 'd:\oracle\oradata\IPDTEST\rbs01.dbf' SIZE 200M REUSE
> AUTOEXTEND ON NEXT 10240K
> MINIMUM EXTENT 10240K
> DEFAULT STORAGE ( INITIAL 1024K NEXT 1024K MINEXTENTS 20=20
> MAXEXTENTS 4096);

>=20

> The resulting rbs.dbf file was 5 gb.

>=20

> Does this make sense?

>=20

> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 26 2004 - 15:57:13 CDT