| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Pro-C differences VMS to Unix
You may be comparing apples to oranges here.
I have had ex-VMS people tell me that VMS is a screamer. So VMS to Unix is one issue.
You are also comparing v8.0.5 to v8.1.7.3. I haven't done a time comparison/benchmark for some years but when I was a developer I notice that my Pro*C programs got slower and slower as I moved from v6.0 to 7.1 to v7.2 to v7.3 to v8.0. The Pro*C I was dealing with were looping batch update programs with array fetches. I always attributed the slowing to the fact that the Oracle kernel keeps getting fatter and fatter and therefore had more hoops to jump through/past even though my programs didn't need the extra bells and whistles.
Lastly, I have seen (on this list) and heard elsewhere complaints that "when I switched from 32 bit Oracle to 64 bit Oracle the db got slower". I don't remember anybody ever explaining it, I don't know if it's true, but it might apply to your situation.
BOL and please keep the list updated on what you find out.
Brian P. MacLean
Oracle DBA, OCP8i
"Toepke, Kevin
M" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
<ktoepke_at_trile cc:
giant.com> Subject: RE: Pro-C differences VMS to Unix
Sent by:
root_at_fatcity.c
om
03/29/02 09:44
AM
Please respond
to ORACLE-L
One new thing you can do with PRO*C 8i is to use the The PREFETCH Precompiler Option if your application is processing a lot of data in a sequential manner (and you don't already do bulk fetches)
Caver
-----Original Message-----
From: Stephen Andert [mailto:StephenAndert_at_firsthealth.com]
Sent: Friday, March 29, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Pro-C differences VMS to Unix
Hey all,
I know there are developers lurking out there as well as dba's that
have a great deal of development experience that could help me to help
our developers on this project.
We have an old application that is running on a VMS machine. The
Oracle version there is 8.0.5. Our development group is porting this
to Unix (Tru64 5.1). We are planning on deploying this with Oracle
version 8.1.7.3 as the client. The database in test is currently
8.1.7.3 and production will be upgraded to 8.1.7.3 soon.
The question I have is this: The development VMS and Unix machines
are comparably equipped, but application performance from the VMS
machine is much better than from Unix. There have been no changes to
the application other than being recompiled in the new OS. What can
anyone tell me about changes that should/could be done to improve
performance when moving from VMS (Oracle 8.0) to Unix (Oracle 8.1)?
Thanks in advance for any advice or suggestions.
Stephen Andert
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Brian_P_MacLean_at_eFunds.Com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 29 2002 - 12:28:29 CST
 |
 |