Hi,
please show output of
and
commands and
and let us know if this is a oltp or rather a data warehouse database. In addition the output of
could be helpful.
In addition you have
set - do you use large pages - in any other case that is real bad habit and on AIX rather couterproductive in most cases.
Kind regards
zxmaus
Hi @all
Who's able to help me?
I've a running Oracle DB on AIX 4.3.3.
You've also an Oracle Client running for this.
So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things,
but it doesn't work. Thanks a lot!
Regards
Oliver :( :( (4 Replies)
Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run"
and i can't start the installation of ORACLE 9i...
see you later (1 Reply)
Hi All,
I need to update some AIX servers from 5.2 to 5.3 OR 6.1 .
The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 .
I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Please read my issue!
My old server using:
- AIX system operating (5300-05-CSP-0000)
- WebSphere 6.1.0.21 (Fix Pack 21)
After I've upgraded version AIX
- AIX system operating (5300-09-02-0849)
- WebSphere 6.1.0.21 (Fix Pack 21)
I have 1 issue when I access home page:
"Error... (0 Replies)
Hi All,
I have this fix for AIX (5300-06-06-0811) and i need to install it.
How can i do this?
What are the prerequisites for this fix?
Thanks (1 Reply)
Hi,
we need to upgrade from aix 5.3 oracle 9 to aix 6.1 oracle 11.
Our base interest is on vmo and disk setup
On aix 5.3 we change lru_file_repage to 0.
We split disk layout ( emc cx4 ) to tree volume groups:
- one for data base files ( one filesystem over two lun/hdiskpower, block size... (5 Replies)
I'm having this trouble when smit update_all.
==========================================================
MISSING REQUISITES: The following filesets are required by one or more
of the selected filesets listed above. They are not currently installed
and could not be found on the... (5 Replies)
Hello All,
I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO.
They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache.
To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies
LEARN ABOUT DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_type
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)