[HPADM] [SUMMARY]: Is ANSI C required for good Oracle performance ?

From: Rama, Subu (srama@northropgrumman.com)
Date: Fri Jan 31 2003 - 10:01:17 EST


First, a "Thank you" to:
   Eef Hartman
   Corne Beerse
and others who took the trouble to reply to me.

No, it is NOT necessary to have an ANSI compiler installed for Oracle 9i.
The Oracle 9i R2 makefiles are so structured that the bundled cc is only
used
to pass the objects to ld. The linker is no different on a plain vanilla
system
as compared to one where the compiler is installed.

It's somewhat unsettling to see all those warnings in install/make.log after
an Oracle 9i
install but that's life with Oracle !

Of course, if you are using the same system to compile Pro*C stuff, then you
need ANSI C
for the optimizations.

Thank you again
Subu

-----Original Message-----
From: Rama, Subu
Sent: Thursday, January 30, 2003 10:19 AM
To: hpux-admin@dutchworks.nl
Subject: [HPADM] Is ANSI C required for good Oracle performance ?

I see that Oracle actually links its executables using the installed cc
after the install.

If the HP's ANSI-C compiler kit is not on the system, it uses the bundled cc
and I get warnings such as
  (Bundled) cc: warning 480: The +O2 option is available only with the
C/ANSI C product: ignored
  (Bundled) cc: warning 480: The +Omultiprocessor option is available ...
  (Bundled) cc: warning 480: The +Oentrysched option is ...
  (Bundled) cc: warning 480: The +Onolimit option is ...
  (Bundled) cc: warning 480: The +ESlit option is ..
  (Bundled) cc: warning 480: The +Olibcalls option is ..

How does not having an ANSI compiler affect the performance of Oracle on
HP-UX 11.00 ?
(Oracle 9i Release 2)

Appreciate all your help.

Thank you
Subu

--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact
majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner:
owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse
only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse &
search)
--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)


This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:25 EDT