Update cookies preferences

Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance [Paperback / softback]

5.00/5 (4 ratings by Goodreads)
  • Format: Paperback / softback, 288 pages, height x width x depth: 231x185x15 mm, weight: 504 g, 120 Illustrations
  • Pub. Date: 16-May-2017
  • Publisher: McGraw-Hill Education
  • ISBN-10: 1259586162
  • ISBN-13: 9781259586163
Other books in subject:
  • Paperback / softback
  • Price: 79,45 €
  • This book is not in stock. Book will arrive in about 3-4 weeks. Please allow another 2 weeks for shipping outside Estonia.
  • Quantity:
  • Add to basket
  • Delivery time 2-4 weeks
  • Add to Wishlist
Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum PerformanceLarger Image
  • Format: Paperback / softback, 288 pages, height x width x depth: 231x185x15 mm, weight: 504 g, 120 Illustrations
  • Pub. Date: 16-May-2017
  • Publisher: McGraw-Hill Education
  • ISBN-10: 1259586162
  • ISBN-13: 9781259586163
Other books in subject:
Permanent link: https://www.kriso.ee/db/9781259586163.html
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 2s 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
Acknowledgments ix
Introduction xi
1 Database Architecture
1(32)
Oracle Database and Instance
3(1)
Storage Structure of a Database
4(1)
Physical Structure
4(11)
Logical Structure
15(2)
Memory Structure
17(1)
System Global Area (SGA)
17(5)
Program Global Area (PGA)
22(1)
Process Structure
23(1)
Process Monitor (PMON)
23(1)
System Monitor (SMON)
23(1)
Database Writer (DBWn)
24(1)
Log Writer (LGWR)
24(1)
Checkpoint (CKPT)
25(1)
Recoverer (RECO)
25(1)
Other Processes
25(7)
Summary
32(1)
2 In-Memory Architecture
33(30)
Row vs. Column Processing
37(2)
Database In-Memory Architecture
39(4)
In-Memory Storage Units
43(4)
GET_COMPRESSION_RATIO Procedure
47(1)
Syntax
47(5)
SIMD Vector Processing
52(1)
Data Load in In-Memory Column Store
53(2)
IM FastStart
55(2)
In-Memory with Automatic Data Optimization (ADO)
57(1)
Restrictions and Usage
58(3)
Summary
61(2)
3 Implementing In-Memory
63(30)
Allocating the In-Memory Area
64(3)
Initialization Parameters for In-Memory
67(10)
Populating Data in the IMCS
77(2)
Enabling the IMCS at the Database Level
79(1)
Enabling/Disabling IMCS for Tables
80(3)
Enabling/Disabling IMCS for a Virtual Column
83(1)
Enabling/Disabling IMCS for a Tablespace
83(1)
Enabling/Disabling IMCS for a Materialized View
84(1)
Enabling IM FastStart
85(1)
Enabling ADO and In-Memory
85(3)
IMCS and Data Pump
88(1)
Objects that Cannot Be Populated in IMCS
88(1)
In-Memory Views
89(1)
Summary
90(3)
4 How Database In-Memory Works with RAC and Multitenant
93(24)
RAC Basics
94(1)
RAC Architecture and Concepts
94(6)
RAC Background Processes
100(1)
Parallel Execution with RAC
101(3)
Degree of Parallelism (DOP)
104(4)
Memory Requirement for RAC
108(1)
RAC and DBIM
109(1)
IMCS Data Population in RAC
110(2)
IMCS Data and Services
112(2)
Multitenant and IMDB
114(1)
Summary
115(2)
5 Database In-Memory Advisor
117(24)
Installing the In-Memory Advisor
118(3)
Running the In-Memory Advisor
121(12)
Implementing Advisor Recommendations and Comparing Results
133(6)
Summary
139(2)
6 Optimizing Database In-Memory Queries
141(20)
Using Join Groups
142(4)
Creating a Join Group
146(1)
Using IM Expressions
147(5)
Using In-Memory Aggregations
152(6)
Summary
158(3)
7 In-Memory and Engineering Systems
161(26)
Advantages of Exadata
162(2)
Exadata Architecture
164(1)
Database Servers or Compute Nodes
165(1)
Exadata Storage Cells or Exadata Storage Servers
166(2)
InfiniBand
168(1)
Exadata Hardware Configurations
168(1)
Exadata Features
169(1)
Hybrid Columnar Compression
169(5)
Advantages of HCC and Database In-Memory
174(1)
Smart Scans vs. Traditional Architecture
175(5)
Storage Index
180(2)
Exadata Smart Flash Cache
182(2)
Database In-Memory Fault Tolerance for Exadata
184(1)
Summary
185(2)
8 In-Memory Lab
187(72)
View the Server Memory Specification
188(5)
Load Data Using SwingBench
193(7)
Generate Data for Sales History
200(1)
Check Memory-Related Parameters
201(2)
Start Data Population
203(4)
Create a Materialized View
207(1)
Edit an Object's In-Memory Attributes and Settings
208(6)
Disabling the In-Memory Option
214(2)
Install the In-Memory Advisor
216(4)
Run a Workload
220(3)
Summary
223(2)
A Installing the Oracle Database and Enabling In-Memory
225(1)
Preinstallation Steps
226(2)
Disk Space in Temporary File System
228(1)
SWAP Space Relative to RAM
228(1)
Oracle Inventory Directory
229(1)
Users and Groups
230(1)
Environmental Variables
230(1)
Root Access
231(1)
Oracle Software Location
232(1)
Grid Infrastructure (Conditional)
232(1)
Staging the Software
233(1)
Running Oracle Universal Installer
233(23)
Post-Installation Steps
256(1)
Enabling the In-Memory Option
256(2)
Summary
258(1)
Index 259
Joyjeet Banerjee is currently principal consultant with Oracle Consulting, based out of California, USA. He has over nine years of experience as an Oracle DBA and Oracle Apps DBA. He specializes in Oracle DBMS (Ver 10g/9i/ 8.1.7/ 8.0.5) and Oracle Applications Database Administration (R12/ 11.5.10/ 11.5.9/ 11.5.8/ 11.5.6/ 11.0.3). He has rich experience in supporting multiple production and development databases under various Unix and Windows NT environments. He has also authored a book, Oracle Applications DBA - covers 11i and R12, published by McGraw-Hill Education.