Hi all,
I'm using Oracle 10.2.0.3, and I've performed the following
procedure to get sql statements and yours execution plans:
EXECUTE STATSPACK.SNAP(i_snap_level=>6);
But, when I generate the report, no execution plans are generated:
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
1.47 1 1.47 69.2 2.71 16,762 3711733731
Module: SQL*Plus
BEGIN STATSPACK.SNAP(i_snap_level=>6); END;
0.05 505 0.00 2.5 0.05 2,169 4143084494
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with grantee#=:1 and privilege
#>0
0.05 14 0.00 2.4 0.05 770 2232463585
UPDATE TABLE1 set COL1 = :"SYS_B_0" where COL2 <> :"SYS_B_1"
and COL3 < to_date(:"SYS_B_2
", :"SYS_B_3") and COL4 <> :"SYS_B_4" and COL5 <> :"SYS_B_5"
So, what's wrong? the snap level 6 includes information about execution plans.
Or not?
Thanx!!!!