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