API tools faq
paste
ExaGridDba

Block dump of IOT secondary indexes

ExaGridDba
May 17th, 2015
373
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 18.06 KB | None | 0 0
raw download clone embed print report
  1. Block DUMP OF IOT secondary indexes showing PRIMARY KEY COLUMN VALUES AND ROWID "guess"
  2.  
  3.  
  4. SQL*Plus: RELEASE 12.1.0.2.0 Production ON Sun May 17 23:41:10 2015
  5.  
  6. Copyright (c) 1982, 2014, Oracle.  ALL rights reserved.
  7.  
  8. Connected.
  9. SQL> COLUMN segment_name new_value segment_name format a30
  10. SQL> COLUMN index_name new_value index_name format a30
  11. SQL> COLUMN table_name new_value table_name format a30
  12. SQL>
  13. SQL> CREATE TABLESPACE users;
  14.  
  15. TABLESPACE created.
  16.  
  17. SQL> ALTER USER u DEFAULT TABLESPACE users;
  18.  
  19. USER altered.
  20.  
  21. SQL>
  22. SQL> CREATE TABLE tbliot
  23.   2  (
  24.   3  p VARCHAR2(10),
  25.   4  q VARCHAR2(10),
  26.   5  a VARCHAR2(10),
  27.   6  b VARCHAR2(10),
  28.   7  CONSTRAINT tbliot_pk PRIMARY KEY( p,q),
  29.   8  l clob
  30.   9  )
  31.  10  ORGANIZATION INDEX
  32.  11  including a
  33.  12  overflow
  34.  13  lob(l) store AS securefile
  35.  14  (enable storage IN ROW);
  36.  
  37. TABLE created.
  38.  
  39. SQL>
  40. SQL> CREATE INDEX secondarya ON tbliot ( a );
  41.  
  42. INDEX created.
  43.  
  44. SQL> CREATE INDEX secondaryb ON tbliot ( b );
  45.  
  46. INDEX created.
  47.  
  48. SQL>
  49. SQL> SELECT segment_name, segment_type, segment_subtype, tablespace_name FROM user_segments;
  50.  
  51. SEGMENT_NAME                   SEGMENT_TYPE       SEGMENT_SU TABLESPACE_NAME
  52. ------------------------------ ------------------ ---------- ------------------------------
  53. SYS_IOT_OVER_93301             TABLE              ASSM       USERS
  54. SYS_IL0000093301C00005$$       LOBINDEX           ASSM       USERS
  55. TBLIOT_PK                      INDEX              ASSM       USERS
  56. SECONDARYA                     INDEX              ASSM       USERS
  57. SECONDARYB                     INDEX              ASSM       USERS
  58. SYS_LOB0000093301C00005$$      LOBSEGMENT         SECUREFILE USERS
  59.  
  60. 6 ROWS selected.
  61.  
  62. SQL> INSERT INTO tbliot(p,q,a,b,l) VALUES ( 'IIII','QQQQ','AAAA','BBBB','LLLL');
  63.  
  64. 1 ROW created.
  65.  
  66. SQL> COMMIT;
  67.  
  68. COMMIT complete.
  69.  
  70. SQL> ALTER SYSTEM checkpoint;
  71.  
  72. SYSTEM altered.
  73.  
  74. SQL> SELECT segment_name, segment_type, segment_subtype, tablespace_name FROM user_segments;
  75.  
  76. SEGMENT_NAME                   SEGMENT_TYPE       SEGMENT_SU TABLESPACE_NAME
  77. ------------------------------ ------------------ ---------- ------------------------------
  78. SYS_IOT_OVER_93301             TABLE              ASSM       USERS
  79. SYS_IL0000093301C00005$$       LOBINDEX           ASSM       USERS
  80. TBLIOT_PK                      INDEX              ASSM       USERS
  81. SECONDARYA                     INDEX              ASSM       USERS
  82. SECONDARYB                     INDEX              ASSM       USERS
  83. SYS_LOB0000093301C00005$$      LOBSEGMENT         SECUREFILE USERS
  84.  
  85. 6 ROWS selected.
  86.  
  87. SQL>
  88. SQL> ALTER SESSION SET tracefile_identifier = iotpk;
  89.  
  90. SESSION altered.
  91.  
  92. SQL> @ dumpextent.SQL U TBLIOT_PK 0
  93. SQL> define owner=&&1
  94. SQL> define segment_name=&&2
  95. SQL> define exent_id=&&3
  96. SQL>
  97. SQL> COLUMN owner format a30
  98. SQL> COLUMN segment_name format a30
  99. SQL>
  100. SQL> COLUMN file_id new_value file_id
  101. SQL> COLUMN block_min new_value block_min
  102. SQL> COLUMN block_max new_value block_max
  103. SQL>
  104. SQL> SELECT owner, segment_name, extent_id, blocks, file_id, block_id,
  105.   2  block_id block_min, block_id + blocks - 1 block_max
  106.   3  FROM dba_extents
  107.   4  WHERE owner = '&&owner'
  108.   5  AND segment_name = '&&segment_name'
  109.   6  AND partition_name IS NULL
  110.   7  AND extent_id = &&exent_id;
  111. old   4: WHERE owner = '&&owner'
  112. NEW   4: WHERE owner = 'U'
  113. old   5: AND segment_name = '&&segment_name'
  114. NEW   5: AND segment_name = 'TBLIOT_PK'
  115. old   7: AND extent_id = &&exent_id
  116. NEW   7: AND extent_id = 0
  117.  
  118. OWNER                          SEGMENT_NAME                    EXTENT_ID     BLOCKS    FILE_ID   BLOCK_ID  BLOCK_MIN  BLOCK_MAX
  119. ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
  120. U                              TBLIOT_PK                               0          8         35        160        160        167
  121.  
  122. SQL>
  123. SQL> ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max;
  124. old   1: ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max
  125. NEW   1: ALTER SYSTEM DUMP datafile         35 block MIN        160 block MAX        167
  126.  
  127. SYSTEM altered.
  128.  
  129. SQL>
  130. SQL> @ tracefile.SQL
  131. SQL> COLUMN tracefile new_value tracefile format a120
  132. SQL>
  133. SQL> SELECT p.tracefile
  134.   2  FROM v$process p
  135.   3  join v$session s ON p.addr = s.paddr
  136.   4  WHERE s.sid = SYS_CONTEXT('userenv', 'sid' );
  137.  
  138. TRACEFILE
  139. ------------------------------------------------------------------------------------------------------------------------
  140. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_IOTPK.trc
  141.  
  142. SQL>
  143. SQL>
  144. SQL> SELECT table_name, segment_name, index_name FROM user_lobs
  145.   2  WHERE table_name = 'TBLIOT' AND column_name = 'L';
  146.  
  147. TABLE_NAME                     SEGMENT_NAME                   INDEX_NAME
  148. ------------------------------ ------------------------------ ------------------------------
  149. TBLIOT                         SYS_LOB0000093301C00005$$      SYS_IL0000093301C00005$$
  150.  
  151. SQL> ALTER SESSION SET tracefile_identifier = lobseg;
  152.  
  153. SESSION altered.
  154.  
  155. SQL> @ dumpextent.SQL U &&segment_name 0
  156. SQL> define owner=&&1
  157. SQL> define segment_name=&&2
  158. SQL> define exent_id=&&3
  159. SQL>
  160. SQL> COLUMN owner format a30
  161. SQL> COLUMN segment_name format a30
  162. SQL>
  163. SQL> COLUMN file_id new_value file_id
  164. SQL> COLUMN block_min new_value block_min
  165. SQL> COLUMN block_max new_value block_max
  166. SQL>
  167. SQL> SELECT owner, segment_name, extent_id, blocks, file_id, block_id,
  168.   2  block_id block_min, block_id + blocks - 1 block_max
  169.   3  FROM dba_extents
  170.   4  WHERE owner = '&&owner'
  171.   5  AND segment_name = '&&segment_name'
  172.   6  AND partition_name IS NULL
  173.   7  AND extent_id = &&exent_id;
  174. old   4: WHERE owner = '&&owner'
  175. NEW   4: WHERE owner = 'U'
  176. old   5: AND segment_name = '&&segment_name'
  177. NEW   5: AND segment_name = 'SYS_LOB0000093301C00005$$'
  178. old   7: AND extent_id = &&exent_id
  179. NEW   7: AND extent_id = 0
  180.  
  181. OWNER                          SEGMENT_NAME                    EXTENT_ID     BLOCKS    FILE_ID   BLOCK_ID  BLOCK_MIN  BLOCK_MAX
  182. ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
  183. U                              SYS_LOB0000093301C00005$$               0         16         35        136        136        151
  184.  
  185. SQL>
  186. SQL> ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max;
  187. old   1: ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max
  188. NEW   1: ALTER SYSTEM DUMP datafile         35 block MIN        136 block MAX        151
  189.  
  190. SYSTEM altered.
  191.  
  192. SQL>
  193. SQL> @ tracefile.SQL
  194. SQL> COLUMN tracefile new_value tracefile format a120
  195. SQL>
  196. SQL> SELECT p.tracefile
  197.   2  FROM v$process p
  198.   3  join v$session s ON p.addr = s.paddr
  199.   4  WHERE s.sid = SYS_CONTEXT('userenv', 'sid' );
  200.  
  201. TRACEFILE
  202. ------------------------------------------------------------------------------------------------------------------------
  203. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_LOBSEG.trc
  204.  
  205. SQL>
  206. SQL> ALTER SESSION SET tracefile_identifier = lobidx;
  207.  
  208. SESSION altered.
  209.  
  210. SQL> @ dumpextent.SQL U &&index_name 0
  211. SQL> define owner=&&1
  212. SQL> define segment_name=&&2
  213. SQL> define exent_id=&&3
  214. SQL>
  215. SQL> COLUMN owner format a30
  216. SQL> COLUMN segment_name format a30
  217. SQL>
  218. SQL> COLUMN file_id new_value file_id
  219. SQL> COLUMN block_min new_value block_min
  220. SQL> COLUMN block_max new_value block_max
  221. SQL>
  222. SQL> SELECT owner, segment_name, extent_id, blocks, file_id, block_id,
  223.   2  block_id block_min, block_id + blocks - 1 block_max
  224.   3  FROM dba_extents
  225.   4  WHERE owner = '&&owner'
  226.   5  AND segment_name = '&&segment_name'
  227.   6  AND partition_name IS NULL
  228.   7  AND extent_id = &&exent_id;
  229. old   4: WHERE owner = '&&owner'
  230. NEW   4: WHERE owner = 'U'
  231. old   5: AND segment_name = '&&segment_name'
  232. NEW   5: AND segment_name = 'SYS_IL0000093301C00005$$'
  233. old   7: AND extent_id = &&exent_id
  234. NEW   7: AND extent_id = 0
  235.  
  236. OWNER                          SEGMENT_NAME                    EXTENT_ID     BLOCKS    FILE_ID   BLOCK_ID  BLOCK_MIN  BLOCK_MAX
  237. ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
  238. U                              SYS_IL0000093301C00005$$                0          8         35        152        152        159
  239.  
  240. SQL>
  241. SQL> ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max;
  242. old   1: ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max
  243. NEW   1: ALTER SYSTEM DUMP datafile         35 block MIN        152 block MAX        159
  244.  
  245. SYSTEM altered.
  246.  
  247. SQL>
  248. SQL> @ tracefile.SQL
  249. SQL> COLUMN tracefile new_value tracefile format a120
  250. SQL>
  251. SQL> SELECT p.tracefile
  252.   2  FROM v$process p
  253.   3  join v$session s ON p.addr = s.paddr
  254.   4  WHERE s.sid = SYS_CONTEXT('userenv', 'sid' );
  255.  
  256. TRACEFILE
  257. ------------------------------------------------------------------------------------------------------------------------
  258. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_LOBIDX.trc
  259.  
  260. SQL>
  261. SQL>
  262. SQL> COLUMN iot_over new_value iot_over format a30
  263. SQL> SELECT table_name iot_over, iot_name FROM user_tables WHERE iot_name = 'TBLIOT';
  264.  
  265. IOT_OVER                       IOT_NAME
  266. ------------------------------ --------------------------------------------------------------------------------------------------------------------------------
  267. SYS_IOT_OVER_93301             TBLIOT
  268.  
  269. SQL> ALTER SESSION SET tracefile_identifier = iotoverflow;
  270.  
  271. SESSION altered.
  272.  
  273. SQL> @ dumpextent.SQL U &&iot_over 0
  274. SQL> define owner=&&1
  275. SQL> define segment_name=&&2
  276. SQL> define exent_id=&&3
  277. SQL>
  278. SQL> COLUMN owner format a30
  279. SQL> COLUMN segment_name format a30
  280. SQL>
  281. SQL> COLUMN file_id new_value file_id
  282. SQL> COLUMN block_min new_value block_min
  283. SQL> COLUMN block_max new_value block_max
  284. SQL>
  285. SQL> SELECT owner, segment_name, extent_id, blocks, file_id, block_id,
  286.   2  block_id block_min, block_id + blocks - 1 block_max
  287.   3  FROM dba_extents
  288.   4  WHERE owner = '&&owner'
  289.   5  AND segment_name = '&&segment_name'
  290.   6  AND partition_name IS NULL
  291.   7  AND extent_id = &&exent_id;
  292. old   4: WHERE owner = '&&owner'
  293. NEW   4: WHERE owner = 'U'
  294. old   5: AND segment_name = '&&segment_name'
  295. NEW   5: AND segment_name = 'SYS_IOT_OVER_93301'
  296. old   7: AND extent_id = &&exent_id
  297. NEW   7: AND extent_id = 0
  298.  
  299. OWNER                          SEGMENT_NAME                    EXTENT_ID     BLOCKS    FILE_ID   BLOCK_ID  BLOCK_MIN  BLOCK_MAX
  300. ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
  301. U                              SYS_IOT_OVER_93301                      0          8         35        128        128        135
  302.  
  303. SQL>
  304. SQL> ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max;
  305. old   1: ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max
  306. NEW   1: ALTER SYSTEM DUMP datafile         35 block MIN        128 block MAX        135
  307.  
  308. SYSTEM altered.
  309.  
  310. SQL>
  311. SQL> @ tracefile.SQL
  312. SQL> COLUMN tracefile new_value tracefile format a120
  313. SQL>
  314. SQL> SELECT p.tracefile
  315.   2  FROM v$process p
  316.   3  join v$session s ON p.addr = s.paddr
  317.   4  WHERE s.sid = SYS_CONTEXT('userenv', 'sid' );
  318.  
  319. TRACEFILE
  320. ------------------------------------------------------------------------------------------------------------------------
  321. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_IOTOVERFLOW.trc
  322.  
  323. SQL>
  324. SQL>
  325. SQL> ALTER SESSION SET tracefile_identifier = secondarya;
  326.  
  327. SESSION altered.
  328.  
  329. SQL> @ dumpextent.SQL U SECONDARYA 0
  330. SQL> define owner=&&1
  331. SQL> define segment_name=&&2
  332. SQL> define exent_id=&&3
  333. SQL>
  334. SQL> COLUMN owner format a30
  335. SQL> COLUMN segment_name format a30
  336. SQL>
  337. SQL> COLUMN file_id new_value file_id
  338. SQL> COLUMN block_min new_value block_min
  339. SQL> COLUMN block_max new_value block_max
  340. SQL>
  341. SQL> SELECT owner, segment_name, extent_id, blocks, file_id, block_id,
  342.   2  block_id block_min, block_id + blocks - 1 block_max
  343.   3  FROM dba_extents
  344.   4  WHERE owner = '&&owner'
  345.   5  AND segment_name = '&&segment_name'
  346.   6  AND partition_name IS NULL
  347.   7  AND extent_id = &&exent_id;
  348. old   4: WHERE owner = '&&owner'
  349. NEW   4: WHERE owner = 'U'
  350. old   5: AND segment_name = '&&segment_name'
  351. NEW   5: AND segment_name = 'SECONDARYA'
  352. old   7: AND extent_id = &&exent_id
  353. NEW   7: AND extent_id = 0
  354.  
  355. OWNER                          SEGMENT_NAME                    EXTENT_ID     BLOCKS    FILE_ID   BLOCK_ID  BLOCK_MIN  BLOCK_MAX
  356. ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
  357. U                              SECONDARYA                              0          8         35        168        168        175
  358.  
  359. SQL>
  360. SQL> ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max;
  361. old   1: ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max
  362. NEW   1: ALTER SYSTEM DUMP datafile         35 block MIN        168 block MAX        175
  363.  
  364. SYSTEM altered.
  365.  
  366. SQL>
  367. SQL> @ tracefile.SQL
  368. SQL> COLUMN tracefile new_value tracefile format a120
  369. SQL>
  370. SQL> SELECT p.tracefile
  371.   2  FROM v$process p
  372.   3  join v$session s ON p.addr = s.paddr
  373.   4  WHERE s.sid = SYS_CONTEXT('userenv', 'sid' );
  374.  
  375. TRACEFILE
  376. ------------------------------------------------------------------------------------------------------------------------
  377. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_SECONDARYA.trc
  378.  
  379. SQL>
  380. SQL>
  381. SQL> ALTER SESSION SET tracefile_identifier = secondaryb;
  382.  
  383. SESSION altered.
  384.  
  385. SQL> @ dumpextent.SQL U SECONDARYB 0
  386. SQL> define owner=&&1
  387. SQL> define segment_name=&&2
  388. SQL> define exent_id=&&3
  389. SQL>
  390. SQL> COLUMN owner format a30
  391. SQL> COLUMN segment_name format a30
  392. SQL>
  393. SQL> COLUMN file_id new_value file_id
  394. SQL> COLUMN block_min new_value block_min
  395. SQL> COLUMN block_max new_value block_max
  396. SQL>
  397. SQL> SELECT owner, segment_name, extent_id, blocks, file_id, block_id,
  398.   2  block_id block_min, block_id + blocks - 1 block_max
  399.   3  FROM dba_extents
  400.   4  WHERE owner = '&&owner'
  401.   5  AND segment_name = '&&segment_name'
  402.   6  AND partition_name IS NULL
  403.   7  AND extent_id = &&exent_id;
  404. old   4: WHERE owner = '&&owner'
  405. NEW   4: WHERE owner = 'U'
  406. old   5: AND segment_name = '&&segment_name'
  407. NEW   5: AND segment_name = 'SECONDARYB'
  408. old   7: AND extent_id = &&exent_id
  409. NEW   7: AND extent_id = 0
  410.  
  411. OWNER                          SEGMENT_NAME                    EXTENT_ID     BLOCKS    FILE_ID   BLOCK_ID  BLOCK_MIN  BLOCK_MAX
  412. ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ----------
  413. U                              SECONDARYB                              0          8         35        176        176        183
  414.  
  415. SQL>
  416. SQL> ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max;
  417. old   1: ALTER SYSTEM DUMP datafile &&file_id block MIN &&block_min block MAX &&block_max
  418. NEW   1: ALTER SYSTEM DUMP datafile         35 block MIN        176 block MAX        183
  419.  
  420. SYSTEM altered.
  421.  
  422. SQL>
  423. SQL> @ tracefile.SQL
  424. SQL> COLUMN tracefile new_value tracefile format a120
  425. SQL>
  426. SQL> SELECT p.tracefile
  427.   2  FROM v$process p
  428.   3  join v$session s ON p.addr = s.paddr
  429.   4  WHERE s.sid = SYS_CONTEXT('userenv', 'sid' );
  430.  
  431. TRACEFILE
  432. ------------------------------------------------------------------------------------------------------------------------
  433. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_SECONDARYB.trc
  434.  
  435. SQL>
  436. SQL>
  437. SQL> DROP TABLE tbliot purge;
  438.  
  439. TABLE dropped.
  440.  
  441. SQL>
  442. SQL> ALTER USER u DEFAULT TABLESPACE SYSTEM;
  443.  
  444. USER altered.
  445.  
  446. SQL> DROP TABLESPACE users including contents AND datafiles;
  447.  
  448. TABLESPACE dropped.
  449.  
  450. SQL>
  451. SQL> quit
  452.  
  453.  
  454. The INSERT VALUES statement was:
  455.  
  456. SQL> INSERT INTO tbliot(p,q,a,b,l) VALUES ( 'IIII','QQQQ','AAAA','BBBB','LLLL');
  457.  
  458. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_SECONDARYA.trc
  459.  
  460. ROW#0[8007] flag: K------, lock: 2, len=25
  461. col 0; len 4; (4):  41 41 41 41
  462. col 1; len 4; (4):  49 49 49 49
  463. col 2; len 4; (4):  51 51 51 51
  464. tl: 8 fb: --H-FL-- lb: 0x0  cc: 1
  465. col  0: [ 4]  08 c0 00 a3
  466. ----- end of leaf block Logical dump -----
  467.  
  468. Interpretation:
  469. Leaf VALUE IS 'AAAA' (41 41 41 41)
  470. PRIMARY KEY VALUES are 'IIII','QQQQ' (49 49 49 49 AND 51 51 51 51)
  471. ROWID "Guess" IS a pointer back TO blocks 0x08 c0 00 a3
  472.  
  473. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_SECONDARYB.trc
  474.  
  475. ROW#0[8007] flag: K------, lock: 2, len=25
  476. col 0; len 4; (4):  42 42 42 42
  477. col 1; len 4; (4):  49 49 49 49
  478. col 2; len 4; (4):  51 51 51 51
  479. tl: 8 fb: --H-FL-- lb: 0x0  cc: 1
  480. col  0: [ 4]  08 c0 00 a3
  481. ----- end of leaf block Logical dump -----
  482.  
  483. Interpretation:
  484. Leaf VALUE IS 'BBBB' (42 42 42 42)
  485. PRIMARY KEY VALUES are 'IIII','QQQQ' (49 49 49 49 AND 51 51 51 51)
  486. ROWID "Guess" IS a pointer back TO blocks 0x08 c0 00 a3
  487.  
  488. /u01/app/oracle/diag/rdbms/cdb12102/cdb12102/trace/cdb12102_ora_22863_IOTPK.trc
  489.  
  490. Block header DUMP:  0x08c000a3
  491.  Object id ON Block? Y
  492.  seg/obj: 0x16c79  csc: 0x00.10dba5a  itc: 2  flg: E  typ: 2 - INDEX
  493.      brn: 0  bdba: 0x8c000a0 ver: 0x01 opc: 0
  494.      inc: 0  exflg: 0
  495.  
  496.  Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
  497. 0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
  498. 0x02   0x000a.012.000018ef  0x0100183b.08ea.19  --U-    1  fsc 0x0000.010dba8a
  499. Leaf block DUMP
  500. ===============
  501. header address 140011531555428=0x7f56f99a5264
  502. kdxcolev 0
  503. KDXCOLEV Flags = - - -
  504. kdxcolok 0
  505. kdxcoopc 0x90: opcode=0: iot flags=I-- is converted=Y
  506. kdxconco 2
  507. kdxcosdc 0
  508. kdxconro 1
  509. kdxcofbo 38=0x26
  510. kdxcofeo 8006=0x1f46
  511. kdxcoavs 7968
  512. kdxlespl 0
  513. kdxlende 0
  514. kdxlenxt 0=0x0
  515. kdxleprv 0=0x0
  516. kdxledsz 0
  517. kdxlebksz 8032
  518. ROW#0[8006] flag: K------, lock: 2, len=26
  519. col 0; len 4; (4):  49 49 49 49
  520. col 1; len 4; (4):  51 51 51 51
  521. tl: 14 fb: --H-F--- lb: 0x0  cc: 1
  522. nrid:  0x08c00084.0
  523. col  0: [ 4]  41 41 41 41
  524. ----- end of leaf block Logical dump -----
  525.  
  526. Interpretation:
  527.  
  528. Block IS 0x08c000a3, WHERE the secondary INDEX pointers are pointing TO.
  529. PRIMARY KEY VALUES are 'IIII','QQQQ' (49 49 49 49 AND 51 51 51 51)
  530. Non-KEY VALUE IS 'AAAA' (41 41 41 41)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!