Optimal One Pass Multi Pass
PGA_SIZE Executions Executions Executions
-------------------------------------------------------
8kb <= PGA < 16kb 60725456 0 0
16kb <= PGA < 32kb 128742 0 0
32kb <= PGA < 64kb 55579 0 0
64kb <= PGA < 128kb 36622 0 0
128kb <= PGA < 256kb 31909 0 0
256kb <= PGA < 512kb 756 0 0
512kb <= PGA < 1024kb 402 33 0
1mb <= PGA < 2mb 76 24454 0
2mb <= PGA < 4mb 4716 835 0
4mb <= PGA < 8mb 734 723 20
8mb <= PGA < 16mb 37 0 160
16mb <= PGA < 32mb 0 2 64
32mb <= PGA < 64mb 0 0 32 13 rows selected. What we can see here is that the larger the requested workarea size - the more
frequently we resorted to using the disk - in fact for sorts/hashes that
consumed more than 16mb of RAM, we resorted to disk each time. This would be an
indication that our PGA aggregate target was insufficient (the 24,454 one pass
executions for sorts beween 1 to 2m of RAM really indicates that). In this case
- the tables didn't lie, I had the PGA aggregate target set to 25meg initially
and by correcting the problem and setting it to 250m and later 432m - the disk
usaged dropped off considerably (well, all together). 这里为什么说1 to 2m of ram真正的表明了pga是不足的???
请求各位高人
PGA_SIZE Executions Executions Executions
-------------------------------------------------------
8kb <= PGA < 16kb 60725456 0 0
16kb <= PGA < 32kb 128742 0 0
32kb <= PGA < 64kb 55579 0 0
64kb <= PGA < 128kb 36622 0 0
128kb <= PGA < 256kb 31909 0 0
256kb <= PGA < 512kb 756 0 0
512kb <= PGA < 1024kb 402 33 0
1mb <= PGA < 2mb 76 24454 0
2mb <= PGA < 4mb 4716 835 0
4mb <= PGA < 8mb 734 723 20
8mb <= PGA < 16mb 37 0 160
16mb <= PGA < 32mb 0 2 64
32mb <= PGA < 64mb 0 0 32 13 rows selected. What we can see here is that the larger the requested workarea size - the more
frequently we resorted to using the disk - in fact for sorts/hashes that
consumed more than 16mb of RAM, we resorted to disk each time. This would be an
indication that our PGA aggregate target was insufficient (the 24,454 one pass
executions for sorts beween 1 to 2m of RAM really indicates that). In this case
- the tables didn't lie, I had the PGA aggregate target set to 25meg initially
and by correcting the problem and setting it to 250m and later 432m - the disk
usaged dropped off considerably (well, all together). 这里为什么说1 to 2m of ram真正的表明了pga是不足的???
请求各位高人
解决方案 »
- win7 64位可以装oracle10g吗,谁能教教我怎么弄,装了一天了!
- DBMS_METADATA.GET_DDL 问题
- 求 Oracle I-Learning 的开发资料
- 用OCI编程的问题???
- 请问怎么向我的这个表中插入一行记录????
- 高分求救!存储过程中如何truncate某个表。
- 数据导入问题
- 请教:oracle数据库我已成功建好,在sql plus中可以见表,录入数据,在别人机器上可以佩服务名,在sql中登陆(以system/manager登陆),但
- Oracle 连接 sqlserver
- SQL优化求解(有关联合主键)
- Oracle查询问题
- 请问这个要求一条select语句可以实现么
2mb <= PGA < 4mb 4716 835 0 很明显呀
1M-2M的时候ONE PASS为24454
而只要增大到2-4M ONE PASS就锐减到835次