X hits on this document

145 views

0 shares

0 downloads

0 comments

27 / 38

27

juliandyke.com

© 2007 Julian Dyke

Result Cache Event 43905 Level 1

SQL> ALTER SESSION SET EVENTS

'43905 trace name context forever, level 1';

Top level query block Objects for this node : 70428 70436 -------------------------------------

Query[len=191]: SELECT /*+ RESULT_CACHE */ d.driver_key,d.driver_name,SUM(c.driver_points) FROM driver d, car c WHERE d.driver_key = c.driver_key AND c.season_key = '2005' GROUP BY d.driver_key,d.driver_name

Normalized Query[len=304]: 172 1?"D" 226 1?"DRIVER_KEY" 219 1?"D" 226 1?"DRIVER_NAME" 219 1?"SUM" 225 1?"C" 226 1?"DRIVER_POINTS" 229 70 1?"DRIVER" 1?"D" 219 1?"CAR" 1?"C" 213 1?"D" 226 1?"DRIVER_KEY" 221 1?"C" 226 1?"DRIVER_KEY" 8 1?"C" 226 1?"SEASON_KEY" 221 3&'2005' 75 18 1?"D" 226 1?"DRIVER_KEY" 219 1?"D" 226 1?"DRIVER_NAME"  

Cache id1: cg920w9wu3z462qp8dxbbudprq Cache id2: cg920w9wu3z462qp8dxbbudprq

Column count: 3 NLS Dependent: YES  User Referenced: NO  Ordered: NO  Auto: NO Dependencies: (70428 - GP.CAR) (70436 - GP.DRIVER)

Document info
Document views145
Page views147
Page last viewedSat Jan 21 11:27:17 UTC 2017
Pages38
Paragraphs703
Words2667

Comments