Grid

1
Oracle Database 10g ????? ?????
???????????? ?????? ????? ??????????
????????????????? Oracle
2
???????? ???? Oracle 10g

• ??????? ?????????? ?????????
• HW
• SW
• ?????????????????
• ?????????? ??????? ???????? ????????????
• ??????????????????, ????????????????, ??????????,
  ???????????, ?????? ??????

3
???????? ??????????? ?????????????? IT

• ???????? ?????????????? ????????
• ????????? ???????????
• ????????? ???????????
• ??????? ?????????
• Hardware - 21
• ????? - 40
• ?? - 24
• ??? ??? 85 ??????? IT
• ?????? ????????????? ? ???????????? ?
  ???????????? ???????
• 20 ??? CPU, 50 ??? ??????

CRM
ERP
DW
4
??????? Computing On Demand
Mainframe ??????
Grid Computing ??????

• Partitioning ?????? ???????? ???????
• ?????????????????? ??????? ????????
• ??????, ??????????????? ??
• ?????????????????? ?????? ?? ??????? ????

• ????????????????? ????????????? ?????????
  ????????? ????????
• ???????, ???????????, ????????? ????????
• ????????, ??????, ??????????????? ??
• ?????????????????? ?????? ?? ?????? ????

5
?????? Grid ?????????? Oracle

• ????????????? ? ????????????? ????????(Virtualiza
  tion Provisioning)
• ??????????? (Pooling)
• ?????????????(Self-Adaptive software)
• ????????????? ??????????(Unified management)

6
Oracle Database 10g ???? ??? Grid

• Virtualization Provisioning Pooling- ASM,
  RAC
• Information Provisioning- Transportable
  tablespaces, Streams
• ?????????????- AWR, ADDM, Scheduler, ???.
  ???????????? ??? ??????
• ????????????? ??????????- Oracle Enterprise
  Manager Grid Control

7
Oracle Database 10g ????????? ??????? ????????
?? ?????????? ???????

• ???????? ???????? ???????? ??????
• ??? ?????? ?????? ???????????? ???? ?? 50 ?
  ?????? ?? 30 ? ???
• ??????? ?????? ???????????, ????????? ??????
• ?????????????????, ??????? ?????????? ????????
• ???????????? ??????????/???????? ??????

8
Automatic Storage Management ????????????
?????????? ?????? ? ????????? ?????/??????

• ???????????, ?????????????????????? ????????
  ???????
• ?? ????? ???????????? ???????? ??????? ? volume
  manager
• ?????????????? ??????????????
• ?????????????? ????????? ?????/??????
• ???????????? ?????? ?? ??????, ?????
  ?????????????? ????????
• ??? ????? ?????? ??????????? ????
• ????? ??? ???????? ???????????? ?? ?????? ???????
  ? 1 ?

9
???? ??????????
ASM
???????
Tables
Tables
Tablespace
Oracle ASM
Tablespace
Files
Files
File System
File System
Logical Vol
Logical Vol
Disks
Disk Group
?????? ?????? ??????? ????????? ??????????
????????? ?????????
10
????????? ???????? ?????????? ????? ? LVM ? ASM

1. ???????? ???? ? OS
2. ??????? ?????????? ???? ? ??????? Volume Manager
3. ??????? File System ?? ?????????? ????
4. ??????????, ????? ?????? ??????????? ?? ?????
   ????
5. ??????????? ????? ?? ????? ????
6. ????????????? ????? ? ???? ??????
7. Re-tune I/O

1. ???????? ???? ? OS
2. ????????? Add Disk ??????? ? ASM

11
Automatic Storage Management ???????? ??????
8
13 ????? ?????? 40 !
7
7
6
6
6
5
4
2
2
0
0
12
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????

Disk Group
13
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????
• ?????? ????????????? ??????????? ???????????????
  ?? ????? ????????

Disk Group
14
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????
• ?????? ????????????? ??????????? ???????????????
  ?? ????? ????????
• ???????? ??????? ??????? I/O

Disk Group
15
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????
• ?????? ????????????? ??????????? ???????????????
  ?? ????? ????????
• Online ???????? ?? ????? storage

Disk Group
16
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????
• ?????? ????????????? ??????????? ???????????????
  ?? ????? ????????
• Online ???????? ?? ????? storage

Disk Group
17
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????
• ?????? ????????????? ??????????? ???????????????
  ?? ????? ????????
• Online ???????? ?? ????? storage

Disk Group
18
ASM - ???????????? ????????????

• ?????????????? ???????????? ?? ???? ??? ?????
  ?????????? ????????????
• ?????? ????????????? ??????????? ???????????????
  ?? ????? ????????
• Online ???????? ?? ????? storage

Disk Group
19
ASM ???????????
ASM Instance
NonRAC Database
Oracle DB Instance
Server
Pool of Storage
Disk Group
20
ASM ???????????
ASM Instance
ASM Instance
Oracle DB Instance
Oracle DB Instance
RAC Database
Clustered Servers
Clustered Pool of Storage
Disk Group
21
ASM ???????????
ASM Instance
ASM Instance
Oracle DB Instance
Oracle DB Instance
RAC Database
Clustered Servers
Clustered Pool of Storage
Disk Group
Disk Group
22
Oracle DB 10g ULDB - ?????? ??? ???? ??????

• ?????? ?? ???????? ?? ????????? ???????? (8
  Exabytes)
• Ultra Large Data Files ????????? ? 1 ?????
• ?????????????? ?????? LOB ??????? - ?????????
• Automatic Storage Management ??????? ???
  ??????????? ???????? ???????

23
????????? ?? ?????????? ???????

• ???????? ???????? ?????????????? ????????
• ??? ?????? ???????????? ????? ?? 15
• ??????? ?????? ??????????? ????????
• ?????? ?????????, ??????? ??????????????????
• Capacity on demand

24
Oracle Database 10g RACCapacity on Demand ???
Grid

• ???????????? ?????????? ????, ??????? ?????????
  ???????? ?????????? ? ?????????????? ??????
• ??????? ??????????
• ???????? ?? ??????????? ??????? ????????
• ????????
• ????? ???????????
• ?????????????? ? ???????? ????????????

ERP
CRM
DW
25
Oracle Database 10g RAC -??????, ???????????????
Clusterware

• ?????? ??????? ??? ???????? ?? Oracle
• Single-vendor support
• ??????
• ?? ???? ???????? ?????????????? ??
• ????? ?????????? ?
• ?????????
• ??????? ???????? ? ???????????????? ?? ????
  ??????????
• ????????? clusterware ?????? ????

26
?????????????? ??????????? ?????????
(Provisioning)

• ??????????/???????? ??????? ? ??????? ???????? 1
  ??????
• ?????????????? ?????????? ? ??????????????
  ???????? ? ???????
• ?????????????? ??????????? ?????????? ?? ?????? ?
  ???????? ? ??? ?????????
• ?????????????? ??????????? ?? ?????? ???????
  ??????? ??? ???? ???????
• ???????? ?? ???? ??????????

27
???????????? ???????? ?? ?????? ???????

• ???????? ???? ?????? ? ??????? ??????????
• ??????????/???????? ??????? ? ??????? ???????? 1
  ??????
• ???????????? ????????????? ???????? ?? ??????? ?
  ?????????????? ??????
• ?????????????? ????????????? ???????? ??
  ????????????
• ? ?????? ?????? ??????? ???????????????
  ???????? ?? ????????? ???????
• ??? ????????? ?????????? ?????????????????
  ???????? ?? ???????

28
Flashback Database

• ????? ????????? ??? point-in-time recovery
• Flashback Log ?????? ?????? ?????? ??????????
  ??????
• ????? ????????????? ??? ??? ??????????? backup
• ????????? ?????? ??????, ????? ???????????? ??
  ?? ?????? ??????? ? ???????
• ????????????????? ?????? ?????????? ?????
• ?????? ?????????????? ?? ?????? ? ?? ????
• ????? ????? ???? ???????
• SQLgt Flashback Database to 205 PM

?????? ?????? ?????
Disk Write
????? ?????? ?????
Flashback Log
??? Rewind ?????? ??? ??
29
Flash Backup

• ????????? ?????????????? ???????? backup ?
  recovery
• ????????????? ? ??????
• ?????? ??????????????? backup ???????? (rolls
  forward) recovery area backup
• ? ???????? ?? ????????????? ?????????? ?????
• Full scan ?? ?????
• ??????? ??????? (20x)
• ????? ???????????? ??????? ???????? ?????? ATA
  ??? recovery area

Database Area
Recovery Area
?????
30
Oracle Database 10g ??????? ?????? ?????? ???
?????? ?????????
31
??????? ?? ?????????????
????????-??? 6
?????? 15
???????? ?????? 6
????????? ?? 6
??????? ?????????? ???????? ? ?? ????????? 55
Source IOUG 2001 DBA Survey
32
Oracle Database ?????

• ?? ??????????? (High Availability)
• ?? ????????????????
• ?? ??????????????????
• ?? ????????????
• ?? ??????????
• ?????, ?????,????? ????,
• ????????????? (Manageability)
• Oracle Database 10g ?????? ? ??? ?????????
  ????????

33
Oracle Database 10g

• ??????????????? ????

34
??????????????? ????

• ?????????? ??????? ?????????????? ?????????????
• ??????????? - ????????? Automatic Workload
  Repository
• ????????? ???????? - ????????? Automatic
  Maintenance Tasks
• ???????? ????????? ??????????????? ????????
  ?????????
• ???????? - ????????? Advisory infrastructure

Application SQL Management
Storage Management
System Resource Management
Space Management
Backup Recovery Management
Database Management
Intelligent Infrastructure
35
Oracle10g System Management Automatic
Diagnostic Monitor (ADDM)

• ????????????? ?? ?????????????????? ( timewaits)
• Performance expert ?? ???????
• ?????????????? ??????????? ?????????????????? ??,
  ??????? RAC
• ?????? ??????????? ??????? ? ?????????????
  ????????
• ?????????????

36
Oracle10g System Management ??????????
???????????????? ??????????????

• ?????????????? Workload Repository
• ????????????? ???????? ??????????, SQL workload,
  ????????????? ?????????
• ?????????? ?????? 30 ???
• Statspack
• ????? ???????? ?? ??????? (?????? ?????? SQL)
• ????????????? ????????? Maintenance Tasks
• ??????????????? ( Pre-packaged), Maintenance
  Window
• ???????????? ???????? ???????
• ????? ????? ?????????, Push vs. Pull, ??????????
  ? ???????? ? ??? ?? ??????
• Advisory Framework

37
Oracle10g System Management ??????????????
?????????? SGA

• SGA_TARGET ????????
• Advisor ???????? ?????????? ?????????
• ????????????? ?????? ??????? ??? ?????????
  ????????
• ???????????? ????????????? ????????? ??????
• ??????? ????-???????? ? SPFILE ??? Shutdown

38
Oracle10g System Management ?????????????
SQL

• ?????????????? ??????????? ? ?????? ??????
  ??????????? SQL-??????????
• ?????????????? ????????? SQL ??????????????
  ?????? SQL
• SQL Access Advisor

High-load SQL
PackagedApplications
CustomApplications
Optimizer
Auto SQL Tuning
Auto SQL Analysis
Access Advisor
Indexes MVs
CustomApplications
?????? ??????????? SQL
39
???????????? ? ?????? ????????????

• ?????? ?????????? ? ???? ?? Oracle
• ??????
• ?????
• ??????????? ???????????? ????????? Oracle
• ????? ? ????????? ????????????
• ???????????? ?????????, ???????
• ????????? (?????????) ????????????
• ?? ?? ??? ??

40
Scalable Software Maintenance ??????????????
???????????? ??

• ????????? ?????? ???? ?? ??????????? ??
• ? ????? ?? ?????
• ?????????????? ???????? ????????????? ?????????
  ????????????

3
?????????? Inventory
41
Scalable Software Maintenance ??????????????
?????????? ???????

• ??????????? ????? ?????? ? ???????? ???????
• ????????????? ?????????? Security patch ?????????
  ?????????? ???????
• ?????????????? ??????? ? ??????????
• ? ????? ?? ?????
• Rolling RAC upgrade

?????????? ????????????
2
4
???????? Inventory
1
Patch ???????????
42
Oracle10g Data Pump

• ?????? ???????????????? ?????? ? ???????
• 60 ???????, ??? 9i ??????? (single thread)
• 15x-20x ???????, ??? 9i ?????? (single thread)
• ??????????????????
• ??????????? ?????? ????? ?? ??? ??????????????
  ??????????
• ????? ?? PL/SQL
• Restart c ????????

43
Oracle Streams Oracle
Oracle Streams ?????????? ??? ????????tablespaces
???????, ??? FTP
???????????, ???????????, ???????????? ????? 1
????????
????? ??????? ???????????
44
HTML DB

• ?????????????????? ???????????? ???? (Access)
• ?????????????? Enterprise ????
• ??????? ??? Web
• ???????? ? Grid
• ??????? ????????? ???????????? ??? (????????????,
  ??????????, ????????????????, ??????????
  ?????????? ??????????)

45
??????
? Oracle 10g ???? ????????? ????? 300 ?????
????????????

• ??????? ???????????
• (1?D, 20 ???, 256M ??, RAC, Standby, ???????? ??
  ? ??????)
• ??????? UPGRADE
• (???????? ????????, ??? ? ???? ????????,
  ??????????? ??, ??? ???????)
• ????????? 28 ??????
• Flashback DROP
• Unified Scheduler
• ?????? Rule Base Optimizer
• ?????????????? ???? ??????????

• ?????????? ?????????
• ?????????? External table
• Object Space Advisor
• Segment Advisor
• Segment Shrink
• Tablespace rename