Skip to Main Content

Database In-Memory Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

May 27

16:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


RAC - How Population and Queries Work
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Explore the Database In-Memory option with Andy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria). In this session we took another look at RAC with an emphasis on how population works, how objects get placed on nodes or across nodes and how queries work with multiple nodes. We also showed some demos on a 19c RAC cluster of populating with distribution across the three nodes, serial vs. parallel queries, and using the FOR SERVICE sub-clause to populate on specific nodes.

7:06 - In-Memory Area
9:13 - IMCUs
18:22 - RAC population demo
22:34 - RAC distribution
28:02 - RAC queries
36:11 - Serial and parallel query demo

Your Experts

Andy Rivenes
Andy Rivenes, Product Manager    
Andy Rivenes is a Product Manager at Oracle for Database In-Memory. Prior to that Andy was a Product Manager for Heat Map, Automatic Data Optimization, SecureFiles and DBFS. Andy has spent a large part of his career managing Oracle databases and he now spends his time helping customers implement Database In-Memory as well as providing information about Database In-Memory through blogs, conferences, and customer visits. You can visit the Database In-Memory blog at or follow his tweets as @TheInMemoryGuy.
Maria Colgan
Maria Colgan, Master Product Manager    
Maria Colgan is a master product manager at Oracle Corporation and evangelist for Oracle Database, which she's worked with since version 7.3. In an earlier life, she was the product manager for Oracle Database In-Memory and the query optimizer.