Have you wanted to try out Database In-Memory but didn't want to spend the time trying to set up your own demo to see what it does? Well now you don't have to because we have done it for you. We created a single SQL script to allow you to see the benefits of Database In-Memory. It really doesn't get much simpler than that.
All you need is a database user, 600 MB of IM column store available and 1500 MB of space to create and load a single database table. We tried to make this as simple as possible while still making it big enough to show the benefits of Database In-Memory.
The demo will run on any Oracle Database that can run Database In-Memory, including Oracle Database XE and the new Oracle Database 23c Free. When you run the script it will create a single table called ORDERS_TAB, it will insert a bunch of data, populate the table in the IM column store and then run a couple of analytic queries to show the difference that Database In-Memory makes for analytic query performance. You can even experiment with your own queries after running the demo and we also give you the commands to clean everything up after you're done.
The simple demo script is available on Github here, and there is a README to show how to set up the user and how much space the demo requires. There is even a text file that shows an example of running the demo and the results.
Andy Rivenes is a Senior Principal Product Manager at Oracle Corporation and is a Product Manager for Database In-Memory. Andy has been working with Oracle products since 1992 and spent a large part of his career managing Oracle databases for both custom and E-Business Suite applications. Andy now spends his time helping customers implement Database In-Memory and providing information about Database In-Memory through blogs, conferences, and customer visits.