{"id":8492,"date":"2018-06-19T21:34:51","date_gmt":"2018-06-19T19:34:51","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=8492"},"modified":"2023-11-08T02:14:57","modified_gmt":"2023-11-08T01:14:57","slug":"memoptimized-rowstore-in-oracle-database-18c-with-oci","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/","title":{"rendered":"MemOptimized RowStore in Oracle Database 18c with OCI"},"content":{"rendered":"\n

On June 10 2018 I blogged about the MemOptimized RowStore in Oracle Database 18c<\/a>. If you haven’t read this post, it is a good idea to catch up now. I showed that accessing a memoptimized table t4<\/code> via the MemOptimized RowStore was around 60% slower than accessing a heap-organized table t1<\/code>. I suspected that this disappointing result was related to my unsupported Docker environment. But I was wrong.<\/p>\n\n\n\n

The next day, Chris Antognini contacted me, since he planned to talk about this feature at the AOUG Anwenderkonferenz 2018<\/a>. We exchanged our thoughts and shared our findings. Chris did his tests in the Oracle cloud and could also reproduce my test results. That’s interesting. Even more interesting is, that Chris translated my Java program to C and proved that the MemOptimized RowStore can be fast. That’s cool. But why didn’t it work in Java? It’s the same after all, right? No. The Java program used the JDBC thin driver and the C program OCI.<\/p>\n\n\n\n

In this blog post, I will show that OCI is a prerequisite for getting good performance out of the MemOptimized RowStore.<\/p>\n\n\n\n

The Program<\/h2>\n\n\n\n

I use the Java program from my previous post. I only added 3 parameters. The JDBC URL, the username and the password. Here’s the program.<\/p>\n\n\n\n

J.java – 100,000 queries<\/span><\/path><\/path><\/svg><\/span>
import<\/span> java.sql.Connection;<\/span><\/span>\nimport<\/span> java.sql.DriverManager;<\/span><\/span>\nimport<\/span> java.sql.PreparedStatement;<\/span><\/span>\nimport<\/span> java.sql.ResultSet;<\/span><\/span>\nimport<\/span> java.sql.SQLException;<\/span><\/span>\nimport<\/span> oracle.jdbc.driver.OracleDriver;<\/span><\/span>\npublic<\/span> <\/span>class<\/span> <\/span>J<\/span> {<\/span><\/span>\n   <\/span>private<\/span> <\/span>static<\/span> <\/span>boolean<\/span> <\/span>isRunningInDatabase<\/span>() {<\/span><\/span>\n      <\/span>return<\/span> <\/span>System<\/span>.<\/span>getProperty<\/span>(<\/span>"oracle.jserver.version"<\/span>) != <\/span>null<\/span>;<\/span><\/span>\n   }<\/span><\/span>\n   <\/span>public<\/span> <\/span>static<\/span> <\/span>void<\/span> <\/span>m<\/span>(<\/span>String<\/span> <\/span>tableName<\/span>, <\/span>String<\/span> <\/span>url<\/span>, <\/span>String<\/span> <\/span>userName<\/span>, <\/span>String<\/span> <\/span>password<\/span>) <\/span>throws<\/span> <\/span>SQLException<\/span> {<\/span><\/span>\n      <\/span>Connection<\/span> <\/span>conn<\/span>;<\/span><\/span>\n      <\/span>if<\/span> (<\/span>isRunningInDatabase<\/span>()) {<\/span><\/span>\n         conn = <\/span>new<\/span> <\/span>OracleDriver<\/span>().<\/span>defaultConnection<\/span>();<\/span><\/span>\n      } <\/span>else<\/span> {<\/span><\/span>\n         conn = <\/span>DriverManager<\/span>.<\/span>getConnection<\/span>(<\/span><\/span>\n           url, userName, password);<\/span><\/span>\n      }<\/span><\/span>\n      <\/span>conn<\/span>.<\/span>setAutoCommit<\/span>(<\/span>false<\/span>);<\/span><\/span>\n      <\/span>long<\/span> <\/span>start<\/span> = <\/span>System<\/span>.<\/span>currentTimeMillis<\/span>();<\/span><\/span>\n      <\/span>String<\/span> <\/span>query<\/span> = <\/span>"SELECT value FROM "<\/span> + tableName + <\/span>" WHERE key = ?"<\/span>;      <\/span><\/span>\n      <\/span>PreparedStatement<\/span> <\/span>ps<\/span> = <\/span>conn<\/span>.<\/span>prepareStatement<\/span>(query);<\/span><\/span>\n      <\/span>for<\/span> (<\/span>long<\/span> <\/span>i<\/span> = <\/span>1<\/span>; i <= <\/span>100000<\/span>; i++) {<\/span><\/span>\n         <\/span>ps<\/span>.<\/span>setLong<\/span>(<\/span>1<\/span>, i);<\/span><\/span>\n         <\/span>ResultSet<\/span> <\/span>rs<\/span> = <\/span>ps<\/span>.<\/span>executeQuery<\/span>();<\/span><\/span>\n         <\/span>while<\/span> (<\/span>rs<\/span>.<\/span>next<\/span>()) {<\/span><\/span>\n            <\/span>rs<\/span>.<\/span>getString<\/span>(<\/span>"value"<\/span>);<\/span><\/span>\n         }<\/span><\/span>\n         <\/span>rs<\/span>.<\/span>close<\/span>();<\/span><\/span>\n      }<\/span><\/span>\n      <\/span>ps<\/span>.<\/span>close<\/span>();<\/span><\/span>\n      <\/span>if<\/span> (!<\/span>isRunningInDatabase<\/span>()) {<\/span><\/span>\n         <\/span>conn<\/span>.<\/span>close<\/span>();<\/span><\/span>\n      }<\/span><\/span>\n      <\/span>long<\/span> <\/span>end<\/span> = <\/span>System<\/span>.<\/span>currentTimeMillis<\/span>();<\/span><\/span>\n      <\/span>System<\/span>.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"read 100000 rows from "<\/span> + tableName + <\/span>" in "<\/span> +<\/span><\/span>\n         <\/span>String<\/span>.<\/span>valueOf<\/span>((<\/span>double<\/span>) (end-start)\/<\/span>1000<\/span>) + <\/span>" seconds via "<\/span> + url + <\/span>"."<\/span>);      <\/span><\/span>\n   }<\/span><\/span>\n   <\/span>public<\/span> <\/span>static<\/span> <\/span>void<\/span> <\/span>main<\/span>(<\/span>String<\/span>[] <\/span>args<\/span>) <\/span>throws<\/span> <\/span>SQLException<\/span> {<\/span><\/span>\n      <\/span>m<\/span>(args[<\/span>0<\/span>], args[<\/span>1<\/span>], args[<\/span>2<\/span>], args[<\/span>3<\/span>]);<\/span><\/span>\n   }<\/span><\/span>\n}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
I copied this program to my Docker container into the directory $ORACLE_HOME\/jdbc\/lib<\/code> and compiled it with the following script:<\/p>\n\n\n\n
compile.sh<\/span><\/path><\/path><\/svg><\/span>
export<\/span> <\/span>rt<\/span> <\/span>CLASSPATH=.:.\/ojdbc8.jar<\/span><\/span>\njavac<\/span> <\/span>J.java<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The Test Script<\/h2>\n\n\n\n
I’ve run the tests for my previous post<\/a> from the Eclipse IDE because it was convenient for me to set a break point on line 20 to identify the Oracle process for perf<\/code>. Now, I do not need to produce flame graphs. Running the test script on the server directly will also reduce the network overhead, especially when running without Oracle Net.<\/p>\n\n\n\n
Here’s the test script:<\/p>\n\n\n\n
run.sh<\/span><\/path><\/path><\/svg><\/span>
#\/bin\/bash<\/span><\/span>\n<\/span>\nrun<\/span>(){<\/span><\/span>\n    <\/span>TABLE<\/span>=<\/span>${1}<\/span><\/span>\n    <\/span>URL<\/span>=<\/span>${2}<\/span><\/span>\n    <\/span>for<\/span> ((i=<\/span>1<\/span>;i<=<\/span>5<\/span>;i++));<\/span><\/span>\n    <\/span>do<\/span><\/span>\n        <\/span>echo<\/span> <\/span>-n<\/span> <\/span>"run #${<\/span>i<\/span>}: "<\/span><\/span>\n        <\/span>java<\/span> <\/span>J<\/span> ${<\/span>TABLE<\/span>} ${<\/span>URL<\/span>} ${<\/span>USERNAME<\/span>} ${<\/span>PASSWORD<\/span>}<\/span><\/span>\n    <\/span>done<\/span><\/span>\n    <\/span>echo<\/span> <\/span>""<\/span><\/span>\n} <\/span><\/span>\n<\/span>\nexport<\/span> <\/span>CLASSPATH<\/span>=<\/span>.:.\/ojdbc8.jar<\/span><\/span>\nexport<\/span> <\/span>USERNAME<\/span>=<\/span>tvdca<\/span><\/span>\nexport<\/span> <\/span>PASSWORD<\/span>=<\/span>tvdca<\/span><\/span>\n<\/span>\n# Thin driver<\/span><\/span>\nrun<\/span> <\/span>t1<\/span> <\/span>"jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker"<\/span><\/span>\nrun<\/span> <\/span>t2<\/span> <\/span>"jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker"<\/span><\/span>\nrun<\/span> <\/span>t3<\/span> <\/span>"jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker"<\/span><\/span>\nrun<\/span> <\/span>t4<\/span> <\/span>"jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker"<\/span><\/span>\n<\/span>\n# OCI driver with Oracle*Net<\/span><\/span>\nrun<\/span> <\/span>t1<\/span> <\/span>"jdbc:oracle:oci:@odb"<\/span><\/span>\nrun<\/span> <\/span>t2<\/span> <\/span>"jdbc:oracle:oci:@odb"<\/span><\/span>\nrun<\/span> <\/span>t3<\/span> <\/span>"jdbc:oracle:oci:@odb"<\/span><\/span>\nrun<\/span> <\/span>t4<\/span> <\/span>"jdbc:oracle:oci:@odb"<\/span><\/span>\n<\/span>\n# OCI driver without Oracle*Net<\/span><\/span>\nrun<\/span> <\/span>t1<\/span> <\/span>"jdbc:oracle:oci:@"<\/span><\/span>\nrun<\/span> <\/span>t2<\/span> <\/span>"jdbc:oracle:oci:@"<\/span><\/span>\nrun<\/span> <\/span>t3<\/span> <\/span>"jdbc:oracle:oci:@"<\/span><\/span>\nrun<\/span> <\/span>t4<\/span> <\/span>"jdbc:oracle:oci:@"<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The Result<\/h2>\n\n\n\n
Here’s the output of the run.sh<\/code> call:<\/p>\n\n\n\n
Console output of run.sh<\/span><\/path><\/path><\/svg><\/span>
[oracle@odb180 lib]$ .\/run.sh<\/span><\/span>\nrun #1: read 100000 rows from t1 in 11.918 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #2: read 100000 rows from t1 in 11.625 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #3: read 100000 rows from t1 in 11.662 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #4: read 100000 rows from t1 in 11.574 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #5: read 100000 rows from t1 in 11.729 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t2 in 11.786 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #2: read 100000 rows from t2 in 12.071 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #3: read 100000 rows from t2 in 12.621 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #4: read 100000 rows from t2 in 11.913 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #5: read 100000 rows from t2 in 11.972 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t3 in 11.397 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #2: read 100000 rows from t3 in 11.429 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #3: read 100000 rows from t3 in 11.308 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #4: read 100000 rows from t3 in 11.793 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #5: read 100000 rows from t3 in 11.903 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t4 in 19.789 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #2: read 100000 rows from t4 in 19.461 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #3: read 100000 rows from t4 in 19.181 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #4: read 100000 rows from t4 in 19.211 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\nrun #5: read 100000 rows from t4 in 19.242 seconds via jdbc:oracle:thin:@\/\/localhost:1521\/odb.docker.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t1 in 13.145 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #2: read 100000 rows from t1 in 12.698 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #3: read 100000 rows from t1 in 13.14 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #4: read 100000 rows from t1 in 12.842 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #5: read 100000 rows from t1 in 12.978 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t2 in 13.049 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #2: read 100000 rows from t2 in 12.581 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #3: read 100000 rows from t2 in 12.44 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #4: read 100000 rows from t2 in 12.787 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #5: read 100000 rows from t2 in 12.727 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t3 in 12.402 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #2: read 100000 rows from t3 in 12.479 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #3: read 100000 rows from t3 in 12.483 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #4: read 100000 rows from t3 in 12.346 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #5: read 100000 rows from t3 in 12.528 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t4 in 11.452 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #2: read 100000 rows from t4 in 10.945 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #3: read 100000 rows from t4 in 11.597 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #4: read 100000 rows from t4 in 11.295 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\nrun #5: read 100000 rows from t4 in 11.746 seconds via jdbc:oracle:oci:@odb.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t1 in 10.508 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #2: read 100000 rows from t1 in 10.662 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #3: read 100000 rows from t1 in 10.105 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #4: read 100000 rows from t1 in 10.44 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #5: read 100000 rows from t1 in 10.415 seconds via jdbc:oracle:oci:@.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t2 in 10.29 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #2: read 100000 rows from t2 in 10.15 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #3: read 100000 rows from t2 in 10.266 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #4: read 100000 rows from t2 in 10.351 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #5: read 100000 rows from t2 in 10.259 seconds via jdbc:oracle:oci:@.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t3 in 9.95 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #2: read 100000 rows from t3 in 9.756 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #3: read 100000 rows from t3 in 10.325 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #4: read 100000 rows from t3 in 9.517 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #5: read 100000 rows from t3 in 9.951 seconds via jdbc:oracle:oci:@.<\/span><\/span>\n<\/span><\/span>\nrun #1: read 100000 rows from t4 in 9.182 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #2: read 100000 rows from t4 in 8.996 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #3: read 100000 rows from t4 in 8.977 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #4: read 100000 rows from t4 in 9.024 seconds via jdbc:oracle:oci:@.<\/span><\/span>\nrun #5: read 100000 rows from t4 in 9.082 seconds via jdbc:oracle:oci:@.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
As in my previous post, I ignore the slowest and fastest run and take the average of the remaining three results per test variant to produce a chart.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
We see that using the JDBC OCI driver delivers the fastest results when skipping Oracle Net. Furthermore, the MemOptimized RowStore delivers the fastest results via OCI. Accessing the MemOptimized RowStore via the JDBC thin driver leads by to a bad performance. This looks like a bug.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
To get benefit from the MemOptimized RowStore you have to access the database via OCI.<\/p>\n","protected":false},"excerpt":{"rendered":"
On June 10 2018 I blogged about the MemOptimized RowStore in Oracle Database 18c. If you haven’t read this post, it is a good idea to catch up now. I showed that accessing a memoptimized table t4 via the MemOptimized RowStore was around 60% slower than accessing a heap-organized table t1. I [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":9513,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[107,25,13,85],"class_list":["post-8492","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-java","tag-performance","tag-plsql","tag-sql"],"yoast_head":"\nMemOptimized RowStore in Oracle Database 18c with OCI - Philipp Salvisberg's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MemOptimized RowStore in Oracle Database 18c with OCI - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"On June 10 2018 I blogged about the MemOptimized RowStore in Oracle Database 18c. If you haven’t read this post, it is a good idea to catch up now. I showed that accessing a memoptimized table t4 via the MemOptimized RowStore was around 60% slower than accessing a heap-organized table t1. I [\u2026]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-19T19:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T01:14:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/02\/memoptimize_pool.png\" \/>\n\t<meta property=\"og:image:width\" content=\"414\" \/>\n\t<meta property=\"og:image:height\" content=\"537\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"MemOptimized RowStore in Oracle Database 18c with OCI\",\"datePublished\":\"2018-06-19T19:34:51+00:00\",\"dateModified\":\"2023-11-08T01:14:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/\"},\"wordCount\":421,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/memoptimize_pool.png\",\"keywords\":[\"Java\",\"Performance\",\"PL\\\/SQL\",\"SQL\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/\",\"name\":\"MemOptimized RowStore in Oracle Database 18c with OCI - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/memoptimize_pool.png\",\"datePublished\":\"2018-06-19T19:34:51+00:00\",\"dateModified\":\"2023-11-08T01:14:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/memoptimize_pool.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/memoptimize_pool.png\",\"width\":414,\"height\":537},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/06\\\/19\\\/memoptimized-rowstore-in-oracle-database-18c-with-oci\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MemOptimized RowStore in Oracle Database 18c with OCI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MemOptimized RowStore in Oracle Database 18c with OCI - Philipp Salvisberg's Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/","og_locale":"en_US","og_type":"article","og_title":"MemOptimized RowStore in Oracle Database 18c with OCI - Philipp Salvisberg's Blog","og_description":"On June 10 2018 I blogged about the MemOptimized RowStore in Oracle Database 18c. If you haven’t read this post, it is a good idea to catch up now. I showed that accessing a memoptimized table t4 via the MemOptimized RowStore was around 60% slower than accessing a heap-organized table t1. I [\u2026]","og_url":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2018-06-19T19:34:51+00:00","article_modified_time":"2023-11-08T01:14:57+00:00","og_image":[{"width":414,"height":537,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/02\/memoptimize_pool.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"MemOptimized RowStore in Oracle Database 18c with OCI","datePublished":"2018-06-19T19:34:51+00:00","dateModified":"2023-11-08T01:14:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/"},"wordCount":421,"commentCount":2,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/02\/memoptimize_pool.png","keywords":["Java","Performance","PL\/SQL","SQL"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/","url":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/","name":"MemOptimized RowStore in Oracle Database 18c with OCI - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/02\/memoptimize_pool.png","datePublished":"2018-06-19T19:34:51+00:00","dateModified":"2023-11-08T01:14:57+00:00","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/02\/memoptimize_pool.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/02\/memoptimize_pool.png","width":414,"height":537},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2018\/06\/19\/memoptimized-rowstore-in-oracle-database-18c-with-oci\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MemOptimized RowStore in Oracle Database 18c with OCI"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/8492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=8492"}],"version-history":[{"count":32,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/8492\/revisions"}],"predecessor-version":[{"id":12638,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/8492\/revisions\/12638"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/9513"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=8492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=8492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=8492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}