- 博客(3)
- 资源 (6)
- 收藏
- 关注
RSS订阅转载 sorts(disk)及sorts(memory)的意义
The sorts (disk) Oracle metric indicates if the number of disk writes is non-zero for a given sort operation, if so, then this statistic is incremented sorts(memory) ：The sorts memory Oracle metri
2016-11-29 16:05:15
1545
转载 Explain Plan with Parallel Processing
First table creation Let's recreate our Gigabyte sized table and do a full table scan in parallel. CREATE TABLE T2 ( row_id INTEGER NOT NULL, row_pad VARCHAR2( 1000 ) ) NOLOGGING PCTFREE 90
2016-11-22 14:55:48
421
转载 hash join hint
Hash Joins Filed under: CBO,Execution plans,Hints,Oracle,Tuning — Jonathan Lewis @ 12:53 pm GMT Sep 7,2013 I’ve written notes about the different join mechanisms in the past – but such t
2016-11-09 13:43:30
1405
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人