Enterprise manager ? ??? ?????? (VIP) ???? ??????

1
Enterprise manager ? ??? ?????? (VIP)????
??????
2
? ?????????????? ?? ????? ???????

• ?????????? ?????????????? ? ????????????
• ?????????? ????????? ? ??
• ??????????? ? ??????????????
• ???????/??????
• ??????????
• ??????????? ??????????? ??????
• ??????????????????
• ?????/?????????
• ??????????
• Upgrades
• ? ? ?, ? ? ?, etc .

3

????????? ?? ?????
?????????? ??? ?????????????? ???? ??????? ?????
4
???????????
5
Oracle Enterprise Manager Console
6
DBA Management Pack

• Schema Manager
• Security Manager
• Instance Manager
• Storage Manager
• SQLPlus Worksheet
• Wizards - Backup and Recovery, SQLLoad, Import
  and Export

7
Oracle Enterprise Manager The Standard for
Oracle Management

• Oracle Parallel Server
• Oracle Application Server
• Oracle Video Server
• Oracle ConText
• Oracle Failsafe
• Oracle Express
• Oracle Advanced Replication
• plus more ...

8
Oracle Management Packs

• Oracle Diagnostics Pack
• Oracle Tuning Pack
• Oracle Change Management Pack

9
4 ???????? ???????? ???? ?????????????? ??
10
Day-to-Day Administration
11
Enterprise Manager Job Scheduling

• ????????????? ????????????? ?????
• ?????????? ?????????????? ??????????
• (BACKUP)

12
Enterprise Manager Event Handling

• ?????????? ? ?????? ?????? ?? ????, ??? ???
  ??????????? ? ???????? (Tablespace full)

13
??????????? ?????
??????? ?????????? ??? ???????? ????-????? ??
??????? ? ?? ??????????? ?????
14
Event Monitoring
15
Event Monitoring

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

16
?????? ??????????? (perfomance manager)
17
Oracle Performance Manager
?????? ??????????? ???????

• ????????? ??????? ? ?????????
• ???????? ? ?????????
• Customizable, user-defined ?????????
• Drill-down ??? ???????????
• User-defined ????????? ?????????? ??????

Oracle Performance Manager
18
Oracle TopSessionsFor Detailed Diagnostics
Oracle TopSessions
19
Oracle TopSessionsFor Detailed, Drill-down
Monitoring

• ??????????? ????????? ?????? ??? top ??????
• ?????????? ? ?????????? top ?????? ?? ??????
  ???????????? ????????
• CPU and memory usage
• File I/O, open cursors, user transactions
• Drill down for more session details
• ?????????? ????? ? ? ??????????????????
• ??????? SQL ??????????? ? Explain Plan
• ?????????? ???, ??? ???? ?????????
• ????? ????? ???????? ??????

20
Application Performance Management
Oracle TRACE
Application
Server
Network
Open API
Oracle TRACE
OracleTRACEManager

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

21
Oracle TRACE Data Uses

• Oracle TRACE ????????? ??????
• ????????????? ?????? ?? ??? ????????? ??????
• ??????????? ? ????????? TRACE ?????? ? Oracle ???
  SQL ???????
• ????? ????????????? TRACE ?????? ? Oracle
  ExpertTM ??? ?????????????? ?????????

??????
?????????? ????? ?????????
Oracle TRACE
??????????? ??????
??????? ??????
OracleServer
22
Diagnostics Pack

• ???? Real-Time ??????????
• ??????????? ????????? ? ???????? ?????????
• ??????????? ????? ???????

Applications
Events
Oracle Diagnostics Pack
Databases
Statistics
Oracle Enterprise Manager
Traces
Hosts
23
Performance Tuning
24
?????????? Tablespaces
??????????? ????????????? ?????????????
???????????? ? ?? ?????????? ?????????????,
?????????? ????????? ? ???- ?????? ?????????????
Oracle Tablespace Manager
??????, ??????,?????????, ????????,chaining etc
25

Database Tuning
????????? ???????????...

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

26
Oracle Expert ????????????? ????????
Operating Environment
Schema
Database
Workload
Expert Inference Engine
???????
????????????
??????
27
Oracle Expert ????????????
??????
??????
Environment Data (user entered)
Application Database
Instance and Schema Data Collection
binary file
SQLNet
TRACE database
Expert Repository
??????/???????
Expert Repository
Workload Data Collection
??????
28
??? ??????????????

• Workload ??????? ?????????? ? ???????? (SQL,
  ??????????, ??? ????????????)
• ????????? Instance (SGA, SORT, I/O, OPQ, V,
  Trace)
• Database Control Settings (DB size, OPS,
  DSS/OLTP/Batch, TP monitor/Forms, concurent
  logins)
• ???? ?????? (?????, ????./???????/view,
  ??????????????, ?????, ??? ?-?? ??, V, ??? ??
  control file)
• ???????????? ????? (SWHW)
• ???????

29
??????????????

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

30
Oracle ExpertServer Performance Tuning
31
????????? ????????
32
??????????? SQL
Optimized SQL
Untuned SQL
SQL Analysis

• ?????? ?????? ??????????
• ???????????? ??????????
• ?????????????? ???????- ??????? ?????????

• ??????????? (Wizard)
• Hints Wizard

33
Capacity Planning
34
??????? ???????
??????...
? ????????? ???????? ???????????? ??? ???????
??????...
????? ??? ??????????? ? ???????????? ? ?????????
?????
?????...
??? ??????????? ??????????? ?????? ???????????
35
Capacity Planning

• C??? ?????????? ? ?????? ??????????????????
• Collection
• ???????? CPU File I/O ?????? 10 ???
• ??????
• ?????????? ????????? ????????????? ????????
• ????????? ??????? ????????? ?????????????????? ?
  ????????????? ????????
• ??????????? ??????? ?????????? ????????
• ???????????? ??????? ???????????? ? ????????

36
Capacity Planning
37
Oracle Capacity Planning

• ????????
• ???? ??????
• ??????
• ?????? ? ??????????-
• ??? Wizards

38
?????? ???????????? ????????????? ????????
39
Change Management
D E M O N S T R A T I O N
40
Oracle Change Management Pack
?????????? ???????? ???????????
?????????? ??????? ?????????

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

???????????????? ???????
?????? ???????
????????? ?????????
41
???????????????? ???????
?????? ???????
DevelopmentDatabase
Oracle Change Management Pack
Oracle Enterprise Manager
Scripts
ProductionDatabase
42
?????? ???????

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

?????
DevelopmentDatabase
Oracle Change Management Pack
Oracle Enterprise Manager
Scripts
ProductionDatabase
43
????????? ?????????

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

DevelopmentDatabase
Oracle Change Management Pack
Oracle Enterprise Manager
ProductionDatabase
Backup
44
????? ?? ??????? ??????
Operational Duties
Capacity Planning
Change Management
Diagnostics
Performance Tuning
Day to Day Tasks
Backups, Monitoring User Management
Low
Medium
High
?????????
45
?????? ?????????? ? EM ? ???????

• Deluxe Checks
• ?????????????????? ??????? ???????? ?? 20
• John Deere
• ????? ?????????? ??????? ??????????? ? 45 ?????
  ?? ?????????? ??????
• Cargill
• ????????? ??????????? ??????? ????????? ?? 1/3