oracle直接路径读,Oracle直接路径读direct path read

NSMTIO trace

NSMTIO: qertbFetch:NoDirectRead:[- STT < OBJECT_SIZE < MTT]:Obect's size: 7 (blocks), Threshold: MTT(3025 blocks),

_object_statistics: enabled, Sage: enabled,

Direct Read for serial qry: enabled(:::::::auto DR::), Ascending SCN table scan: FALSE

flashback_table_scan: FALSE, Row Versions Query: FALSE

SqlId: 6avfua5g1gkh2, plan_hash_value: 4271162629, Object#: 10, Parition#: 0 DW_scan: disabled

NSMTIO: fple: FALSE, sage: TRUE, isTableSpaceOnSage: 0, invalid table sapce number: FALSE, prmsdec: TRUE, is kernel txn table space encrypted: -1,is enc_ktid encrypted: -1, is sage enabled based on data -layer checks: -1,

isQesSageEnabled: FALSE

NSMTIO: kcbism: islarge 1 next 0 nblks 1206 type 2, bpid 3, kcbisdbfc 0 kcbnhl 1024 kcbstt 605 keep_nb 0 kcbnbh 30256 kcbnwp 1

NSMTIO: kcbimd: nblks 1206 kcbstt 605 kcbnbh 3025 kcbisdbfc 3 is_medium 0

NSMTIO: kcbcmt1: scann age_diff adjts last_ts nbuf nblk has_val kcbisdbfc 0 15478 0 30256 1206 0 0

NSMTIO: kcbivlo: nblks 1206 vlot 500 pnb 30256 kcbisdbfc 0 is_large 0

NSMTIO: qertbFetch:[MTT < OBJECT_SIZE < VLOT]: Checking cost to read from caches(local/remote) and checking storage reduction factors (OLTP/EHCC Comp)

NSMTIO: kcbdpc:NoDirectRead:[CACHE_READ]: tsn: 0, objd: 18, objn: 18

ckpt: 0, nblks: 1206, ntcache: 1206, ntdist:0

Direct Path for pdb 3 tsn 0 objd 18 objn 18

Direct Path 0 ckpt 0, nblks 1206 ntcache 1206 ntdist 0

Direct Path mndb 12 tdiob 0 txiob 0 tciob 12051

Direct path diomrc 64 dios 2 kcbisdbfc 0

kcbdpc: kx 8 kc 8 lhs 4 rhs NSMTIO: Additional Info: VLOT=151280

Object# = 18, Object_Size = 1206 blocks