RE: Anyone implented compiled PL/SQL?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 28 Jul 2004 16:55:50 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09EFEAF3@bosmail00.bos.il.pqe>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Wednesday, July 28, 2004 10:48 AM
To: oracle-l_at_freelists.org
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.

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 - 15:52:54 CDT