Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance

by Joyjeet Banerjee

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Master Oracle Database 12c Release 2’s powerful In-Memory option

This Oracle Press guide shows, step-by-step, how to optimize database performance and cut transaction processing time using Oracle Database 12c Release 2 In-Memory. Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance features hands-on instructions, best practices, and expert tips from an Oracle enterprise architect. You will learn how to deploy the software, use In-Memory Advisor, build queries, and interoperate with Oracle RAC and Multitenant. A complete chapter of case studies illustrates real-world applications.

• Configure Oracle Database 12c and construct In-Memory enabled databases
• Edit and control In-Memory options from the graphical interface
• Implement In-Memory with Oracle Real Application Clusters
• Use the In-Memory Advisor to determine what objects to keep In-Memory
• Optimize In-Memory queries using groups, expressions, and aggregations
• Maximize performance using Oracle Exadata Database Machine and In-Memory option
• Use Swingbench to create data and simulate real-life system workloads

Product Details

ISBN-13:	9781259586163
Publisher:	McGraw Hill LLC
Publication date:	05/12/2017
Series:	Oracle Press
Pages:	288
Product dimensions:	7.30(w) x 9.10(h) x 0.60(d)

About the Author

Joyjeet Banerjee (Fremont, CA) works as an enterprise architect with Oracle’s Engineered System team. He helps Oracle customers migrate from legacy systems to engineered systems. Joyjeet is a regular speaker at OAUG, Oracle Collaborate, and Oracle OpenWorld.

Table of Contents

Acknowledgments ix

Introduction xi

1 Database Architecture 1

Oracle Database and Instance 3

Storage Structure of a Database 4

Physical Structure 4

Logical Structure 15

Memory Structure 17

System Global Area (SGA) 17

Program Global Area (PGA) 22

Process Structure 23

Process Monitor (PMON) 23

System Monitor (SMON) 23

Database Writer (DBWn) 24

Log Writer (LCWR) 24

Checkpoint (CKPT) 25

Recoverer (RECO) 25

Other Processes 25

Summary 32

2 In-Memory Architecture 33

Row vs. Column Processing 37

Database In-Memory Architecture 39

In-Memory Storage Units 43

Get_Compresseon_Ratio Procedure 47

Syntax 47

SIMD Vector Processing 52

Data Load in In-Memory Column Store 53

IM FastStart 55

In-Memory with Automatic Data Optimization (ADO) 57

Restrictions and Usage 58

Summary 61

3 Implementing In-Memory 63

Allocating the In-Memory Area 64

Initialization Parameters for In-Memory 67

Populating Data in the IMCS 77

Enabling the IMCS at the Database Level 79

Enabling/Disabling IMCS for Tables 80

Enabling/Disabling IMCS for a Virtual Column 83

Enabling/Disabling IMCS for a Tablespace 83

Enabling/Disabling IMCS for a Materialized View 84

Enabling IM FastStart 85

Enabling ADO and In-Memory 85

IMCS and Data Pump 88

Objects that Cannot Be Populated in IMCS 88

In-Memory Views 89

Summary 90

4 How Database In-Memory Works with RAC and Multitenant 93

RAC Basics 94

RAC Architecture and Concepts 94

RAC Background Processes 100

Parallel Execution with RAC 101

Degree of Parallelism (DOP) 104

Memory Requirement for RAC 108

RAC and DBIM 109

IMCS Data Population in RAC 110

IMCS Data and Services 112

Multitenant and IMDB 114

Summary 115

5 Database In-Memory Advisor 117

Installing the In-Memory Advisor 118

Running the In-Memory Advisor 121

Implementing Advisor Recommendations and Comparing Results 133

Summary 139

6 Optimizing Database In-Memory Queries 141

Using Join Croups 142

Creating a Join Group 146

Using IM Expressions 147

Using In-Memory Aggregations 152

Summary 158

7 In-Memory and Engineering Systems 161

Advantages of Exadata 162

Exadata Architecture 164

Database Servers or Compute Nodes 165

Exadata Storage Cells or Exadata Storage Servers 166

InfiniBand 168

Exadata Hardware Configurations 168

Exadata Features 169

Hybrid Columnar Compression 169

Advantages of HCC and Database In-Memory 174

Smart Scans vs. Traditional Architecture 175

Storage Index 180

Exadata Smart Flash Cache 182

Database In-Memory Fault Tolerance for Exadata 184

Summary 185

3 In-Memory Lab 187

View the Server Memory Specification 188

Load Data Using SwingBench 193

Generate Data for Sales History 200

Check Memory-Related Parameters 201

Start Data Population 203

Create a Materialized View 207

Edit an Object's In-Memory Attributes and Settings 208

Disabling the In-Memory Option 214

Install the In-Memory Advisor 216

Run a Workload 220

Summary 223

A Installing the Oracle Database and Enabling In-Memory 225

Preinstallation Steps 226

Disk Space in Temporary File System 228

SWAP Space Relative to RAM 228

Oracle Inventory Directory 229

Users and Groups 230

Environmental Variables 230

Root Access 231

Oracle Software Location 232

Grid Infrastructure (Conditional) 232

Staging the Software 233

Running Oracle Universal Installer 233

Post-Installation Steps 256

Enabling the In-Memory Option 256

Summary 258

Index 259