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 DEBIAN
apache::session::store::oracle
Apache::Session::Store::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Store::Oracle(3pm)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.10.1 2010-10-18 Apache::Session::Store::Oracle(3pm)