Native PLSQL Execution

Native PLSQL execution has changed significantly since the version 10G. The effects are less than spectacular, in the ideal case I got about 10% of the performance boost. This is much easier to administer now, there are no shared libraries in the file system, as was the case with version 10G. Oracle has re-invented the dlopen routine, with the shared library residing in the database. The gory details can be found at:

http://mgogala.byethost5.com/Native_PLSQL_Execution.html

On the same web site, there is also a PDF version of the same page but WordPress displays some inane commercial, rather than to point to the PDF, so the PDF link was replaced by a HTML one. PDF, however, looks better, at least in my opinion.

 

About these ads

About mgogala

I am a long time Oracle DBA, who has worked on very large databases. I have worked with OPS and RAC since its inception.I am also a published book writer, having published two books about PHP. This blog is about the challenges and adventures in my professional life. Sorry, no family pictures here.
This entry was posted in Miscellaneous Oracle and tagged , , . Bookmark the permalink.

3 Responses to Native PLSQL Execution

  1. mgogala says:

    An important addition to the paper: the mmap call is called with the argument MAP_PRIVATE, which means that there is no sharing. Compiled procedure is mapped into the user process address space and is not shared among processes. There is no shared pool caching for compiled procedures.

  2. mgogala says:

    It seems that the link to the document works properly only in Google Chrome browser. Please, cut the URL and paste it in the new tab, if you are using anything other than Chrome

  3. mgogala says:

    I tested native compilation with 12c, the result is essentially the same.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s