Database Reference
In-Depth Information
PARSING IN CURSOR #714586924 len=439 dep=1 uid=0 oct=3 lid=0 tim=2736942627096 hv=1382509785
ad='1f7aa640' sqlid='fa2pv0p96fv6t'
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB)
opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */
NVL(SUM(C1),0), NVL(SUM(C2),0) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("T1")
FULL("T1") NO_PARALLEL_INDEX("T1") */ 1 AS C1, CASE WHEN "T1"."A"=50 AND "T1"."B"=50 THEN 1
ELSE 0 END AS C2 FROM "SYS"."T1" SAMPLE BLOCK (13.333333 , 1) SEED (1) "T1") SAMPLESUB
END OF STMT
PARSE
#714586924:c=0,e=4018,p=0,cr=2,cu=0,mis=1,r=0,dep=1,og=1,plh=2586623307,tim=2736942627092
EXEC #714586924:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=2586623307,tim=2736942627425
FETCH
#714586924:c=0,e=1155,p=0,cr=5,cu=0,mis=0,r=1,dep=1,og=1,plh=2586623307,tim=2736942628634
STAT #714586924 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=5 pr=0 pw=0 time=1161 us)'
STAT #714586924 id=2 cnt=1209 pid=1 pos=1 obj=88630 op='TABLE ACCESS SA MPLE T1 (cr=5 pr=0 pw=0
time=3609 us cost=3 size=19071 card=1467)'
CLOSE #714586924:c=0,e=16,dep=1,type=0,tim=2736942628915
=====================
PARSING IN CURSOR #276706860 len=47 dep=0 uid=0 oct=3 lid=0 tim=2736942631509 hv=711403563
ad='295440cc' sqlid='87z1sx8p6fa1b'
select count(*) from t1 where a = 50 and b = 50
END OF STMT
PARSE
#276706860:c=380547,e=516311,p=0,cr=1298,cu=0,mis=1,r=0,dep=0,og=1,plh=3724264953,tim=27369426
31504
EXEC #276706860:c=0,e=97,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3724264953,tim=2736942631884
FETCH
#276706860:c=0,e=1268,p=0,cr=32,cu=0,mis=0,r=1,dep=0,og=1,plh=3724264953,tim=2736942633279
STAT #276706860 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=32 pr=0 pw=0 time=1267
us)'
STAT #276706860 id=2 cnt=1000 pid=1 pos=1 obj=88630 op='TABLE ACCESS FULL T1 (cr=32 pr=0 pw=0
time=3168 us cost=10 size=48 card=6)'
FETCH #276706860:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=3724264953,tim=2736942634239
CLOSE #276706860:c=0,e=28,dep=0,type=0,tim=2736942636404
Oracle führt zunächst die generierte SQL-Anweisung (mit dem Kommentar OPT_DYN_
SAMP) aus und benutzt die ermittelten Statistiken bei Parsing des Cursors für „select
count(*) from t1 where a = 50 and b = 50“. Dabei entsteht der Ausführungsplan mit dem
Hashwert von 3724264953.
Anders sieht es aus, wenn wir die SQL-Anweisung „select count(*) from t1 where a = :b1
and b = :b2“ ausführen.
Search WWH ::




Custom Search