RE: Anyone implented compiled PL/SQL?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jul 2004 16:55:50 -0400
Thanks to everyone who contributed to this thread, especially Ellis for
all the detailed advice and Juan for the links to the excellent
articles, and thanks to Roger Schrag for the excellent tutorial.
As it turns out, it took me all of about 5 minutes to initially
configure and get a small HELLO_WORLD proc natively compiled. I then
did a full recompile of everything in our development instance. Other
than taking much longer than I anticipated, it went very smoothly. In
development, there's not a whole lot of scalability or load testing I
can do. When this changes gets into our preprod environment, then I'll
have a better idea of how much it helped, if at all.
Thanks again all,
-Mark
--
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"On two occasions, I have been asked [by members of Parliament], "Pray,
Mr. Babbage, if you put into the machine wrong figures, will the right
answers come out?' I am not able to rightly apprehend the kind of
confusion of ideas that could provoke such a question."
-- Charles Babbage (1791-1871)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Wednesday, July 28, 2004 10:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Anyone implented compiled PL/SQL?
Hi,
As part of our move to 9i, we're looking at various features, and I'm
wondering about compiled PL/SQL. Does anyone have any experience with
it? Any major issues or problems? Is there any gold at the end of the
rainbow? (Does it actually provide noticeable performance improvement?)
Thanks,
-Mark
PS Oracle 9.2.0.5 (64-bit) on Solaris 8.
--
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"On two occasions, I have been asked [by members of Parliament], "Pray,
Mr. Babbage, if you put into the machine wrong figures, will the right
answers come out?' I am not able to rightly apprehend the kind of
confusion of ideas that could provoke such a question."
-- Charles Babbage (1791-1871)
----------------------------------------------------------------
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:
