understanding gather_plan_statistics
hello gurus,
I would like understand ' gather_plan_statistics' . and understand why i have lot of disk's access number.
1 - i executed next
select * from table(dbms_xplan.display_cursor('9ftuj24byxz4v',null,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 9ftuj24byxz4v, child number 0
-------------------------------------
SELECT 'wt.workflow.work.WorkItem',A0.actionPerformed,A0.blob$context,A0
.completedBy,A0.context,A0.description,A0.eventSet,A0.classnamekeyD4,A0.
idA3D4,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.classnamekeyC4,A
0.idA3C4,A0.classnamekeyB4,A0.priority,A0.reassigned,A0.required,A0.role
,A0.classnamekeyA4,A0.idA3A4,A0.status,A0.taskURLPathInfo,TO_CHAR(A0.cre