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, 2020

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.

Highlights:
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
42:57 - DISTRIBUTE FOR SERVICE

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

Ask a Question

Ask The Experts - Right Now!

Do you have a question about In-Memory. you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.

Experts

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 https://blogs.oracle.com/in-memory 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.