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