CPU_COST(CPU开销), IO_COST(I/O开销), TEMP_SPACE(临时空间开销), TIME(时间流逝)，COST为总开销

Oracle数据库资源限制分为：CPU_COST(CPU开销), IO_COST(I/O开销), TEMP_SPACE(临时空间开销), TIME(时间流逝)，COST为总开销，其中：CPU_COST=COST - IO_COST

(%CPU) = (COST - IO_COST)/COST


SELECT OPERATION, COST, (COST - IO_COST) CPU_COST, IO_COST, TEMP_SPACE, TIME
FROM PLAN_TABLE
WHERE ID = 0;

 

 

 

参考资料： 

 

http://shuixian.iteye.com/blog/234288

 

http://download.oracle.com/docs/cd/B10500_01/server.920/a96533/ex_plan.htm