Corporate PPT Template - PowerPoint PPT Presentation

Loading...

PPT – Corporate PPT Template PowerPoint presentation | free to download - id: 6bd3ef-ODMwN



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:

Title: Corporate PPT Template Last modified by: mooyoung Created Date: 11/6/1996 7:19:12 PM Document presentation format: Company: Oracle Corporation – PowerPoint PPT presentation

Number of Views:58
Avg rating:3.0/5.0
Slides: 53
Provided by: downWowun5
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
ORACLE 10g GRID
2005.3 ? ? ? (Mooyoung.kim_at_oracle.com)
2
Agenda
  • 1. ? ?
  • 2. ??? GRID
  • 3. Oracle 10g GRID Computing
  • 4. Summary

3

1. ? ?
1.1 ??? IT????? ??
  • CIO ???? ??? ?? ???? 60? ??? ??.
  • Forrester Research
  • IT? ?? ????? 75??? ???? ? ????? ???? ??.
  • Business Week
  • IT? ????? ????? ????? ???? ???? ??.
  • IDC
  • ???? ??? ?? ????? ?? 20??? ??? ??? ? ??.
  • - Giga Research

4
1.2 IT??? ?? ??
  • ???? ??
  • ?? H/W, S/W ?? ? ????
  • Peak? ?? ?? ??(????)
  • ??? ??(Single Point)
  • ???? ?? ? ????
  • ??? ???

5
1.3 ???? GRID
  • ??? ??
  • ???? Components
  • ????? ?? ??
  • ??? ???
  • Flexible? ???
  • ???? ?? ???

6
1.4 ??? ???? ??
? ?? ?? ???? ??? ?? ?? ?? ??? ??? ???? ????
??? ??? ??? ??
7
1.5 ???10g ???
8
1.6 Oracle 10g ?? ??
  • Application Server Grid
  • Database Grid
  • Storage Grid
  • ??? ??? (Self Managing DB)
  • ???? ?? ??? ?????
  • ???? ??? ??
  • ??? ???? ?????? ??

9
1.7 Oracle 10g ??
  • ??? ??
  • ??? ?????
  • - ???, ???, ????, ???, ???
  • ??? ??? ??
  • - ??? ?? ????? ??? ??? ?? ? ? ??
  • ? ?? Self-Managing
  • - ???? ??/?? ? ???? ??? ??

10
1.8 ???? ??? ???? ?
??? ?? ??? Enterprise Grid Computing
11
11
2.1 ??? ???? ?? ??
2. ??? ???
  • ?? ? ??? ??? ???
  • - ?? ???? ???
  • - ?? ???? ????
  • ? ??
  • - ????
  • - ?????
  • - ?????
  • ??? ????? ?? ??? ???? ???.

12
2.2 ??? ???? ?? ????
  • ???? ????? ????
  • ??? ??
  • ???? ??? ?? ?????
  • ??? ??? ??? ??
  • ?? ??? ?? ???? ??? ???? ?? ??
  • ???? ? ?? ???? ???
  • ??? ? ??? ?? ??

ERP
CRM
DW
??? ?? ??
13
2.3 ??? ???? ?? ??? IT ??? ?
  • ?? ??? ?? ?? ?? ??
  • ???? ?? ??????
  • 14?? CPU ? ???? ???? OS
  • ???? ?? ??? ??
  • ??? ????? ????

Why Now.. Grid
??? IT??? ??? ???? ??? ??? ???? ?? !
14
Oracle10g GRID Computing
15
3. ???? ??? ???
3.1 ?? ??
16
3.2 ?? ?? - ?????
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
17
3.2.1 ??? ?????
  • ??? ????? ??????? ?? ????? ?? ??? ??? ??????
    ???? ????
  • ??? ???? ??? ???? ??? ??? ?? ??? ???? ??? ??? ???
    ??? ??
  • ??? ?????? ?? ??????
  • - Transportable Tablespaces
  • - Oracle Streams
  • - Data Pump
  • - Transparent Gateway
  • - Oracle External Tables

18
?) Transportable Tablespaces
??? ?????? ?? unplug ? plug?? ?
  • ?????? ???? Unload / Reload?? ??
    ???? ?? ??
  • Plug/unplug ??? ??????? ??? ????
  • ?? ?? ??????? ???? ????????
    ??? ? ? ??

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

?? ???? ?? ?? ?? ??
?????? ??? ???????? ????? ?? ??
??? ??
20
?) Oracle 10g Streams
  • FTP?? ?? ???????? ?? ? ??
  • ??? ???? ?? ??, ??, ?? ????
  • ???? ???? ????
  • ??? ????? ? ??? ?? self-propelled ?????? ?? ??

1
6
Update EMP set StateCA Where Empid100
Update EMP set StateCA Where Empid100
4
propagation
EMP
Queue LCRs
Queue LCRs
EMP
3
2
5
Apply
Capture
21
?) ???? ???? ?? (ASM)
  • ???? ???? ?? ??? ??
  • ?????? ??? ??? ?? ???? ????? ???? ?? ??? ??????
    ???
  • ?? ???? ?? ??
  • ????? ??? ??

Automatic Storage Management
22
1) ASM ?? ????? ? ???? ??
  • ???? ? ????? ?? ?? ???
  • ????? ?????? ????
  • ???? ?????? ??? ??
  • ????? ??? ??
  • ??? ??? ?? ? ??
  • ?? Rebalancing

23
2) ?? - Traditional vs. ASM
Traditional
10g ASM
Tables
Tables
Tablespace
Oracle10g ASM
Tablespace
Files
Files
File System
File System
Logical Vol
Logical Vol
Disks Group
Disk Group
?? ??? ???? ?? ?? ??? ??? ?? ???.
24
3) ASM? ??- ?????? ??
Add Disk
  • 1.OS? Disk ??
  • 2.Volume Manager? ?? ?? ??
  • 3.??? ??? ?? File System ??
  • 4.??? Disk? ??? ??? ??
  • 5.??? file? ??? ??
  • 6.Database file ?? ??
  • 7.I/O tuning ??

1. OS? Disk ?? 2. Add Disk ?? ??
ASM
25
3.3 ???? Pooling ? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
26
3.3.1 Pooling ? ???
?) POOLING(????) ??? ?????? ?? ??? ???? ??
?) ???(Virtualization) ????? ??? ?? ?? ????,
??????, ??????, ?? ?? ???? ?? ???
???? ????? ??? ??? ???? ??
27
3.4 ???? ????
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
28
3.4.1 ????(Policy-Based) ????
  • ?????? ? ?????? ?? ???? ??
  • ?? ??? ??? ??? ??? ????
  • ??? ??? ?? ?? ???
  • ?? ??? ?? ????? ???
  • ????? ??? ?? ??? ? ??

29
?) ???? ?? (Workload Management) ? 1
Test
Reporting
Order Entry
(PREPERRED ????)
RAC (Real Application Cluster)
Oracle 10g
30
?) ???? ?? (Workload Management) ? 2
Reporting
Order Entry(???)
?? ??
31
Reporting
Order Entry
Test
??? ????? ???
32
3.5 ???? ??? ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
33
3.5.1 ??? ???
  • ???? (Flash Back) ??
  • ??? ?? (Data Guard)
  • ?? ???????? ??? ????
  • ??? ????? ?????

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

35
??????
?) ??? ??(Data Guard)
  • Data Guard? ?? ??? ?? ?? ?? ??? ?? ?? ?? ????? ??
  • ??(??, ??, ??, ???)? ?? ?????? ????? ?? ??
  • ??? ???? ??????? ???? ??
  • Failover? Switchover ??
  • ??? ??? ?? ???

36
?) Mid-Tier ???? ??? ??
37
?) ??? ??? ?? ?????
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
38
3.6 ???? - ???
?????
Pooling ? ???
?? ??
??? ???
???
Storage
Databaseservers
Application servers
39
3.6.1 DBA? ????
Create Configure
Load Data
6
??
12
6
55
6
?????? ??
????? ??
DBA ???? ??
Source IOUG 2001 DBA Survey
40
3.6.2 ????(Self-Managing)
  • ??? ????
  • ?????? ? SQL ??
  • ???? ??
  • ???? ??
  • ?? ? ?? ??

?? ????
Reduce Capital Expenditure
?? ???? ??
41
?) ??? ???? - ?? ??(Shared) ??? ??
????? ??? ???
??
  • ????? ??? ?? ?? ?? ???
  • ??? ??? ??? ? ?? ??
  • ?? 2? Pool ??

Buffer Cache
SGA Pool
Large Pool
Large Pool
SQL Cache
SQL Cache
Java Pool
Java Pool
PGA Pool
SGA ??? ??? ??
DB_CACHE_SIZE SHARED_POOL_SIZE LARGE_POOL_SIZE JAV
A_POOL_SIZE
SGA_TARGET
42
?) ?????? ? SQL??
??!!! ?????!
ADDM
DBA
?? SQL
SQL Workload
SQL Tuning Advisor
Oracle 10g SQL ?? ??? ???
43
?? ?? ?????? ?? ?? ?? (ADDM)
D
utomatic
atabase
iagnostic
onitor
M
A
D
  • ?? ??? ?? ??? ??
  • ??? ??
  • ?? ?????? ?? ?? ??? ??
  • DB?? DBA
  • ?? ?? ??
  • ??? ?? ????

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

44
?? 10g EM? ??? SQL????
45
?) ???? ??
????, ???? ?? ????
  • ???? ???? ??? ???? ? ??
  • ???? ???,????? ???? ??
  • ???? ?? ??? ?? ?? ?? ??

46
???? ?? ??
47
?) ?? ?? ? ???? Flashback Database ??
  • ?? ???? ??? ?? ???
  • Flash Recovery Area? ??? ??? ??
  • ??? ?? Flashback Log? ??(captures)
  • ?? ?? ? ??? ?? ??
  • ?? ?? ??? ??? ??
  • Flashback Database to 205 PM

??? ??
??? ????
?? ????
Rewind button for the Database
??? ??
???? ??
48
?) ???? ???? ?? (ASM)
  • ???? ???? ?? ??? ??
  • ?????? ??? ??? ?? ???? ????? ???? ?? ??? ??????
    ???
  • ?? ???? ?? ??
  • ????? ??? ??

Automatic Storage Management
49
?) ????(Self-Managing) ?????? ??
Application and SQL Management
EM??
SystemResourceManagement
StorageManagement
AutomaticManagement
Monitor
Alert
Fix
Advise
Backup andRecoveryManagement
SpaceManagement
Common Infrastructure
50
3.6.3 Enterprise Manager ????
Host and Hardware
Database 10g
Administration Monitoring Provisioning Security
Network and Load Balancer
Oracle10g AS
Storage
Applications
Enterprise Manager
51
4. Oracle 10g Grid Summary
  • ??? ?? ??? ???? ??
  • ??? ??? ?? ? ??
  • ???? ?? ?? ??
  • ? ??? ????
  • ?? ?? ??
  • ?? ?? ??? ??

52
A
About PowerShow.com