oradebug dumplist
Global Area(在SGA中存放)=Fixed(SGA+GSGA,PGA+GPGA,UGA+GPGA)
IPC=Shared Global Area
SGA+PGA:
在SGA各个pool中的1granule=1extent,1extent=n chunks,在Freelist中单位是buckets
PGA可能类似
----------------------------------------------------------------------------------------------------
| |
| Memory Of Oracle Structure |
| |
---------------------------------------------------------------------------------------------------|
| GLOBAL_AREA=Fixed_SGA+Fixed_PGA+Fixed_UGA+ Indirct Memory ==>Locate is in :SGA | |
------------------------------------------------------------ --------------------------------------|
| |
| =========================================| |===================| |
| | SGA | | PGA | |
| |========================================|->Low Addr |===================| |
| | Fixed SGA(First Gradule)| | Fixed PGA | |
| |========================================|->High Addr |===================| |
| | | | | |
| | SGA | | PGA | |
| |- - - - - - - - - - - - - - - - - - | | | |
| | Buffer Cache | |-------------------| |
| |- - - - - - - - - - - - - - - - - - - - | Oracle Server Process | Dedicate Mode | |
| | | UGA | <-------------------------> |----------------- | |
| | | |-------- | | Oracle User Process | ||||| | |
| | Shared Pool | | | | <-------------------------> | ||||| | |
| | | |---------| | Listener(Local) | ||||| | |
| | | | UGA | | <-------------------------> | |---------| | |
| |- - - - - - - |Shared(MTS) | | | | | UGA | | |
| |Large Pool |<---------> | | | | | Pieces | | |
| |- - - - - - - | ----------- | | |---------- | |
| |. . . .. . ... . . . .. . .. | | 1Process<->1UGA | |
| | Other Structure | ===================== |
| | . . . ... .Fixed PGA,UGA . . . . . . | | | | |
| |- - - - - - - - - - - - - - - - - -| | | | |
| | Log buffer(Last Gradule)| | | | |
| =========================================| | | | |
| || | | | |
| Shared OS mem Segment Private Os mem segmet |
| |
----------------------------------------------------------------------------------------------------
--Fixed Memory structrue
Global Area
*.Fixed SGA:
The structure of the fixed SGA is externalised in X$KSMFSV;
SELECT
SUBSTR (ksmfsnam,1,20) AS "Name",
SUBSTR (ksmfstyp,1,20) AS "Type",
ksmfsadr AS "Address",
ksmfssiz AS "Size"
FROM x$ksmfsv
*.Fixed PGA
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15072844/viewspace-627473/
,如需转载,请注明出处,否则将追究法律责任。