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
cmdk(7D) Devices cmdk(7D)
NAME
cmdk - common disk driver
SYNOPSIS
cmdk@target, lun : [ partition | slice ]
DESCRIPTION
The cmdk device driver is a common interface to various disk devices. The driver supports magnetic fixed disks and magnetic removable
disks.
The block-files access the disk using the system's normal buffering mechanism and are read and written without regard to physical disk
records. There is also a "raw" interface that provides for direct transmission between the disk and the user's read or write buffer. A sin-
gle read or write call usually results in one I/O operation; raw I/O is therefore considerably more efficient when many bytes are transmit-
ted. The names of the block files are found in /dev/dsk; the names of the raw files are found in /dev/rdsk.
I/O requests to the magnetic disk must have an offset and transfer length that is a multiple of 512 bytes or the driver returns an EINVAL
error.
Slice 0 is normally used for the root file system on a disk, slice 1 as a paging area (for example, swap), and slice 2 for backing up the
entire fdisk partition for Solaris software. Other slices may be used for usr file systems or system reserved area.
Fdisk partition 0 is to access the entire disk and is generally used by the fdisk(1M) program.
FILES
/dev/dsk/cndn[s|p]n block device (IDE)
/dev/rdsk/cndn[s|p]n raw device (IDE)
where:
cn controller n
dn lun n (0-7)
sn UNIX system slice n (0-15)
pn fdisk partition(0)
/kernel/drv/cmdk 32-bit kernel module.
/kernel/drv/amd64/cmdk 64-bit kernel module.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Architecture |x86 |
+-----------------------------+-----------------------------+
SEE ALSO
fdisk(1M), mount(1M), lseek(2), read(2), write(2), readdir(3C), scsi(4), vfstab(4), attributes(5), dkio(7I)
SunOS 5.10 9 Oct 2004 cmdk(7D)