Re: Larger than 2G Raw partitions on 4.2 Dynix

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1996/12/21
Message-ID: <mjrE2rL9x.2H0@netcom.com>#1/1

In article <851031942.2636_at_dejanews.com>,  <vidya.shankar_at_firstdatacorp.com> wrote:
>Hello All,
>
>Platform : 4.2 Dynix on Sequent SE 80.
>RDBMS : Oracle 7.3.2.3
>
>Problem :
>
>We are in the process of creating a 700G + database on the above setup.
>The system contains raw devices of 1 G, 2 G, 3 G, 4 G, 5 G, 6 G, 8 G , 13
>G and 15 g file sizes.
>
>Please see the table below and the problem is self-evident.
>
>Concatenated File Size Creatable Size Comment
>/Striped in Mb
>
>Both 1 G 999
>Striped 2 G 1999
>Striped 3 G 2047 2048 - 1
>Concatenated 4 G 2047 2048 -1
>Both 5 G 4999
>Striped 6 G 5999
>Concatenated 8 G 6143 3 * 2048 -1
>Striped 13 G 12999
>Striped 15 G 14335 7 * 2048 -1
>
>For some reason, we are unable to create 2999m, 3999m, 7999m,
>14999m on 3G, 4G, 8G and 15 G raw devices respectively.
>

If I read you post correctly you seem to be having problems creating files of greater than 2 GB. This is a typical limit with 32 bit Oracle. This should not be a big deal since typically you get 1022 open files at 2 GB per file for a total of 2 TB of data. This is typically enough for 700 GB of raw data base data (not indexes)

hope this helps

Mark Rosenbaum			Otey-Rosenbaum & Frazier, Inc.
mjr_at_netcom.com			Consultants in High Performance and
(303) 727-7956			Scalable Computing and Applications
POB 1397			ftp://ftp.netcom.com/pub/mj/mjr/resume/

Boulder CO 80306 Received on Sat Dec 21 1996 - 00:00:00 CST