RE: Anyone implented compiled PL/SQL?

  • From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Jul 2004 15:17:16 -0400

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@xxxxxxxxxxxxxx



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ellis R. Miller
Sent: Wednesday, July 28, 2004 3:20 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Igor Neyman
Sent: Wednesday, July 28, 2004 12:54 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ellis R. Miller
Sent: Wednesday, July 28, 2004 11:16 AM
To: oracle-l@xxxxxxxxxxxxx
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?
---------------------------------------------------------------
1. plsql_native_library_dir -- create directory to hold shared libraries
2. plsql_native_library_subdir_count -- optional
3. plsql_code_type -- set at the database level or session

.....................................................
.....................................................
.....................................................


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: