Corporate PPT Template - PowerPoint PPT Presentation

Loading...

PPT – Corporate PPT Template PowerPoint presentation | free to download - id: 66d565-NTIxN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Corporate PPT Template

Description:

Senior Principal Consultant DB Tech. Team Oracle Corporation Agenda 1. Technology Evolution 2. Enterprise GRID 3. Oracle 10g GRID Computing 4. – PowerPoint PPT presentation

Number of Views:77
Avg rating:3.0/5.0
Slides: 78
Provided by: downWowun
Learn more at: http://down.wowunix.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Corporate PPT Template


1
(No Transcript)
2
? ? ?
  • Senior Principal Consultant
  • DB Tech. Team
  • Oracle Corporation

3
????? ?? ??? 10g ???
2003.12.22
4
Agenda
  • 1. Technology Evolution
  • 2. Enterprise GRID
  • 3. Oracle 10g GRID Computing
  • 4. Oracle 10g Performance
  • 5. Oracle 10g Summary

5
Technology Evolution
6
???? ?? ??
90??/2000? ? Web Server ?? 3-Tier ?? JAVA
?? B-to-C/B-to-B ERP/CRM e-Business ??
????? RDBMS
JVM??(EJB,CORBA)
Fine-grained access
control Materialized View
90?? ?? OLTP/DW ?? ???/APP?? GUI Tool ???? ?? ?
?? ????? ???
?
Internet Platform
2001?/2003? e-Business ???? ?? ??? ? ?? ??? ??
(Extend Market Globalization) DBA ???
?? On-Line Management e-Business? ?? ?? ??
Internet
ObjectRelational
Relational
7
??? ?????? ???
  • ????? ???? ????
  • ????? ??? ?? ?? ????
  • - ???? ??? ? 18???? ? ??
    ??
  • - ????? ??? ? 9???? ?
    ?? ??
  • 1986?? ?? 2000??
  • - ??? ?? 500? ??
  • - ???? ?? 340,000? ??
  • 2001?? ?? 2010?? ?

Optical Fiber (bit per second)
Doubling Time (months)
Performance per Dollar Spent
9 12 18
Data Storage (bit per square inch)
Silicon Computer Chips (number of transistors)
0 1 2 3 4 5
Number of Years
8
?? 20? ??? ????? ? ????? ??
9
?? ?? ??? ?? ????
  • ?? ?????? ?? ?? ???? ??? ?? ??? ??? ???
  • ?? ?????? ??? ??? ?? ???? ??
  • - ??? ??? ??, ??? ???, ? ???

10
?? ??? ??? ??
Server Revenue Mix
18
16
14
12
10
Share of Revenues
Legacy Big Iron Apps
8
6
4
Scale Out
Scale Up
2
0
0-2.9K
3-5.9K
6-9.9K
10-
25-
50-
100-
250-
500-
1M-3M
3M
24.9K
49.9K
99.9K
249.9K
499.9K
999.9K
Price Band
  • ??? Scale-Up ? Scale-Out ??? ??? ??
  • ??? ??? Scale-Out? ????? ???
  • ??? Bandwidth???? ?? ??? ?????? ?? ??

11
Frank E. Gillett Forrester Research, October 2002
12
?? IT? ??
13
??? IT????? ??
CIO ???? ??? ?? ???? 60? ??? ??. -
Forrester Research IT? ?? ????? 75??? ???? ?
????? ???? ??. -
Business Week IT? ????? ????? ????? ???? ????
??. -
IDC ???? ??? ?? ????? ?? 20??? ??? ??? ? ??.
- Giga Research
14
IT??? ?? ??
  • ??? ??? ??? ??
  • ???? ??? ??
  • ???? ??
  • ?? ??? (point one nine 99.x )
  • ?? ??? ??? ????
  • ??? ? ??? ROI

15
Enterprise GRID
16
??? ???? ??
? ?? ?? ???? ??? ?? ?? ?? ??? ??? ???? ????
??? ??? ??? ??
17
Oracle 10g ? ?
Oracle Database 10g ???? ?? ??? ??? ??????

18
Oracle 10g ?? ??
  • Application Server Grid
  • Database Grid
  • Storage Grid
  • ??? ??? (Self Managing DB)
  • ???? ?? ??? ?????
  • ???? ??? ??
  • ??? ???? ?????? ??

19
Oracle 10g ??
  • ??? ??
  • ??? ?????
  • -???, ???, ????, ???, ???
  • ??? ??? ??
  • - ??? ?? ????? ??? ??? ???
  • ? ?? ??? Self-managing
  • - ???? ??/?? ? ???? ??? ??

20
???? ??? ???? ?
??? ?? ??? Enterprise Grid Computing
11
21
??? ???? ?? ??
  • ?? ? ??? ??? ???
  • - ?? ???? ???
  • - ?? ???? ????
  • ? ??
  • - ????
  • - ?????
  • - ?????
  • ??? ????? ?? ??? ???? ???.

22
??? ??? ??? ?? ????
  • ???? ? ?? ???? ???
  • ??? ? ??? ?? ??
  • ???? ????? ????
  • ??? ??
  • ???? ??? ?? ?????
  • ??? ??? ??? ??

23
??? ???? ?? ??? IT ??? ?
  • ?? ??? ?? ?? ?? ??
  • ???? ?? ??????
  • 14?? CPU ? ???? ???? OS
  • ???? ?? ??? ??
  • ??? ????? ????

Why Now.. Grid
??? IT??? ??? ???? ??? ??? ???? ?? !
24
??? ??? ???
25
IT ??? ??
??? ????
??? ???
  • ??? ???? ??
  • ?? ??? ??? ??
  • ?? ?? ??
  • ? ??? ?? ???
  • ? ??? ???? ??
  • ?? ??? ??? ??
  • ?? ?? ??
  • ? ??? ?? ???

26
???10g ????
27
Oracle10g GRID Computing
28
??? ??? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
29
???? ???? ?? (ASM)
  • ??? ???? ? ?? ???? ?????
  • ???? ??? ????? ??? ?? ???? ???
    ??(Striping)
  • ?? ???? ??? ?? ???
  • 3rd Party ?????? ????? ?? ??? ??

Automatic Storage Management
30
ASM ?? ????? ? ???? ??
  • ???? ? ????? ?? ?? ??? ????? ?????? ????
  • ????? ?????? ???? ???
  • ????? ??? ??
  • ??? ??? ?? ? ??
  • ?? Rebalancing

31
ASM? ??- ?????? ??
Add Disk
1.OS? Disk ?? 2.Add Disk ?? ??
  • 1.OS? Disk ??
  • 2.Volume Manager? ?? ?? ??
  • 3.??? ??? ?? File System ??
  • 4.??? Disk? ??? ??? ??
  • 5.??? file? ??? ??
  • 6.Database file ?? ??
  • 7.I/O tuning ??

ASM
32
ASM? ?? DBA? ?? ??
33
ASM? ??- ???? ????
DBA? ?? ?? ??? ?? (100GB ??? ??????? ???? ??? ??)
Disk Capacity
Capacity /DB Adm
Capacity in Terabytes
Mgmt Gap
Strategic Research Corporation
34
??? ?? ?????
?? ?????
  • ???? ?? ?????? ?????? ???
  • ??? ???? ??
  • ???? ?? ? ???? ??
  • ?? ?? ??? ?? ??
  • ??, ??, ????

35
????? Transportable Tablespaces
??? ?????? ?? unplug ? plug?? ?
  • ?????? ???? Unload / Reload?? ??
    ???? ?? ??
  • Plug/unplug ??? ??????? ??? ????
  • ?? ?? ??????? ???? ????????
    ??? ? ? ??

New ??? ?????? Plug/Unplug? ????? !!!!
24
36
Oracle 10g Data Pump
???? Import / Export
  • Oracle9i export?? 60 ?? (single thread??)
  • Oracle9i import?? 15??? 20? ??(single thread??)

?? ???? ?? ?? ?? ??
?????? ??? ???????? ????? ?? ??
??? ??
37
Oracle 10g Streams
  • FTP?? ?? ????????
  • ?? ? ??
  • ??? ???? ?? ??, ??,
  • ?? ????
  • ???? ???? ????
  • ??? ????? ? ??? ??
  • self-propelled ?????? ?? ??

38
Provisioning Data in the Grid
Clustered database Instances
BladeRack
SAN 1
SAN 2
SAN 3
SAN 4
39
??? ??? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
40
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
Test
??? ??? ?? ??
41
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
????? ??
42
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
????? ?? ??
43
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
Test
??? ????? ???
44
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
Test
?? ?? ??
45
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
??? ??
46
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
2? ?? ????
47
??? ??? ???? ?? (Workload Management)
Reporting
Order Entry
????? ?? 2? ??
48
??? ??? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
49
????(Policy-Based) ????
  • ?????? ? ?????? ?? ???? ??
  • ?? ??? ??? ??? ??? ????
  • ??? ??? ?? ?? ???
  • ?? ??? ?? ????? ???
  • ????? ??? ?? ??? ? ??

50
??? ??? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
51
? ??? ??? ????
Oracle RAC
?????? ??
Gigabit Ethernet
Fiber Channel
?? ???
52
? ??? Oracle 10g RAC
10 Gigabit interconnector
53
InfiniBand ???? ??? ??
Network Level Cluster Performance for Oracle RAC
Block Transfer/sec (16KB)
InfiniBand delivers 2-3X higher block
transfers/sec as compared to GigE
54
? ??? - ??
  • ?? ??? ??? ??? ?? ? ??
  • ???? (Flash Back) ??
  • ??? ?? (Data Guard)
  • ?? ???????? ??? ????

55
????(Flashback) ????
?? ??? ?? ??
??????
  • ?????? ??
  • ???? ??????? ??? ??? ???? ?? ??????? ??
  • ???? ?? ??
  • ??? ??
  • ???? ???? ??? ??? ???? ?? ????? ???? ??
  • ??????? UNDO ??
  • ???? Drop? ??? Drop? ??? ? ???? ??? ? ??.
  • ?? ??
  • ???? Query? ??? ??? ???? ??? ??

56
Mid-Tier ???? ??? ??
57
??? ??? ?? ?????
Patch
B
A
B
A
B
1
2
Clients on A, Patch B
Initial RAC Configuration
Patch
A
A
B
B
A
4
3
Clients on B, Patch A
Upgrade Complete
58
??? ??? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
59
DBA? ????
Create Configure
Load Data
6
Install
12
6
55
Ongoing System Management
6
Software Maintenance
Source IOUG 2001 DBA Survey
60
????(Self-Managing) Oracle Database 10g
  • ??? ????
  • ?????? ? SQL ??
  • ???? ??
  • ???? ??
  • ?? ? ?? ??

?? ????
Reduce Capital Expenditure
?? ???? ??
61
????(Self-Managing)
Oracle Database 10g
62
????(Self-Managing) ??????
Application and SQL Management
EM??
SystemResourceManagement
StorageManagement
AutomaticManagement
Monitor
Alert
Fix
Advise
Backup andRecoveryManagement
SpaceManagement
Common Infrastructure
63
??? ??? ????
?? ???? ????? (Workload Repository )
  • ????? SQL ??, ?? ?? ?? ?? ?? ???? ??
    ???
  • Base-lining capability

?? ????
  • Pre-packaged, resource controlled

64
Automatic Workload Repository
ADDM finds top problems
MMON
SYSAUX
WR Schema
BG
In-memorystatistics

700 a.m.
Snapshot 1
BG
730 a.m.
Sevendays
AWRStatistics
Snapshot 2
800 a.m.
ASH
830 a.m.
FG
Snapshot 3

Snapshot 4
FG
SGA
830am
DBA
65
?? ?????? ?? ?? ?? (ADDM)
A
D
D
M
utomatic
atabase
iagnostic
onitor
  • ?? ??? ?? ??? ??
  • ??? ??
  • ?? ?????? ?? ?? ??? ??
  • DB?? DBA
  • ?? ?? ??
  • ??? ?? ????

??? ??? ?? ? ??? ??
  • ?????? SQL
  • ????
  • ?? ? ??
  • ????
  • ?????

66
Enterprise Manager Grid Control
  • Monitor and manage
  • Grid-wide view
  • End-to-end
  • Top-to-bottom
  • From anywhere

Manage from a Browser
EM2Go or a PDA
67
Enterprise Manager ????
Host and Hardware
Database 10g
Administration Monitoring Provisioning Security
Network and Load Balancer
Oracle10g AS
Storage
Applications
Enterprise Manager
68
Oracle10g Performance
69
?????? ??
World Record TPC-C
Unix
HP Integrity Superdome
70
?????? ??
World Record TPC-C
World Record on Windows
Unix
Windows
NEC Express 5800/1320Xd
HP Integrity Superdome
71
?????? ??
World Record TPC-C
World Record on Windows
and Linux
Unix
Windows
Linux
HP Integrity rx5670
NEC Express 5800/1320Xd
HP Integrity Superdome
72
?????? ?? ???? ??????
Top Clustered TPC-C
709,220
SQL Server 2000
DB2 EEE
Linux
Windows
HP Proliant DL760 32
HP Integrity rx5670 16
73
Oracle10g Summary
74
Oracle 10g (Enterprise Grid) ??
  • ??? ?? ??? ???? ??
  • ??? ??? ?? ? ??
  • ???? ?? ?? ??
  • ? ??? ????
  • ?? ?? ??
  • ?? ?? ??? ??

75
A
76
(No Transcript)
77
(No Transcript)
About PowerShow.com