Nieuw in Oracle database 12.1.0.2

Nieuw in Oracle database 12.1.0.2
Transfer Café
Patrick Munne
Spreker(s)
Datum
:
:
23 september 2014
E-mail
:
pmunne@transfer-solutions.com
WWW.TRANSFER-SOLUTIONS.COM
Indeling deel 1





Default Database Caching
(10 min.)
Force Full Database Caching
(10 min.)
Database Smart Flash Cache
(10 min.)
Oracle Result Cache
(10 min.)
Oracle TimesTen Database
(10 min.)
-------------- pauze --------------
© COPYRIGHT TRANSFER SOLUTIONS B.V.
2
Indeling deel 2





In-Memory database
(20 min.)
Pluggable Database Upgrade
(10 min.)
Clone Non-CDB naar een PDB
(10 min.)
PDB Status Management
(10 min.)
APEX en Pluggable Databases
(10 min.)
----------------- drankje -------------------
© COPYRIGHT TRANSFER SOLUTIONS B.V.
3
Default Database Caching (algemeen)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
4
Default database Caching (algemeen)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
5
Force Full Database Caching (12.1.0.2)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
6
Force Full Database Caching (12.1.0.2)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
7
Database Smart Flash Cache (11.2)
SGA (BUFFER CACHE)
Flash Cache (SSD)
DISK
© COPYRIGHT TRANSFER SOLUTIONS B.V.
8
Database Smart Flash Cache (11.2)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
9
Oracle Result Cache (11g)

Server Result Cache

Client Result Cache
© COPYRIGHT TRANSFER SOLUTIONS B.V.
10
Oracle Result Cache (11g)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
11
Oracle TimesTen Database

Oracle TimesTen Application-Tier Database Cache
TimesTen Application-Tier
Database Cache
Applicatie
TimesTen
Client
Oracle Database
11g/12c
© COPYRIGHT TRANSFER SOLUTIONS B.V.
12
Oracle TimesTen Database
© COPYRIGHT TRANSFER SOLUTIONS B.V.
13
© COPYRIGHT TRANSFER SOLUTIONS B.V.
14
Oracle In-Memory database (12.1.0.2)

Oracle database In-Memory
 In-Memory Column Store
 In-Memory Aggregation
© COPYRIGHT TRANSFER SOLUTIONS B.V.
15
Oracle In-Memory database (12.1.0.2)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
16
Oracle In-Memory database (12.1.0.2)
Row-Store
Block Cache
© COPYRIGHT TRANSFER SOLUTIONS B.V.
Column Store
In-Memory
17
Oracle In-Memory database (12.1.0.2)
© COPYRIGHT TRANSFER SOLUTIONS B.V.
18
Multitenant database

Multitenant database
 Verzamelnaam voor een container database en de
pluggable databases
© COPYRIGHT TRANSFER SOLUTIONS B.V.
19
Pluggable Database Upgrade
CDB1
12.1.0.1
seed
© COPYRIGHT TRANSFER SOLUTIONS B.V.
CDB2
12.1.0.2
pdb1
pdb1
seed
20
Pluggable Database Upgrade
© COPYRIGHT TRANSFER SOLUTIONS B.V.
21
Clone NON-CDB naar een PDB
DB2
12.1.0.2
Database link
CDB2
12.1.0.2
DB2
© COPYRIGHT TRANSFER SOLUTIONS B.V.
seed
22
Clone NON-CDB naar een PDB
© COPYRIGHT TRANSFER SOLUTIONS B.V.
23
PDB Status Management
PDB1
PDB2
PDB3
MOUNT
READ ONLY
READ WRITE
CDB$ROOT
© COPYRIGHT TRANSFER SOLUTIONS B.V.
24
PDB Status Management
© COPYRIGHT TRANSFER SOLUTIONS B.V.
25
APEX en Pluggable Databases
PDB1
Apex 4.2.1
PDB2
Apex 4.2.1
Apex 4.2.1
CDB$ROOT
© COPYRIGHT TRANSFER SOLUTIONS B.V.
PDB3
Apex 4.2.1
PDB4
Apex 4.2.5
CDB$ROOT
26
APEX en Pluggable Databases
© COPYRIGHT TRANSFER SOLUTIONS B.V.
27
Vragen
Antwoorden
CONSULTING | MANAGED SERVICES | EDUCATION
WWW.TRANSFER-SOLUTIONS.COM
© COPYRIGHT TRANSFER SOLUTIONS B.V.
28