Saw some basic demo's at a BMC/Simulus seminar
revealed that compiled units were certainly faster
than their interpreted counterparts - I can't remember
off hand but it was in the order of 20-30% maybe? Of
course, typically the main performance problems with
PL/SQL are:
- poor SQL within the code
- inefficient (ie row at a time) handling of the
results
neither of which I believe native compilation will
help with greatly.
hth
connor
- Jared.Still_at_radisys.com wrote: > Waleed, have you
actually tried this?
>
> Or anyone else for that matter?
>
> Jared
>
>
>
>
>
> "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM>
> Sent by: root_at_fatcity.com
> 04/29/2002 04:23 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: pl/sql is INTERPRETED?
>
>
> See this note:
>
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=151224.1
>
> Regards,
>
> Waleed
>
> -----Original Message-----
> Sent: Monday, April 29, 2002 6:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Can this be true? How can this be? If it's
> optimized to manipulate data
> within the database, how can it be fast if it's
> interpreted (like that
> slow
> poke, Java)?
>
> I see this on Connor's website www.oracledba.co.uk
> under explicit/implicit
> cursors, under pl/sql. What on earth?
>
> Can someone elaborate, namely, Connor?? Please help
> me understand this...
> My "green" may be showing, but my gosh.
>
> Lisa Koivu
> Oracle Database Baby Oven
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Koivu, Lisa
> INET: lisa.koivu_at_efairfield.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Apr 30 2002 - 04:03:22 CDT