Oracle Exadata Storage Technical Overview

1
Sun Oracle Database Machine ??????????? ?????
??????? ??????, http//dsvolk.blogspot.comOrac
le CIS

2
????? ?????? ???????..

• 12-Node Sun SPARC Enterprise T5440, ??????????
  T2
• Sun Storage F5100 Flash Array
• Oracle Database 11g R2 RAC
• ??? ?? Sun Oracle Database Machine
• ?????? ?? ?????-?????http//www.oracle.com/us/co
  rporate/press/036544

3
?????????

• ????? ????? ???????
• ???????? ??????????????
• ??? ??????? ?????????
• ?????????? ???????????
• ?????? ?????????
• ???????????? ????????
• ??????????? ???????????
• Exadata Software
• ??????????? 11g R2

4
????? ???????
5
???????? ???????????????? ??? ???????? ??????
10 ?????
????????????????????????
Typical High-End Array
Typical Mid-Range Array
5 ?????
Typical NAS
Oracle Exadata Storage Grid
1 ???
?????? ???????
1TB
10 TB
100TB
6
????????? ????????????????? ??????? ????????
??????
Oracle Database Grid
Storage Array
??????? ? ????????? ????? ?
???????? ??? ???????
Select sum(sales) where salesdate 08-Oct-2008
SUM
7
????????? ???????? ????????? Exadata Storage
Server
Oracle Database Grid
Oracle Exadata Storage Grid
??????? ? ????????? ????? ?
?????? ?????? ?????? ?? Oct 08 2008
Select sum(sales) where salesdate 08-Oct-2008
SUM
8
????????? ???????? ????????? Exadata Storage
Server
x10 ??????? ????????? ????????
9
Exadata ?????? ?????? ? 10 ???

1. Exadata ????? ??????? ?????? ? 10 ??? ????? ???,
   ?? ???? ?????? ????? ???????? ??????
2. ???????????? ?????????? Storage ????????, ??
   Database ????????
3. ????????? ??? ??????????

10 TB ??????
1 TB ?? ???????
10
Sun Flash
11
????????? ???????? ????????? Sun Flash
1,000,000 IOPS
12
??? ??????? ????????? ?
13
M-Tel ????????? ???????? 10X to 72X?????????
????????, ????????
28x ??????? ?????????
14
???????????? M-Tel
1/2 Database Machine
???????????? ???????
2 IBM P570s
EMC CX3-40 Storage
15
Giant Eagle ????????? 3X to 50X ????????,
x???????? ?????? ?? ????????
16
Giant Eagle
1/2 Database Machine
???????????? ???????
13 IBM P570 CPUs
EMC CLARiiON and DMX Storage Array
???? ?????????????????? ? ??????? ? 16 ???
17
Exadata, ???????? ??????????????

• ??????????????????
• ?? 10X ??? ???????? ??????
• ?? 20X ??? OLTP ??????????
• ???????? ????????????????
• ?????????????????? ?????? ??????? ??? ??????????
  ????? ????? exadata.
• ?????????? ? ????????????
• ??????????? ??????? ??????? ? ????????? ?? 1
  ????
• ?????? ????? ????????? ?? ? ?????? ?? Oracle
• ???????????? ??????? ??????????
• ????????? ??? ???????????? ??????????.
• ?????????? ?? ? ???????????? ?? ????????.

18
?????????? ???????????
19
????????Exadata Storage Server Database Machine

• Exadata Storage Server
• ?????????, ???????????????? ??? Oracle Database
• ???????????????? ????-????? ? ????????? SQL
• ?????????? ?? ? ??????
• ?? Exadata
• ?O Unbreakable Linux 5.x

• Sun Oracle Database Machine
• ??????? ??????????????????
• ???????????????? ????????????
• ????????? ????????????? ?????????????? ?????????
• ?? Exadata
• Oracle Database 11g R2 RAC

20
Sun Oracle Database Machine

• Oracle Database
• Server Grid
• InfiniBand
• Network

Exadata Storage Server Grid
21
Sun Exadata Storage Server Hardware
Dual-redundant, hot-swappable power supplies
24 GB DRAM (6 x 4GB)
12 x 3.5 Disk Drives (600GB SAS or 2TB SATA)
2 Quad-Core Intel Xeon E5540 Processors

• Installed Software
• Oracle Exadata Storage Server Software
• Oracle Enterprise Linux
• Drivers

22
X4170 Database Server Hardware
Dual-redundant, hot-swappable power supplies
72 GB DRAM (18 x 4GB)
4 x 2.5 146GB Disk Drives
2 Quad-Core Intel Xeon E5540 Processors

• Installed Software
• Oracle Enterprise Linux
• Oracle Database 11.2 Software
• Drivers

23
???? InfiniBand

• ?????? ???? ???
• ????????? ? ???????
• RAC Interconnect
• ??????? ???????????
• ?????????????????????? ???? ? ??????? ??????????
  (low latency)
• ?????????? ??????????? 80 Gb/s ?? link (40 Gb/s
  ? ?????? ???????)
• SAN-like Efficiency (Zero copy, buffer
  reservation)
• ??????? ?????????? ??? ? IP ????
• ?????????
• Zero-copy Zero-loss Datagram Protocol (ZDP RDSv3)
  
• Internet Protocol over InfiniBand (IPoIB)

Sun Datacenter InfiniBand Switch 36
24
?????????? ??????????? Infiniband
?????????? ??????????? ?????? ??????????
? 8 ??? ?????????
? 12 ??? ?????????
Gigabit Ethernet
4Gb Fibre
40 Gb Infiniband
25
???? ?????? ????? ??????
Full Rack
Half Rack
Quarter Rack
26
Sun Oracle Database Machine Full Rack
???????????? ???????????? ????? ??????

• 8 Sun Fire X4170 Oracle Database servers(2
  Quad-Core Intel Xeon E5540 Processors 64
  core Per Rack)
• 14 Exadata Storage Servers ( 12 SAS drives,
  600 Gb, 4 96 Gb Flash)
• ?????? ????? ????????? ?? Oracle
• 3 ????, 24 x 7, 4 ???? On-site ?????

27
Sun Oracle Database Machine Full Rack Size

• Size, SAS drives , Warehouse
• Raw size 93 Tb
• After mirroring, User data - 43 Tb
• After Temp space, User Data 28 Tb
• With Adv Compression, User Data 43 Tb
• With Hybrid Columnar Compression
• Query Mode 10x compression
• Archival Mode 15x compression (up to 50x)
• Sun Flash, OLTP
• 14 384 Gb 5,3 Tb
• ??????? ????????? ????????
• ???????? ? ?? Exadata

28
?? 8 ????? ? ????? ??????

• ????? ?????????? ?? 8 ?????
• ?????????????? ?? ????? ???????? ????????

29
?????????? Sun FlashFire

• ???????? ??????????????
• ??????????? ?????? size / ????????????
  ??????????????????
• ?? SSD ????, ?? ????? ??????????? ????????
  ???????????? ??? Flash ??????.
• ??? ???????? ?????????????? ?? OOW
• F5100 flash array ????????????? ? TPC-C ??????
  ?????????????? ????? ?????????
• Sun Flash Accelerator F20 PCIe Card

30
Sun Flash Accelerator F20 PCIe Card

• ????? - 96GB
• 4 x 24GB Flash ???????
• 6 GB ??????????????? ??? ??????????? ??????
• ?????????????? ??? ??????????? ??
• ????????? ????????????? ? ?? Exadata
• 2 ???????? ????? ??????? ????? ????? ?? ????
  (MTBF)
• ? ?????? ???? ?? ??????? ?????????? ???????,
  ????? ???????? DRAM

http//www.sun.com/storage/disk_systems/sss/f20/fe
atures.xml
31
?????????? FlashFire ? Exadata

• Write-though ???, ????????? ???????????? ???
  ????????? ??????
• 4 ???????? (384GB/?????) ???????????? ???
  ???????? ???? ?? ?????? ?????? Exadata
• ????????? ??????? ?????????? ???????????
  3.6GB/sec ?? ???? 4 ???????? ?????? Exadata.
• 50GB/sec ????? ? flash ??? ??????? RACK.
• 21GB/sec ????? ? ?????? ??? ??????? RACK.

32
Flash
50

• Flash storage ????? ??? ? 2 ???? ????????
  ?????????? ???????????
• 50 GB/sec
• ?????? ? ??????? (Hybrid Columnar Compression)
• ?? 50 TB of ?????????? ?? flash
• ??????? ?? ?????? ?????? ??????????? ?? ?????????
  
• 500 GB/sec

?????????? ??????????? GB/sec Uncompressed Data
Flash
Disk
HITACHI USP V
TERADATA 2550
NETEZZA TwinFin 12
SUN ORACLE Database Machine
33
Exadata - ??????? ??????
Single Server Quarter Rack Half Rack Full Rack
Raw Disk1 SAS 7.2 TB 21 TB 50 TB 100 TB
Raw Disk1 SATA 24 TB 72 TB 168 TB 336 TB
Raw Flash1 Raw Flash1 384 GB 1.1 TB 2.6 TB 5.3 TB
User Data2 (assuming no compression) SAS 2 TB 6 TB 14 TB 28 TB
User Data2 (assuming no compression) SATA 7 TB 21 TB 50 TB 100 TB
1 Raw capacity calculated using 1 GB 1000 x
1000 x 1000 bytes and 1 TB 1000 x 1000 x 1000 x
1000 bytes. 2 - User Data Actual space for
end-user data, computed after single mirroring
(ASM normal redundancy) and after allowing space
for database structures such as temp, logs, undo,
and indexes. Actual user data capacity varies by
application. User Data capacity calculated using
1 TB 1024 1024 1024 1024 bytes.
34
Exadata - ??????????????????
Single Server Quarter Rack Half Rack Full Rack
Raw Disk Data Bandwidth1,4 SAS 1.5 GB/s 4.5 GB/s 10.5 GB/s 21 GB/s
Raw Disk Data Bandwidth1,4 SATA 0.85 GB/s 2.5 GB/s 6 GB/s 12 GB/s
Raw Flash Data Bandwidth1,4 Raw Flash Data Bandwidth1,4 3.6 GB/s 11 GB/s 25 GB/s 50 GB/s
Max User Data Bandwidth2,4 (10x compression Flash) Max User Data Bandwidth2,4 (10x compression Flash) 36 GB/s 110 GB/s 250 GB/s 500 GB/s
Disk IOPS3,4 SAS 3,600 10,800 25,000 50,000
Disk IOPS3,4 SATA 1,440 4,300 10,000 20,000
Flash IOPS3,4 Flash IOPS3,4 75,000 225,000 500,000 1,000,000
Data Load Rate4 Data Load Rate4 0.65 TB/hr 1 TB/hr 2.5 TB/hr 5 TB/hr
1 Bandwidth is peak physical disk scan
bandwidth, assuming no compression. 2 - Max
User Data Bandwidth assumes scanned data is
compressed by factor of 10 and is on Flash. 3
IOPs Based on IO requests of size 8K 4 -
?????????????????? ????? ???????? ?? ??????????
35
????????????????? ???????? ?????

• ??? ?? ( DRAM )
• 576 GB ????? ???????
• ?? 4TB ?????? ?????? (HCC)
• 100 GB/sec
• Exadata Smart Flash Cache
• 5TB ????? ???????
• ?? 50TB ?????? ??????
• 50 GB/sec ???????????? ????? ?????
• 1 ??????? ???????? ????-?????/???
• Exadata ?????
• 100TB ?????? ????????????
• ?? 500TB ???????
• 21 GB/sec ????????????
• 50K ???????? ????-?????/???

36
??????????? ???????????
37
Database Machine. ??????????? ???????????

• Oracle 11g R2 RAC ?? 8 ???????? ??
• ASM ???????????? provides ???????????,
  ?????????????? ? ???????????
• ?? Exadata ???????????? ?????????????????
  ?????????? smart scan ?? ????????? via iDB
  protocol

11g Database Server
ASM
Reliable Storage Pool
Exadata
Database Intelligent Storage
38
??????????? Exadata
Single-Instance Database
RAC Database
DB Server
DB Server
DB Server
DB Instance
DB Instance
DB Instance
DBRM
DBRM
DBRM
ASM
ASM
ASM
iDB Protocol over InfiniBand with Path Failover
InfiniBand Switch/Network
Exadata Cell
39
Exadata ? ?????? 100,000 ?????
40
Exadata ? ?????? 10,000 ?????
41
???????? Exadata

• CellSRV
• ????????????? ??????? ???????????? ??? ??????? ??
  ????-?????
• Management Server (MS)
• ????????? web ?????? ??? ?????????? ????????
• CellCLI
• ?????? (Java) ?????????? ??????? ????????????
  ????????? ????????? ??? ?????????? ????????
• RS (Restart Service)
• ???????, ?????????? ?? ?????????? (????
  ?????????) ????????? MS and CellServ.

42
???????? ???????? ??????????

• ?????????? ????? ???????????? ? Cell ?????
• Cell ????? ??????????? ?? ???? ??? ?????? Grid
  ??????
• ?????? ASM ????????? ?? Grid ??????
• ????????? ??? ??????? ASM

ASM disk
Grid Disk 1
CellDisk
Physical Disk

ASM disk
Grid Disk n
Sys Area
Sys Area
43
????????? ???????

• ??? ?????? ?????
• 13GB ?? ?????? ?????
• ??????????? RAID 1
• ?? Exadata , ??, ????? ??? ?????????????? ??????
• 700MB iSCSI ?????????? OCR, Voting Disks
• Celldisk / Griddisk ??????????
• ?????????? 10 ??????
• lt 100MB Celldisk / Griddisk ??????????

44
?????? ????????? ????????? ?????? ASM ?
??????????????
Exadata Cell
Exadata Cell

• ???????????? ??? ASM ??????
• ???? ??? ????? ?????????????? ????? ??????,
  ?????? ??? ????? ???????? ?????
• ASM ???????????? ?????????? ???????? ?????
  ???????
• ASM ?????????????? ???????????? ??? ?????? ??
  ???? ?????
• ??????????? ??? ????? ??? ????? ?????

45
?????? ????????? ????????? ASM ?????????????? ?
???????? ??????
Exadata Cell
Exadata Cell
ASM Disk Group

• ASM ?????????????? ???????????? ???
  ?????????????? ?? ???? ?????? ?????
• ???????? ?????? ASM ???????????? ???
  ?????????????? ???? ????? ??????

46
ltInsert Picture Heregt
??????????? ???????????? ??????????? Exadata
47
????????? ??????????? Exadata
11.2

• ???????????????? ??????????? ?????? ??? ???????
  ????????????? Flash ?????? ??? ????? ????????
  ??????
• ????????????? ?????????? ??????????? ??? ?????
  ???????? ????????
• ????????? ??????????? ?? ??????????
• ????????? ????? ???????????????? ?????? ??
  ??????????
• ???????? ????????????????? ?????? (rebalancing)
  ASM ?? ??????????
• ???????????? ????? ?????? ??????????????
  ???????? ??????????? ???????? ??????? ??
  ?????????? ?????????? ??????? ??.

48
11.2
Exadata Flash

• ???????, ??? ??????? ?????? ???? ????????????
• ALTER TABLE calldetail
• STORAGE (CELL_FLASH_CACHE KEEP)

49
??????????? ?????????? Smart Flash Cache
11.2

• ??????????????? ??????? ??????????????
  ?????????????????? Flash ?? ???? ????????????
  ??????
• Exadata Flash Cache ??????????? ????? ?????
  ????????? ? ???????? ? ??????? ?? flash ????
  ????????????? ? ???????? ??
• Exadata Flash Cache ?? ????????? ??????,
  ?????????????? ?? ?????? Exadata Storage Servers
• ?????????? ???????? ???-?? Exadata Storage
  ???????? ????????? ???????????? ???????? Flash
  ???? ? ???????? ??????? ??????????????????
• ?????????? Smart Scans ???????? ????????? ?
  ??????????? Exadata Flash Cache

50
Exadata ?????????? Flash ?????
11.2
?????????? Flash ?????

• ????????? ????? ??? ??? Flash ?????? ???
  ?????????? ?????????? Flash ????
• ?????? ?? ???????? ??? ??????? ????
• ???????? ???????? ?????? ASM ????????? ??
  ?????????? Flash ??????
• ?????? ????????????? ????????????? ASM ?? ????
  ?????? ? ?????? ?????? ?? ?????? ?????? Exadata
  Storage ????????
• ??????? ?????????????????? ??? ?????????? ?
  ??????? ??????????? ???????? ??????

51
?????????? ?????????????????? Flash

• ???????????? ??????????? ???????? Oracle
• AWR
• Enterprise Monitor
• ????????? ??????
• db_file_sequential_reads ??????????....
• cell single block physical reads

Avg
wait DB Event
Waits Time(s) (ms)
time Wait Class ------------------------------
------------ ----------- ------ ------
---------- cell single block physical rea
2,029,590 1,223 1 31.7 User I/O DB
CPU
822 21.3 gc cr grant 2-way
2,161,346 805 0 20.9
Cluster cell multiblock physical read
170,707 719 4 18.7 User I/O gc cr
multi block request 2,533,564 340
0 8.8 Cluster
52
???????? ??????? ?? ??????? ????????? (Smart Scan)

• ?????? Exadata ????????? ???????? ????????
  ???????? ?? ??????? ????????? (scan offload) ?
  ???, ????? ??????????? ????????? ????? ??????
  ???????????? ?? ??????? ???????? ??
• ?????????? ????? ?? ?????? where ?????????
• ?????????? ???????
• ?????????? ?????????? (join)
• ?????????? ???????????????? backup
• ?????????? ????????????? ??????
• ?????? ? ????????? Data Mining
• 10x ?????????? ?????? ???????? ??????? (??
  ?????? ??????????)
• ????????? ????????? ??? ??????????
• ???? ???? ?????????? ???? ?????? ??? ????? ??
  ????? ???????

11.2
11.2
53
???????????? ????????? ????????

• ?????? ???????, ??????? ????? ???? ???????
  ?????????
• ???????????????????? ???????? ?????
  ???????????????? ??????????, ??????? ?????? ?????
  200 ?? ???????????? ??????
• ?????????? ? ????? ?????????? ???????? 2MB ? 1
  ??????????? ???????
• ? ???????????? ??????????, ??? ?????? ????? ??
  ??????? ??
• ????? ??????? ??????? ?????? ????? ???????? ???
  ????????? ?? ??????? ??????? ??
• ???????????? ?????? ?????????? ??????? ? ? ??????
  ?? ?????????????????? ? ?????

? SELECT customer_name FROM calls WHERE amount gt
200
? Rows Returned
? DB Host reduces terabyte of data to 1000
customer names that are returned to client
? Table Extents Identified
? I/Os Executed 1 terabyte of data returned to
hosts
? I/Os Issued
54
????????? ? ?????? Smart Scan
? SELECT customer_name FROM calls WHERE amount gt
200

• ?????? ????????? ???????
• customer_name
• ? ????????? ??????
• where amountgt200
• ???????????? ??????? ??
• ??? ?????, ??????????? ?? ?????????? ??????
  ???????? ?? ??????? Exadata ????????
• ??????? ???????? ???????????? ?????? ?? ???????
  ???????? ????????? ???????????? ??? ???????? ?? ?
  ????????? ???-?? ???????? ?????????

? Rows Returned
? Consolidated Result Set Built From All Cells
? Smart Scan Constructed And Sent To Cells
? Smart Scan identifies rows and columns within
terabyte table that match request
? 2MB of data returned to server
55
???????????? ?????????? Smart Scan ??? ??????????

• Smart scans ????????? ??? ??????????
• ?? ????????? ????????? ?????????? ??? SQL ????
• ???????????? ?????? ????????? ????????????
• ? ?????? ?????? ?? ????? ?????? ?? ????? smart
  scan ????????????? ????? ??????? ?????????
  ???????????????? ?? ??????, ?????????? ?????
  ??????
• Smart Scans ????????? ???????????? ?????????
  ??????
• ???????????????? ?????? (uncommitted) ?
  ??????????????? ??????
• ??????? ????? (chained rows)
• ?????? ???????
• ????????? ???????????? ??????
• ?????? ? ??????
• ?????????? ?????????
• ?????????????????? ???????

56
???????? ??????? data mining ?? ??????? Exadata
11.2

• Data mining ?????? ?? Exadata
• ??????? Data Mining scoring ????????????? ??
  Exadata
• ??????? ?????????????????? ?? 10x ???
• ????????? ?????????? ??? ?? ??????? ??????? ??

57
????????? ?????????? ??????hybrid Columnar
Compression (1-3)
New

• ?????? ???????????? ?? ???????? ? ????? ?????????
• Query Mode ??? ???????? ??????
• ?????????????? ??? ???????? ???????
• 10X ??????
• ????? ???????????? ??????????? ??????????????
• Archival Mode ??? ????? ???????????? ??????
  ?????????????? ??? ?????????? ????????? ?????
• 15X ??????
• ?? to 50X ??? ??? ????????? ??????

58
????????? ?????????? ??????hybrid Columnar
Compression (2-3)

• ?????????? ???? ??????
• ?????????? ?????????, ?????????? ????????? ??????
  ??????
• ?????? ???????????? ?? ???????? ?? ????? ????????
• ?????? ??????? ????????? ????????
• ??? ?????? ??? ???? ??????? ??? ???? ???????,
  ???????? ? ? compression unit
• ?????? 32k (4 blocks x 8k ?????? ?????)

59
????????? ?????????? ??????hybrid Columnar
Compression (3-3)
60
???????? ?????????? Oracle Production E-Business
Suite
52

• ???????????? ??????????? ??????
• Query 14.6X
• Archive 22.6X
• ??????? ?? ??????????

61
???????? ?? ??????

• ????? ???????? (advisor) ? 11g Release 2
• DBMS_COMPRESSION PL/SQL ?????
• ????????? ??????? ?????? ? ??????? ?????????
  ?????????? ?????????? ?? ??-Exadata ??????
• ??????? ????? 8937922

62
New
??????? ?? ??????? ??????????????????
???????????? ??????

• Exadata ??????? ?? ??????? ????????? ????????????
  ?????? ? ????????????? ?????? ? ???????? ?
  ??????
• ?????? ??? ? ???? ???????? ??? ?????? ???????
• ?????? ???? ?????? ? ??????? ??? ??????? ??
  ?????
• ????????? ????-????? ??? ??? ??????, ??? ??? ?
  ???? ?? ????????????? ??????? where
• ????????? ????????????? ? ?????????

???????
???????
A B C D
1
3
5
5
8
3
Min B 1 Max B 5
Min B 3 Max B 8
63
ltInsert Picture Heregt
??????????? 11g R2
64
HP BladeSystem c-Class 128P RAC with Oracle
Exadata Storage Servers using 11g Release 2 with
Oracle Real Application Clusters, Partitioning,
Advanced Compression, Oracle Enterprise Linux
cell_offload_processing false
http//tpc.org/tpch/results/tpch_perf_results.asp
65
???????????? ?????????? ? ??????
66
??? ????????

• ???????? ??????? ?? ????????????? ???? ??????????
  ?? ???????
• ????????? ????? ???????? ???? ?? ? ???????
  ???????
• ??????? ????????? ? ???????
• ??? ????? ?????? ????????
• ? ????? RAC ????????? ???????? ????????????? ?
  ???? ?? ?????? ???????? ??????????
• ???????? ?????????? ?? ?????? ????? ? ??????
  ????????
• ????????????? ????????????? ?????? ????? ? ??? ?
  ?????? ? ????? ??????? ????????????
• ?????? PX ??????? ?? ??? ?? ???? ?????
  ??????????? ? ??????? ????????? ???????

67
??? ???????? ? ?????????
??????? ??????? ???????? ??? ?????????????
?????????? ? ??????
?????????? ?????? ???????
????????? ??????? ???????? ? ??? ??????? ??????
SQL??????
?????? ???????????? ??????? ?? ??? ?? ????
???????? ?????? ? ?????????? ???????
68
?????????? ???????????? ??????????? ? ??????

• ??????????? ?????????? PARALLEL_DEGREE_POLICY
• ????? ??????? ?????? ????? ????? ? ???????? AUTO
• ??? ??????????? ?????????

69
New
?????????? ????? tpc.org
QphH 1 TB TPC-H

• ???? Oracle Database Machine ????
• 400GB ?????? ????????? ??? ???????????
• ????????? ?????????? ?????????? ?????????
  ???????? 4TB data in ??????

??????? ??? ?????????????????? ??? ????????? ?
?????? ??
DRAM ? 100x ????? ?????????????? ??? ?????
70
DBFS ?????????????? ??????????? ???????? ???????
New

• Database Machine ???????????? ? DBFS
  ??????????? Linux ???????? ???????
• ??????????? ???????? ??????? ??? ETL staging,
  ????????, ???????
• ????? ???????? ??? SecureFile LOBs ? ???????? ??
  ? Exadata
• ???????? ??? ??? ? ????? ?????? ?????? ??
  ??????????????, DataGuard, Flashback.
• ?????????????????? ?? 5 ?? 7 ??/???

???????? ? ?? ????????? External Tables
ETL Files in DBFS
ETL
????? ??????????????? ??? ???????????? High-End
NAS Filer
71
??????????
72
?????? ?????? ??????

• ? ??????????? Exadata Storage ??? ?????? ?????
  ????
• ?????????? Hardware Assisted Resilient Data
  (HARD) ???????? ? Exadata Storage
• ????????????? ??????????? ????? ?????? ?? ????,
  ??? ??? ?????????
• Data Guard ???????????? ?????? ??????, ? ???
  ????? ????????????? ??????????????, ????? ??????
  ?????? ?? ???????????
• ????????????? ???????????? ???? ??? ?????
  ????????? ??? ??????
• ???? ????????? ?????????? ???????????? ?? ?
  ???????? ????????? ?? ?????? ????????? Exadata
• ?????????? Flashback ????????????
• ?????????? ???????? ?? ?? ????? ?? ??????
• ????????? ??????????? ?????????????? ? ???????
  RMAN
• ?????????????? ? ???????? ?????? ?? ???????????
• ????? ?????????????? ? Oracle Secure Backup
  (OSB) or ?? ??????? ????

73
?????? ??????????????? Exadata ? ????????????
????????

• ?? ????? ??????????? ?? Exadata ? ????????????
  ?????????
• ????????? ???????????? ????? ????????????? ??
  Exadata, ???????????? ?????????, ??? ??????????,
  ? ??? ????????? ??? ??????????
• ??????? SQL ????????? (offload processing)
  ??????? ????? ??? ????? ?????????? ????????????
  ????????????? ?? Exadata
• ???????? ?? ????, ???? ?????? ???????????? ASM ?
  ??????? ?????????????? ASM
• ???????? ????? ??????????? ? RMAN or Data Guard

Database Server
74
?????? ??? ???????????? ??

• ??????????? ??????????? ????????? ????? ????????
  ? ????? ???????
• ????????? ??? ???????? ????????? ??????
• ?????????????? ??????? (OLTP)
• Sun Oracle Database Machine ????? ????????????
  ????? ??? ?????????? ? ??????? ???????????????????

ERP
CRM
Warehouse
Data Mart
HR
75
Oracle Database 11gR2 Exadata

• Exadata ????????? ??? ???????????? ??????????
• ??????????? ???? ??? ???? ?????? ? Oracle
• ????????? ??????????? ???? ??? ??????????
• ??????????? ??????????
• ? ???????? Oracle
• ? ???????? ?????????
• ???????? ??? ????????? ??????????
• ?????????? ?????????? Exadata ? ????????
  ????????? ? ??? ???????????? ???????

76
??????? ?????? Oracle CIS Email
Dmitry.Volkov_at_oracle.com Phone 7 (495)
641 14 00 Direct 7 (495) 641 13
56 Mobile [phone]
http//dsvolk.blogspot.com http//www.dsvolk.ru/o
racle/wp/tech/index.htmlexadata