Concept

chapter 2 Data blocks,Extents,and Segments

 

以下sql语句需要临时段

create index

select...order by

select...distinct

select...group by

select...union

select...intersect

select...minus

建议为库创建临时表空间

 

pctused 数据块用于提供存储数据的空间百分比大小，当块超出此限定值时，这个块将从freelist列表中移除，不再提供插入数据的操作

pctfree 用于对数据块中数据进行update，delete操作的空间百分比

 

chapter 8：memory architecture

SGA

shared pool

streams pool

large pool

java pool

redo buffer

buffer cache

automatic shared memory management：SGA_TARGET

PGA

dedicated server:PGA_AGGREGATE_TARGET

 

Memory for the shared pool, large pool, java pool, and buffer cache is allocated in units of granules. The granule size is 4MB if the SGA size is less than 1GB. If the SGA size is greater than 1GB, the granule size changes to 16MB. The granule size is calculated and fixed when the instance starts up. The size does not change during the lifetime of the instance.Some platform dependencies arise. For example, on 32-bit Windows, the granule size is 8 M for SGAs larger than 1 GB