RE: 5 gb rbs on Windows

Yes, you did not specify a max file size there fore it went to block_size*4194303.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: schauss_at_att.net [mailto:schauss_at_att.net]=20 Sent: Tuesday, October 26, 2004 4:55 PM
To: oracle-l_at_freelists.org
Subject: 5 gb rbs on Windows

Environment:

Windows XP professional
Oracle 8.1.7.4

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

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

The script generated looked like:

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

Does this make sense?

Thanks,
Peter Schauss
--

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

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 26 2004 - 16:49:48 CDT