How does a SQL database always have physical reads when indexing? (3) bitsCN.com
Ame, scn, plhol, sqlbind, oshst, clientid, extid, lsqltext)
3 values
4 (: 1, sysdate,: 2,: 3,: 4,: 5,: 6,: 7,: 8,: 9,: 10,: 11,: 12,: 13)
01 call count cpu elapsed disk query current rows
02 -----------------------------------------------------------------------
03 Parse 1 0.00 0.00 0 0 0 0
04 Execute 1 2.09 2.94 1 2 2 1
05 Fetch 0 0.00 0.00 0 0 0 0
06 -----------------------------------------------------------------------
07 total 2 2.09 2.94 1 2 2 1
08
09 Misses in library cache during parse: 1
10 Optimizer mode: CHOOSE
11 Parsing user id: SYS (recursive depth: 1)
12
13 Elapsed times include waiting on following events:
14 Event waited on Times Max. Wait Total Waited
15 ---------------------------------------- Waited ----------------------
16 direct path read (lob) 1 0.00 0.00
The audit function is enabled.
BitsCN.com