Apache::Session::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Oracle(3pm)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.10.1 2010-10-18 Apache::Session::Oracle(3pm)
Check Out this Related Man Page
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)
Through a shell script ...
I am invoking sql plus..
Code is as follows...
echo " set feedback off verify off pagesize 0
select column from table " | sqlplus -s/@dbname | read var_col
Now if oracle throws an exception for above select statement ...then how can i catch it ?... (15 Replies)
Hi,
Iam calling 3 sql scripts through one shell script 'rmia.sh'.
Till now this was working fine, but last time while calling the SQL scripts,
Oracle was down. But amazingly the exit status was '0' (success)!!!
Below is the shell code:
#!/usr/bin/ksh -x
assign_file asql a.sql 1... (15 Replies)
Hi all!
I have one big problem! Today, I do not log in my server which contains a production Oracle Database, however, it still runs. No console, no telnet, no SSH is to be allowed. I do not understand, really.
Google searching, I found that, one action can cause it. It is described like... (12 Replies)
I have a .net application that works with an Oracle database in HP-Unix.
Problem: .net application creates Oracle processes that don't close. By default Oracle can work with 200 active processes and after that crashes. I doubled this number and I don't have to many problems.
I want: to... (12 Replies)
I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message.
$ sqlplus
sqlplus: not found
I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Hi everyone, newbie forum poster here. I'm an Oracle DBA and I require some guidance from the Unix gurus here about how to pinpoint where a problem is within a Solaris 9 system running on an 8 CPU Fujitsu server that acts as our Oracle database server. Our sysadmins are trying their best to... (13 Replies)
Hi,
Does any one know how to configure email notifications (to exchange) in Oracle Enterprise Manager 11g OPS Center?
I have gone through the documentation and have done everything it asked, but still no notifications via email. I get the following error:
At the OS level i tried sending email... (20 Replies)
hello everyone,
Our company is using a sun E4900 cluster. Last day, all instances of Oracle database has been suddenly stopped whitout treggring any alarm for a 15 minutes and has started alone without any action from the DBA.
Can anyone explain me what's the origin of this problem ?
Thanks (11 Replies)
I'm working as sys admin on a db server that's currently serviced by 30x 15k disks and is getting about 3000-3500 iops. A consultant has suggested we can replace that with 10x 10k disks and 700g of flash. He has not performed any testing to determine the working set, growth patterns, etc... and I... (11 Replies)
Some time ago I bought an old microchannel RS/6000 39H as a hobby toy. I mostly deal with newer Sun/Oracle equipment so I'm a bit out of my element.
The machine was running, AIX 4.1.3 I believe. Using it via IBM terminal. I stored it for what was apparently too long, and now it stalls out... (11 Replies)
How do I set ORACLE_HOME location?
When I type echo $$ORACLE_HOME it gives me
/u01/app/oracle//product/10.2.0/dbhome_1
which has been deleted.
I just installed Oracle 11g and this is supposed to be a new oracle home
/u01/app/oracle/product/11.2.0/dbhome_1
Any help from the community... (21 Replies)
I could have sworn I posted on this issue earlier a couple of weeks ago but now cannot find the thread to add some updated info so I guess I'll start from scratch.
Running on Oracle Linux 5.6, 64-bit.
I have a weekly job that does an ftp 'mget' to copy a bunch of files from a production... (12 Replies)
Hi. I'm trying to find the best way to locate the latest version of Oracle on a Linux host.
There could be multiple SW installs or there could be none. It could be a client or a full RDBMS installation. I need to find and set the environment in order to run the sqlplus binary. Rather than just... (14 Replies)