Title: Enterprise manager ? ??? ?????? (VIP) ???? ??????
1Enterprise manager ? ??? ?????? (VIP)????
??????
2? ?????????????? ?? ????? ???????
- ?????????? ?????????????? ? ????????????
- ?????????? ????????? ? ??
- ??????????? ? ??????????????
- ???????/??????
- ??????????
- ??????????? ??????????? ??????
- ??????????????????
- ?????/?????????
- ??????????
- Upgrades
- ? ? ?, ? ? ?, etc .
3 ????????? ?? ?????
?????????? ??? ?????????????? ???? ??????? ?????
4???????????
5Oracle Enterprise Manager Console
6DBA Management Pack
- Schema Manager
- Security Manager
- Instance Manager
- Storage Manager
- SQLPlus Worksheet
- Wizards - Backup and Recovery, SQLLoad, Import
and Export
7Oracle 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 ...
8Oracle Management Packs
- Oracle Diagnostics Pack
- Oracle Tuning Pack
- Oracle Change Management Pack
94 ???????? ???????? ???? ?????????????? ??
10Day-to-Day Administration
11Enterprise Manager Job Scheduling
- ????????????? ????????????? ?????
- ?????????? ?????????????? ??????????
- (BACKUP)
12Enterprise Manager Event Handling
- ?????????? ? ?????? ?????? ?? ????, ??? ???
??????????? ? ???????? (Tablespace full)
13??????????? ?????
??????? ?????????? ??? ???????? ????-????? ??
??????? ? ?? ??????????? ?????
14Event Monitoring
15Event Monitoring
- ????? ? ??????
- ?????? ??????, ????????? ???????????
- ????? ???????? ?? ?? ?????????????
16?????? ??????????? (perfomance manager)
17Oracle Performance Manager
?????? ??????????? ???????
- ????????? ??????? ? ?????????
- ???????? ? ?????????
- Customizable, user-defined ?????????
- Drill-down ??? ???????????
- User-defined ????????? ?????????? ??????
Oracle Performance Manager
18Oracle TopSessionsFor Detailed Diagnostics
Oracle TopSessions
19Oracle 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
- ?????????? ???, ??? ???? ?????????
- ????? ????? ???????? ??????
20Application Performance Management
Oracle TRACE
Application
Server
Network
Open API
Oracle TRACE
OracleTRACEManager
- ???????????????? ??????????? ???????
21Oracle TRACE Data Uses
- Oracle TRACE ????????? ??????
- ????????????? ?????? ?? ??? ????????? ??????
- ??????????? ? ????????? TRACE ?????? ? Oracle ???
SQL ??????? - ????? ????????????? TRACE ?????? ? Oracle
ExpertTM ??? ?????????????? ?????????
??????
?????????? ????? ?????????
Oracle TRACE
??????????? ??????
??????? ??????
OracleServer
22Diagnostics Pack
- ???? Real-Time ??????????
- ??????????? ????????? ? ???????? ?????????
- ??????????? ????? ???????
Applications
Events
Oracle Diagnostics Pack
Databases
Statistics
Oracle Enterprise Manager
Traces
Hosts
23Performance Tuning
24?????????? Tablespaces
??????????? ????????????? ?????????????
???????????? ? ?? ?????????? ?????????????,
?????????? ????????? ? ???- ?????? ?????????????
Oracle Tablespace Manager
??????, ??????,?????????, ????????,chaining etc
25Database Tuning
????????? ???????????...
- ?????? ??? ???????????
- ??????? ?????????
- ??????? ? ???????????????? ??????
- ??????? ?????????????
- ??????? ????????? ??????????
- ???????? ?????????
- ?????????? ???????????????
26Oracle Expert ????????????? ????????
Operating Environment
Schema
Database
Workload
Expert Inference Engine
???????
????????????
??????
27Oracle 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
- ????????? ?????
- ?????? ???????
- ??????????? ????????
- ?????????
30Oracle ExpertServer Performance Tuning
31????????? ????????
32??????????? SQL
Optimized SQL
Untuned SQL
SQL Analysis
- ?????? ?????? ??????????
- ???????????? ??????????
- ?????????????? ???????- ??????? ?????????
- ??????????? (Wizard)
- Hints Wizard
33Capacity Planning
34??????? ???????
??????...
? ????????? ???????? ???????????? ??? ???????
??????...
????? ??? ??????????? ? ???????????? ? ?????????
?????
?????...
??? ??????????? ??????????? ?????? ???????????
35Capacity Planning
- C??? ?????????? ? ?????? ??????????????????
- Collection
- ???????? CPU File I/O ?????? 10 ???
- ??????
- ?????????? ????????? ????????????? ????????
- ????????? ??????? ????????? ?????????????????? ?
????????????? ???????? - ??????????? ??????? ?????????? ????????
- ???????????? ??????? ???????????? ? ????????
36Capacity Planning
37Oracle Capacity Planning
- ????????
- ???? ??????
- ??????
- ?????? ? ??????????-
- ??? Wizards
38?????? ???????????? ????????????? ????????
39Change Management
D E M O N S T R A T I O N
40Oracle 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