12-17-2002
You really need to ask Oracle this question. It could mean several things.
The maximum number of bytes that can be transferred in a single read or write system call is SSIZE_MAX which is 2 gigabytes in 11.0. A literal interpretation of your question would mean that you are looking for this value.
I am not a database expert, but I'm guessing that Oracle actually wants the maximum size of a physical disk operation. This value would come into play if you are giving Oracle raw disk sections that it will access directly via character special files. A disk driver written by HP will always transfer MAXPHYS bytes or less to or from the disk in exactly one disk operation. If you are using a disk drive that HP officially supports, that disk operation is guaranteed to complete even if the disk drive loses power during the operation. On 11.0, MAXPHYS is 256 kilobytes.
There are several other maxima that could loosely meet your definition, but you probably want one of the values mentioned above. And you should look up SSIZE_MAX (/usr/include/limits.h) or MAXPHYS (/usr/include/machine/param.h) on your system to be sure that you are getting the correct values.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
What is the maximum amount of characters that you can have in a varible name in the ksh shell? (1 Reply)
Discussion started by: lesstjm
1 Replies
2. Programming
We have Sun OS 5.9 we are doing a backup process (ProC program) that uses the function...
fprintf(fp,"%s;%s;%s;%s;%s;%ld;%ld;%ld;%ld;%s;%s;%s;%d;%s;%s;%s;%ld;%s;%s;%s;%ld;%ld;%s;%ld;%s;%ld;%s;%s;%c%c",x_contrno, x_subno, x_b_subno,x_transdate,x_last_traffic_date,BillAmt_s, x_billamount_int,... (10 Replies)
Discussion started by: atiato
10 Replies
3. AIX
hello
i would like to create a volume group with 2200 Go (with pp size= 64)
it is possible, or it is too big ?
thank you (2 Replies)
Discussion started by: pascalbout
2 Replies
4. UNIX for Advanced & Expert Users
Does anyone know a way to determine the maximum filesize on a file system on Solaris, HP-UX, AIX, Linux, and OSF1 using the command line?
TIA (2 Replies)
Discussion started by: dknight
2 Replies
5. Solaris
I wants to ask that what is the max size of file that we can create in the unix file system. (2 Replies)
Discussion started by: sameerghogre
2 Replies
6. UNIX for Advanced & Expert Users
i want to know what is the maximum file size supported by linux with ext3 file system. (1 Reply)
Discussion started by: nagalenoj
1 Replies
7. Solaris
I have a new Netra T5220 that came preinstalled OS 10. The purpose is to be a backup server to store images of other Server Blades. There are three systems that will be storing their backups. Per engineering documents and with the vendor system it is determined that we needed somewhere around 300... (3 Replies)
Discussion started by: udubya
3 Replies
8. UNIX for Advanced & Expert Users
Hi Gurus,
I am unable to send a file which size is more than 10mb through the "sendmail" command in unix.
I searched from internet and followed the path specified over there "/etc/mail/sendmail.cf" and too "/etc/mail/main.cf" but found in those files below lines.
# maximum message size... (1 Reply)
Discussion started by: sanjay.login
1 Replies
9. Shell Programming and Scripting
Hi
I have a list of 2000 records with multiple entries and I want to get the max size for each entry
ABC 1
ABC 2
ABC 3
ABC 4
DEF 1
DEF 2
DEF 2
DEF 2
DEF 2
... (9 Replies)
Discussion started by: Diya123
9 Replies
10. Shell Programming and Scripting
Hi
I know that a perticular direxctory is cosuming max space .
Filesystem 1K-blocks Used Available Use% Mounted on
nfsfi02:/vol/fivol2/Dir2/dir
104857600 92671400 12186200 89% /fs/dir
I want to know which sub directory is consuming max... (4 Replies)
Discussion started by: ptappeta
4 Replies
HP(4) Kernel Interfaces Manual HP(4)
NAME
hp - RH-11/RP04, RP05, RP06 moving-head disk
DESCRIPTION
The octal representation of the minor device number is encoded idp, where i is an interleave flag, d is a physical drive number, and p is a
pseudodrive (subsection) within a physical unit. If i is 0, the origins and sizes of the pseudodisks on each drive, counted in cylinders
of 418 512-byte blocks, are:
disk start length
0 0 23
1 23 21
2 0 0
3 0 0
4 44 386
5 430 385
6 44 367
7 44 771
If i is 1, the minor device consists of the specified pseudodisk on drives numbered 0 through the designated drive number. Successively
numbered blocks are distributed across the drives in rotation.
Systems distributed for these devices use disk 0 for the root, disk 1 for swapping, and disk 4 (RP04/5) or disk 7 (RP06) for a mounted user
file system.
The block files access the disk via the system's normal buffering mechanism and may be read and written without regard to physical disk
records.
A `raw' interface provides for direct transmission between the disk and the user's read or write buffer. A single read or write call
results in exactly one I/O operation and therefore raw I/O is considerably more efficient when many words are transmitted. The names of
the raw files conventionally begin with an extra `r.' In raw I/O the buffer must begin on a word boundary, and raw I/O to an interleaved
device is likely to have disappointing results.
FILES
/dev/rp?, /dev/rrp?
SEE ALSO
rp(4)
BUGS
In raw I/O read and write(2) truncate file offsets to 512-byte block boundaries, and write scribbles on the tail of incomplete blocks.
Thus, in programs that are likely to access raw devices, read, write and lseek(2) should always deal in 512-byte multiples.
Raw device drivers don't work on interleaved devices.
HP(4)