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
LEARN ABOUT SUSE
apache::session::oracle
Session::Oracle(3) User Contributed Perl Documentation Session::Oracle(3)
NAME
Apache::Session::Oracle - An implementation of Apache::Session
SYNOPSIS
use Apache::Session::Oracle;
#if you want Apache::Session to open new DB handles:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:sessions',
UserName => $db_user,
Password => $db_pass,
Commit => 1
};
#or, if your handles are already opened:
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh,
Commit => 1
};
DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the
documentation for Apache::Session::Store::Oracle for more details.
USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to
either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have
adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order
to make you think about this problem.
This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default
maximum is 8 KB.
AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>.
SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session
perl v5.12.1 2007-09-28 Session::Oracle(3)