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