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)
Check Out this Related Man Page
Apache::Session::Postgres(3pm) User Contributed Perl Documentation Apache::Session::Postgres(3pm)NAME
Apache::Session::Postgres - An implementation of Apache::Session
SYNOPSIS
use Apache::Session::Postgres;
#if you want Apache::Session to open new DB handles:
tie %hash, 'Apache::Session::Postgres', $id, {
DataSource => 'dbi:Pg:dbname=sessions',
UserName => $db_user,
Password => $db_pass,
Commit => 1
};
#or, if your handles are already opened:
tie %hash, 'Apache::Session::Postgres', $id, {
Handle => $dbh,
Commit => 1
};
DESCRIPTION
This module is an implementation of Apache::Session. It uses the Postgres backing store and no locking. See the example, and the
documentation for Apache::Session::Store::Postgres 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.
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::Postgres(3pm)
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, I am new to forum, I am wondering anyone can help me ?
Is there a command to tell whether a particular process is already inactive, so I can issue a kill command to end it. I have been encountering scenerio whereby users always shutdown abnormally by closing the windows, and my application... (12 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...
Does anyone know how to pipe the output of a "select" statement from a call to Oracle to a file?
ANy ideas woule be greatly appreciated!
Code is as below...
echo "producing CSV file 2..."
sqlplus -s $username/$password@$database<<EOF
set serveroutput on size 1000000
set... (13 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)
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)
Hi,
I'm a junior programmer. This is my first post here, please excuse me if that's not the correct place :)
For days now I've been trying to install Oracle DB 12c R2 on Ubuntu 18.04. I'm at my wits' end. The software itself installs fine and a Listener can be started but I can't start... (15 Replies)