01-12-2014
IBM AIX Internal HDD vs SAN HDD and Oracle
Hi Folks,
I am facing an issue with the performance.
P4 with 1 processor and 16 GB RAM and SAN HDD = Oracle report takes 25 minutes
P5 with 2 processors and 16 GB RAM internall HDD with LPAR = Oracle Report takes 1 hour 15 minutes ( please note I have assigned all the max processors and memory to this LPAR and this is the only LPAR active )
* How can I measure and troubleshoot to find out what is causing the delay ?
Any help and insight would be appreciated
10 More Discussions You Might Find Interesting
1. HP-UX
Hi,
My HP-UX has some errors to wake up and one of them are:
/dev/vg00/rlvol4 BAD CYLINDER GROUPS
I have thought that my hdd has physical problems, my question is:
Exists a program to check the hdd physically and to repair it...
Thanks.... (0 Replies)
Discussion started by: efrenba
0 Replies
2. Ubuntu
Umm How can I get the Knoppix can be booted off my hard drive instead of the CD. I dont like using the CD. :confused: (4 Replies)
Discussion started by: shade11
4 Replies
3. Solaris
Hi theres
I am quite new to solaris, I have 40GB HDD in which I have created only 10 GB partition & installed solaris 10. Now I want to add another 10GB from remaining 30GB space. I tried this with format utility but I get stuck after I create fdsik partition. After creating this I cant... (1 Reply)
Discussion started by: i_mroy
1 Replies
4. UNIX for Dummies Questions & Answers
I am adding a new HDD to a Unix Sco Release 5 webserver.
I consider myself a windows pro. However, growing up in the late 90's means I have little Unix knowledge. I know the HDD has to be mounted and formatted correctly. Can anyone give me any advice on this?
A dummy's guide to installing a... (5 Replies)
Discussion started by: jeffreydavisjr
5 Replies
5. AIX
Hi All,
I would like to share this incident that happened the other day.
I have a question with this, https://www.unix.com/aix/64921-create-new-vg-san-rename-fs.html
And I thought it's related to the above link but the problem was the ibm san 4300 cache battery was dead and I need to click... (2 Replies)
Discussion started by: itik
2 Replies
6. UNIX for Dummies Questions & Answers
Over the last few months the HDD spins louder and louder, so I fiqured its time to replace the HDD. Its been running 24/7/365 since 98 :eek:. yes i said since 98 :D
I have an IBM system 43P Model 240. 233 MHz. running AIX Version 4.
The current HDD is an IBM DGHS COMP IEC -950
FRU PN#... (5 Replies)
Discussion started by: Chevy89rocks
5 Replies
7. Solaris
All,
I am a complete grasshopper when it comes to Unix, so here goes. I have a Solaris 9 server, running two 36GB HDD in a mirrored configuration. I am running low on disk space, and have purchased an additional 145GB HDD. Can anyone point me in the direction to some documentation on how to... (1 Reply)
Discussion started by: ptvenom427
1 Replies
8. UNIX for Dummies Questions & Answers
I need to get an external HDD for a SUN server running Solaris 10. The Western Digital that I have will not recognize and when I went looking for drivers WD only has them for MAC and Windows. Is there a External HDD that is known to work with Unix? (24 Replies)
Discussion started by: SIFT3R
24 Replies
9. AIX
Hi,
This is follow up to the post https://www.unix.com/aix/233361-san-disk-appearing-double-aix.html
When I connected Pseries Machine HBA Card ( Dual Port ) directly to the SAN Storage DS4300 , I was able to see Host Port Adapter WWN numbers , although I was getting this message... (2 Replies)
Discussion started by: filosophizer
2 Replies
10. UNIX for Beginners Questions & Answers
Greeting All
Diag tool HDD clone SCO 5 + Oracle 7 DB ( IBM T30 )
I am new to this forum and my knowledge on computers OS is average .
I have just acquired a factory diag tool for BMW/RR/MINI from a retired mechanic. Its runs on a IBM T30 laptop with a Unix/Oracle DB system. Sco 5... (8 Replies)
Discussion started by: bmw635
8 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)