| 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: Anyone implented compiled PL/SQL?
Ellis,
Did you ever try to build the database with plsql set to "native" (in
init file used to build sql)?
If you did, were there any problems compiling "oracle supplied"
packages?
And also, did you see any "overall" performance improvements (since
"oracle supplied" packages shouldn't have to be "interpreted" any more)?
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ellis R. Miller
Sent: Wednesday, July 28, 2004 3:20 PM
To: oracle-l_at_freelists.org
Subject: RE: Anyone implented compiled PL/SQL?
Igor,
Thanks for the clarification. You are correct. There is simply no longer
a
need to set the Oracle 9i init parameters pointing to the c compiler and
the
dependence on the make utility has been eliminated. In short, there has
to
be a c compiler installed but in 10G NCOMP this, as you stated, should
be
transparent to the DBA.
Ellis
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Igor Neyman
Sent: Wednesday, July 28, 2004 12:54 PM
To: oracle-l_at_freelists.org
Subject: RE: Anyone implented compiled PL/SQL?
Regarding external C compiler.
It's still required. Only it's done "behind the scene".
When you are creating plsql code in "native" mode, Oracle is smart
enough to find C compiler and use it (i.e.: on Win platform it looks
into registry for
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.0\...), so no
"additional" steps required.
If C compiler isn't installed, you'll be getting appropriate error message.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ellis R. Miller
Sent: Wednesday, July 28, 2004 11:16 AM
To: oracle-l_at_freelists.org
Subject: RE: Anyone implented compiled PL/SQL?
.....................................................
.....................................................
.....................................................
On a final note, the Oracle 10G NCOMP is much easier to configure: do
not
require an external c compiler, such as gcc, or make utility. In
essence,
only have to set one parameter. Here are some really basic notes on
NCOMP in
Oracle 10G:
Which Oracle parameters are relevant to native compilation?
.....................................................
.....................................................
.....................................................
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Jul 28 2004 - 14:13:51 CDT
 |
 |