Oracle???? - PowerPoint PPT Presentation

1 / 21
About This Presentation
Title:

Oracle????

Description:

Oracle SGA Java PGA DBWR – PowerPoint PPT presentation

Number of Views:123
Avg rating:3.0/5.0
Slides: 22
Provided by: whl3
Category:
Tags: oracle | tuning

less

Transcript and Presenter's Notes

Title: Oracle????


1
Oracle????
??
????
SGA
?????
?????
?????
????
?????
????
??
Java?
PGA
DBWR
SMON
PMON
CKPT
LGWR
Others
????
????
??????
????
??????
???
2
Oracle???
  • ?????????????????????
  • Oracle???Oracle?????

3
Oracle??
  • ??Oracle????????
  • ????????????????
  • ??????????

??
SGA
?????
????
?????
???????
????
???????
Large?
Java?
??????
DBWR
SMON
PMON
CKPT
LGWR
Others
4
???Oracle Server
?????
????
1.???????? 2.??????
????
????
?????
5
Oracle???
  • ???????
  • ??????

6
????
  • ????????????
  • ????
  • ????
  • ????????

Header
????
???? (?? ????)
???? ????
7
Oracle????
  • ???????????
  • ???, ?, ?,??????

???
????
?
?
?
?
8
Oracle????
  • SGA(System Global Area)
  • ??????????
  • PGA(Process Global Area)
  • ?server???????

9
?????(SGA)
  • SGA?????????
  • ???
  • ???????
  • ??????
  • ????(??????,????)
  • ?SGA???????????
  • ??
  • JAVA?

10
???
  • ?????????????SQL?????????????
  • ??????????????????
  • ???
  • ??????
  • ???SHARED_POOL_SIZE??
  • ALTER SYSTEM SET SHARED_POOL_SIZE 64M

?????

????


???????
11
?????(Library Cache)
  • ???????SQL?PL/SQL??
  • ??????????
  • ??LRU????
  • ????????
  • -??SQL??(Shared SQL)
  • -??PL/SQL??(Shared PL/SQL)
  • ??????????????

12
??????(Data Dictionary Cache)
  • ????????????????????????????????
  • ?????,?????????????????????????
  • ??????????????????????
  • ??????????????

13
??????
  • ?????????????????????????????
  • ??????????????????????
  • ??LRU????
  • DB_BLOCK_SIZE???????
  • ??????????DB_BLOCK_BUFFERS

14
???????
  • ???????
  • ????????????
  • ????????????????
  • ?LOG_BUFFER????

15
Large Pool
  • ?????SGA??
  • ???Shared Pool???
  • ????
  • -??????????(UGA)
  • -?????I/O
  • -??RMAN?????
  • -???????? PARALLEL_AUTOMATIC_TUNING TRUE
  • ????LRU????
  • LARGE_POOL_SIZE????
  • ALTER SYSTEM SET LARGE_POOL_SIZE 64M
  • ???????

16
Java Pool
  • Java?????????
  • ?????java??
  • JAVA_POOL_SIZE?????

17
PGA
  • ?????????????????????
  • ????????????
  • ?????????
  • ?????????
  • ??
  • ????
  • ???
  • ????
  • ????

PGA

?????
????
18
????
  • ??Oracle??????????????,??????????????????????????
  • Oracle?????????
  • ????(User process)????????????Oracle?????
  • ?????(Server process) ??Oracle?????????????????
  • ????(Background processes) ???Oracle?????

19
????(User process)
  • ??????Oracle??????
  • ??????????
  • ?????Oracle?????

?????
????
????
?????
20
?????(Server Process)
  • ???Oracle??????????
  • ?????????
  • ?????(dedicated)??????(shared server)

?????
????
????
????
?????
21
????(Background Processes)
  • ??????????????????
  • ???????
  • DBWn PMON CKPT
  • LGWR SMON
  • ???????
  • ARCn LMDn QMNn
  • CJQ0 LMON RECO
  • Dnnn LMS Snnn
  • LCKn Pnnn
Write a Comment
User Comments (0)
About PowerShow.com