Advertisement
Guest User

Peter Teoh

a guest
Jun 24th, 2008
601
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 135.24 KB | None | 0 0
  1. Dump file /u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_smon_6594.trc
  2. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
  3. With the Partitioning, OLAP and Data Mining options
  4. ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
  5. System name: Linux
  6. Node name: xentiger
  7. Release: 2.6.26-rc5
  8. Version: #15 SMP Tue Jun 17 11:21:26 SGT 2008
  9. Machine: i686
  10. Instance name: babydb
  11. Redo thread mounted by this instance: 1
  12. Oracle process number: 8
  13. Unix process pid: 6594, image: oracle@xentiger (SMON)
  14.  
  15. *** 2008-06-23 09:01:35.266
  16. *** SERVICE NAME:() 2008-06-23 09:01:35.265
  17. *** SESSION ID:(32.1) 2008-06-23 09:01:35.265
  18. Serial Transaction recovery caught exception 376
  19. *** 2008-06-23 09:01:35.266
  20. SMON: following errors trapped and ignored:
  21. ORA-00376: file 1 cannot be read at this time
  22. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  23. ktsmgtur(): TUR was not tuned for 313 secs
  24. *** 2008-06-23 09:01:36.298
  25. SMON: following errors trapped and ignored:
  26. ORA-00376: file 1 cannot be read at this time
  27. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  28. *** 2008-06-23 09:01:37.301
  29. SMON: following errors trapped and ignored:
  30. ORA-00376: file 1 cannot be read at this time
  31. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  32. *** 2008-06-23 09:01:38.304
  33. SMON: following errors trapped and ignored:
  34. ORA-00376: file 1 cannot be read at this time
  35. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  36. *** 2008-06-23 09:01:39.306
  37. SMON: following errors trapped and ignored:
  38. ORA-00376: file 1 cannot be read at this time
  39. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  40. ===================================================
  41. PROCESS STATE
  42. -------------
  43. Process global information:
  44. process: 0x2550ada8, call: 0x2554b13c, xact: (nil), curses: 0x2553e1dc, usrses: 0x2553e1dc
  45. ----------------------------------------
  46. SO: 0x2550ada8, type: 2, owner: (nil), flag: INIT/-/-/0x00
  47. (process) Oracle pid=8, calls cur/top: 0x2554b13c/0x2554b13c, flag: (16) SYSTEM
  48. int error: 0, call error: 0, sess error: 0, txn error 0
  49. (post info) last post received: 0 0 144
  50. last post received-location: ktmchg
  51. last process to post me: 2550c478 4 0
  52. last post sent: 581 0 4
  53. last post sent-location: kslpsr
  54. last process posted by me: 2550c478 4 0
  55. (latch info) wait_event=0 bits=0
  56. Process Group: DEFAULT, pseudo proc: 0x25513ce4
  57. O/S info: user: oracle, term: UNKNOWN, ospid: 6594
  58. OSD pid info: Unix process pid: 6594, image: oracle@xentiger (SMON)
  59. Dump of memory from 0x25505EB0 to 0x25506034
  60. 25505EB0 0000000E 252CD1E8 00000010 0003139D [......,%........]
  61. 25505EC0 2554B13C 00000003 0003139D 2560539C [<.T%.........S`%]
  62. 25505ED0 0000000B 0003139D 2553E1DC 00000004 [..........S%....]
  63. 25505EE0 00031291 25605438 0000000B 0003139D [....8T`%........]
  64. 25505EF0 256054D4 0000000B 0003139D 25605D6C [.T`%........l]`%]
  65. 25505F00 0000000B 0003139D 25708D40 00000007 [[email protected]%....]
  66. 25505F10 0003139D 25708DC4 00000007 0003139D [......p%........]
  67. 25505F20 25708E48 00000007 0003139D 25708ECC [H.p%..........p%]
  68. 25505F30 00000007 0003139D 25708F50 00000007 [........P.p%....]
  69. 25505F40 0003139D 25708FD4 00000007 0003139D [......p%........]
  70. 25505F50 234546CC 0000000B 0003139D 00000000 [.FE#............]
  71. 25505F60 00000000 00000000 00000000 00000000 [................]
  72. Repeat 12 times
  73. 25506030 00000000 [....]
  74. ----------------------------------------
  75. SO: 0x234546cc, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
  76. (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
  77. event: 1, last message event: 1,
  78. last message waited event: 1, messages read: 0
  79. channel: (0x25606520) Get Segment Information Channel
  80. scope: 0, event: 1, last mesage event: 0,
  81. publishers/subscribers: 0/1,
  82. messages published: 0
  83. (FOB) flags=2 fib=0x25713adc incno=0 pending i/o cnt=0
  84. fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_temp_45xrzk9w_.tmp
  85. fno=41 lblksz=4 fsiz=201667104
  86. (FOB) flags=2 fib=0x2571379c incno=0 pending i/o cnt=0
  87. fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_art_ts_45xwwb53_.dbf
  88. fno=5 lblksz=4 fsiz=201667104
  89. (FOB) flags=2 fib=0x2571345c incno=0 pending i/o cnt=0
  90. fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_users_45xrzkd7_.dbf
  91. fno=4 lblksz=4 fsiz=201667104
  92. (FOB) flags=2 fib=0x2571311c incno=0 pending i/o cnt=0
  93. fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_sysaux_45xrzfkp_.dbf
  94. fno=3 lblksz=4 fsiz=201667104
  95. (FOB) flags=2 fib=0x25712dcc incno=0 pending i/o cnt=0
  96. fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_undotbs1_45xrzdob_.dbf
  97. fno=2 lblksz=4 fsiz=201667104
  98. (FOB) flags=2 fib=0x25712a8c incno=0 pending i/o cnt=0
  99. fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf
  100. fno=1 lblksz=4 fsiz=201667104
  101. ----------------------------------------
  102. SO: 0x25605d6c, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
  103. (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
  104. event: 1, last message event: 3,
  105. last message waited event: 3, messages read: 1
  106. channel: (0x25606360) obj stat del channel
  107. scope: 4, event: 3, last mesage event: 3,
  108. publishers/subscribers: 0/1,
  109. messages published: 1
  110. ----------------------------------------
  111. SO: 0x256054d4, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
  112. (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
  113. event: 1, last message event: 1,
  114. last message waited event: 1, messages read: 0
  115. channel: (0x25608f20) KTF time scn map
  116. scope: 7, event: 1, last mesage event: 0,
  117. publishers/subscribers: 0/1,
  118. messages published: 0
  119. ----------------------------------------
  120. SO: 0x25605438, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
  121. (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
  122. event: 7, last message event: 12,
  123. last message waited event: 12, messages read: 1
  124. channel: (0x25608ac0) scumnt mount lock
  125. scope: 1, event: 15, last mesage event: 12,
  126. publishers/subscribers: 0/8,
  127. messages published: 1
  128. ----------------------------------------
  129. SO: 0x2553e1dc, type: 4, owner: 0x2550ada8, flag: INIT/-/-/0x00
  130. (session) sid: 32 trans: (nil), creator: 0x2550ada8, flag: (100051) USR/- BSY/-/-/-/-/-
  131. DID: 0001-0008-00000003, short-term DID: 0000-0000-00000000
  132. txn branch: (nil)
  133. oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS
  134. last wait for 'smon timer' blocking sess=0x(nil) seq=330 wait_time=976754 seconds since wait started=0
  135. sleep time=1, failed=4, =0
  136. Dumping Session Wait History
  137. for 'smon timer' count=1 wait_time=976754
  138. sleep time=1, failed=4, =0
  139. for 'smon timer' count=1 wait_time=977004
  140. sleep time=1, failed=3, =0
  141. for 'smon timer' count=1 wait_time=976907
  142. sleep time=1, failed=2, =0
  143. for 'smon timer' count=1 wait_time=976955
  144. sleep time=1, failed=1, =0
  145. for 'smon timer' count=1 wait_time=293013277
  146. sleep time=12c, failed=0, =0
  147. for 'smon timer' count=1 wait_time=5
  148. sleep time=12c, failed=0, =0
  149. for 'smon timer' count=1 wait_time=4451554
  150. sleep time=12c, failed=0, =0
  151. for 'smon timer' count=1 wait_time=9655
  152. sleep time=12c, failed=0, =0
  153. for 'smon timer' count=1 wait_time=18045
  154. sleep time=12c, failed=0, =0
  155. for 'smon timer' count=1 wait_time=138147
  156. sleep time=12c, failed=0, =0
  157. temporary object counter: 0
  158. ----------------------------------------
  159. UOL used : 0
  160. KGX Atomic Operation Log 0x23fee38c
  161. Mutex (nil)(0, 0) idn 0 oper NONE
  162. Cursor Parent uid 32 efd 10 whr 13 slp 0
  163. oper=NONE pt1=0x22eebcb0 pt2=0x22eebcec pt3=(nil)
  164. pt4=(nil) u41=0 stt=0
  165. KGX Atomic Operation Log 0x23fee3b4
  166. Mutex 0x2370a544(0, 0) idn 0 oper NONE
  167. Cursor Stat uid 32 efd 14 whr 1 slp 0
  168. oper=NONE pt1=0x2370a490 pt2=(nil) pt3=(nil)
  169. pt4=(nil) u41=0 stt=8
  170. KGX Atomic Operation Log 0x23fee3dc
  171. Mutex (nil)(0, 0) idn 0 oper NONE
  172. Cursor Stat uid 32 efd 0 whr 0 slp 0
  173. oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
  174. pt4=(nil) u41=0 stt=0
  175. ----------------------------------------
  176. SO: 0x23469d34, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  177. LIBRARY OBJECT LOCK: lock=23469d34 handle=237743dc mode=N
  178. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  179. htl=0x23469d80[0x23fea284,0x23fea284] htb=0x23fea284 ssga=0x23fea138
  180. user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
  181. LIBRARY OBJECT HANDLE: handle=237743dc mutex=0x23774490(0)
  182. name=SYS.USER$
  183. hash=6d8063e933741c7b437132a225321413 timestamp=06-23-2008 07:44:36
  184. namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
  185. kkkk-dddd-llll=0101-0101-0309 lock=N pin=0 latch#=3 hpc=0026 hlc=0026
  186. lwt=0x23774438[0x23774438,0x23774438] ltm=0x23774440[0x23774440,0x23774440]
  187. pwt=0x2377441c[0x2377441c,0x2377441c] ptm=0x23774424[0x23774424,0x23774424]
  188. ref=0x23774458[0x23774458,0x23774458] lnd=0x23774464[0x23771e08,0x237787c0]
  189. LIBRARY OBJECT: object=2377171c
  190. type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  191. DATA BLOCKS:
  192. data# heap pointer status pins change whr
  193. ----- -------- -------- --------- ---- ------ ---
  194. 0 23778100 237717d8 I/P/A/-/- 0 NONE 00
  195. 8 2377193c 237711a0 I/P/A/-/- 0 NONE 00
  196. 9 23771a18 0 I/-/-/-/- 0 NONE 0c
  197. ----------------------------------------
  198. SO: 0x23469e6c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  199. LIBRARY OBJECT LOCK: lock=23469e6c handle=237a82d8 mode=N
  200. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  201. htl=0x23469eb8[0x23fea6c4,0x23fea6c4] htb=0x23fea6c4 ssga=0x23fea138
  202. user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
  203. LIBRARY OBJECT HANDLE: handle=237a82d8 mutex=0x237a838c(0)
  204. name=SYS.C_USER#
  205. hash=dc7b39edaba41b1e78a8b32400c7659b timestamp=06-23-2008 07:44:36
  206. namespace=CLST flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
  207. kkkk-dddd-llll=0101-0101-0101 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
  208. lwt=0x237a8334[0x237a8334,0x237a8334] ltm=0x237a833c[0x237a833c,0x237a833c]
  209. pwt=0x237a8318[0x237a8318,0x237a8318] ptm=0x237a8320[0x237a8320,0x237a8320]
  210. ref=0x237a8354[0x237a8354,0x237a8354] lnd=0x237a8360[0x23789788,0x237c1210]
  211. LIBRARY OBJECT: object=237a7e60
  212. type=CLST flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  213. DATA BLOCKS:
  214. data# heap pointer status pins change whr
  215. ----- -------- -------- --------- ---- ------ ---
  216. 0 237a8268 237a7f1c I/P/A/-/- 0 NONE 00
  217. 8 237a8080 237a798c I/P/A/-/- 0 NONE 00
  218. ----------------------------------------
  219. SO: 0x23464ddc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  220. LIBRARY OBJECT LOCK: lock=23464ddc handle=23739f58 mode=N
  221. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  222. htl=0x23464e28[0x23fea234,0x23fea234] htb=0x23fea234 ssga=0x23fea138
  223. user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
  224. LIBRARY OBJECT HANDLE: handle=23739f58 mutex=0x2373a00c(0)
  225. name=SYS.TYPE$
  226. hash=848fe7317866b0836cf6e9e8b1243909 timestamp=06-23-2008 07:44:39
  227. namespace=TABL flags=KGHP/TIM/SML/[02000000]
  228. kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=3 hpc=0004 hlc=0004
  229. lwt=0x23739fb4[0x23739fb4,0x23739fb4] ltm=0x23739fbc[0x23739fbc,0x23739fbc]
  230. pwt=0x23739f98[0x23739f98,0x23739f98] ptm=0x23739fa0[0x23739fa0,0x23739fa0]
  231. ref=0x23739fd4[0x23739fd4,0x23739fd4] lnd=0x23739fe0[0x2375d928,0x22fbde40]
  232. LIBRARY OBJECT: object=23111e10
  233. type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  234. DATA BLOCKS:
  235. data# heap pointer status pins change whr
  236. ----- -------- -------- --------- ---- ------ ---
  237. 0 22f6417c 23111ea8 I/-/A/-/- 0 NONE 00
  238. 8 23112030 23232a70 I/-/A/-/- 0 NONE 00
  239. ----------------------------------------
  240. SO: 0x23469e04, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  241. LIBRARY OBJECT LOCK: lock=23469e04 handle=2368a16c mode=N
  242. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  243. htl=0x23469e50[0x23fea82c,0x23fea82c] htb=0x23fea82c ssga=0x23fea138
  244. user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
  245. LIBRARY OBJECT HANDLE: handle=2368a16c mutex=0x2368a220(0)
  246. name=SYS.C_TOID_VERSION#
  247. hash=691fc8421edb665863186250e09462c8 timestamp=06-23-2008 07:44:39
  248. namespace=CLST flags=KGHP/TIM/SML/[02000000]
  249. kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=2 hpc=0004 hlc=0004
  250. lwt=0x2368a1c8[0x2368a1c8,0x2368a1c8] ltm=0x2368a1d0[0x2368a1d0,0x2368a1d0]
  251. pwt=0x2368a1ac[0x2368a1ac,0x2368a1ac] ptm=0x2368a1b4[0x2368a1b4,0x2368a1b4]
  252. ref=0x2368a1e8[0x2368a1e8,0x2368a1e8] lnd=0x2368a1f4[0x2368a1f4,0x2368a1f4]
  253. LIBRARY OBJECT: object=237bc558
  254. type=CLST flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  255. DATA BLOCKS:
  256. data# heap pointer status pins change whr
  257. ----- -------- -------- --------- ---- ------ ---
  258. 0 23732af4 237bc614 I/-/A/-/- 0 NONE 00
  259. 8 237bc778 23133204 I/-/A/-/- 0 NONE 00
  260. ----------------------------------------
  261. SO: 0x2346545c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  262. LIBRARY OBJECT LOCK: lock=2346545c handle=2378aa84 mode=N
  263. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  264. htl=0x234654a8[0x23fea45c,0x23fea45c] htb=0x23fea45c ssga=0x23fea138
  265. user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
  266. LIBRARY OBJECT HANDLE: handle=2378aa84 mutex=0x2378ab38(0)
  267. name=SYS.OBJ$
  268. hash=6bd508fcca69602620c1816e61c9fe4e timestamp=06-23-2008 07:44:36
  269. namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
  270. kkkk-dddd-llll=0101-0501-0709 lock=N pin=0 latch#=3 hpc=0024 hlc=0024
  271. lwt=0x2378aae0[0x2378aae0,0x2378aae0] ltm=0x2378aae8[0x2378aae8,0x2378aae8]
  272. pwt=0x2378aac4[0x2378aac4,0x2378aac4] ptm=0x2378aacc[0x2378aacc,0x2378aacc]
  273. ref=0x2378ab00[0x2378ab00,0x2378ab00] lnd=0x2378ab0c[0x237787c0,0x23783eec]
  274. LIBRARY OBJECT: object=2377afc0
  275. type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  276. DATA BLOCKS:
  277. data# heap pointer status pins change whr
  278. ----- -------- -------- --------- ---- ------ ---
  279. 0 23784020 2377b07c I/P/A/-/- 0 NONE 00
  280. 8 2377b1e0 2377ac60 I/P/A/-/- 0 NONE 00
  281. 9 2377b344 0 I/-/-/-/- 0 NONE 0c
  282. 10 237d3f78 2372bb14 I/-/A/-/- 0 NONE 00
  283. ----------------------------------------
  284. SO: 0x2346482c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  285. LIBRARY OBJECT LOCK: lock=2346482c handle=23558d44 mode=N
  286. call pin=(nil) session pin=0x234660e4 hpc=0000 hlc=0000
  287. htl=0x23464878[0x23469b10,0x23fea3a4] htb=0x23fea3a4 ssga=0x23fea138
  288. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
  289. LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
  290. namespace=CRSR flags=RON/KGHP/PN0/[10010000]
  291. kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
  292. lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
  293. pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
  294. ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
  295. LIBRARY OBJECT: object=22ef63c0
  296. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  297. DEPENDENCIES: count=1 size=16
  298. READ ONLY DEPENDENCIES: count=1 size=16
  299. AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
  300. ACCESSES: count=1 size=16
  301. TRANSLATIONS: count=1 size=16
  302. DATA BLOCKS:
  303. data# heap pointer status pins change whr
  304. ----- -------- -------- --------- ---- ------ ---
  305. 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
  306. 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
  307. ----------------------------------------
  308. SO: 0x23469ac4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  309. LIBRARY OBJECT LOCK: lock=23469ac4 handle=230f80e0 mode=N
  310. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  311. htl=0x23469b10[0x23464c20,0x23464878] htb=0x23fea3a4 ssga=0x23fea138
  312. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2576
  313. LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
  314. name=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  315. hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
  316. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  317. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
  318. lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
  319. pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
  320. ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
  321. LIBRARY OBJECT: object=230f7c68
  322. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  323. CHILDREN: size=16
  324. child# table reference handle
  325. ------ -------- --------- --------
  326. 0 23111d9c 23111a50 230f7b6c
  327. 1 23111d9c 23111bcc 23558d44
  328. DATA BLOCKS:
  329. data# heap pointer status pins change whr
  330. ----- -------- -------- --------- ---- ------ ---
  331. 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
  332. ----------------------------------------
  333. SO: 0x23464bd4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  334. LIBRARY OBJECT LOCK: lock=23464bd4 handle=23558d44 mode=N
  335. call pin=(nil) session pin=0x23465e98 hpc=0000 hlc=0000
  336. htl=0x23464c20[0x234649b0,0x23469b10] htb=0x23fea3a4 ssga=0x23fea138
  337. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
  338. LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
  339. namespace=CRSR flags=RON/KGHP/PN0/[10010000]
  340. kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
  341. lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
  342. pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
  343. ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
  344. LIBRARY OBJECT: object=22ef63c0
  345. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  346. DEPENDENCIES: count=1 size=16
  347. READ ONLY DEPENDENCIES: count=1 size=16
  348. AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
  349. ACCESSES: count=1 size=16
  350. TRANSLATIONS: count=1 size=16
  351. DATA BLOCKS:
  352. data# heap pointer status pins change whr
  353. ----- -------- -------- --------- ---- ------ ---
  354. 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
  355. 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
  356. ----------------------------------------
  357. SO: 0x23464964, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  358. LIBRARY OBJECT LOCK: lock=23464964 handle=230f80e0 mode=N
  359. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  360. htl=0x234649b0[0x23469be0,0x23464c20] htb=0x23fea3a4 ssga=0x23fea138
  361. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2557
  362. LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
  363. name=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  364. hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
  365. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  366. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
  367. lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
  368. pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
  369. ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
  370. LIBRARY OBJECT: object=230f7c68
  371. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  372. CHILDREN: size=16
  373. child# table reference handle
  374. ------ -------- --------- --------
  375. 0 23111d9c 23111a50 230f7b6c
  376. 1 23111d9c 23111bcc 23558d44
  377. DATA BLOCKS:
  378. data# heap pointer status pins change whr
  379. ----- -------- -------- --------- ---- ------ ---
  380. 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
  381. ----------------------------------------
  382. SO: 0x23469b94, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  383. LIBRARY OBJECT LOCK: lock=23469b94 handle=23558d44 mode=N
  384. call pin=(nil) session pin=0x234665d0 hpc=0000 hlc=0000
  385. htl=0x23469be0[0x23464b50,0x234649b0] htb=0x23fea3a4 ssga=0x23fea138
  386. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
  387. LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
  388. namespace=CRSR flags=RON/KGHP/PN0/[10010000]
  389. kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
  390. lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
  391. pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
  392. ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
  393. LIBRARY OBJECT: object=22ef63c0
  394. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  395. DEPENDENCIES: count=1 size=16
  396. READ ONLY DEPENDENCIES: count=1 size=16
  397. AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
  398. ACCESSES: count=1 size=16
  399. TRANSLATIONS: count=1 size=16
  400. DATA BLOCKS:
  401. data# heap pointer status pins change whr
  402. ----- -------- -------- --------- ---- ------ ---
  403. 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
  404. 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
  405. ----------------------------------------
  406. SO: 0x23464b04, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  407. LIBRARY OBJECT LOCK: lock=23464b04 handle=230f80e0 mode=N
  408. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  409. htl=0x23464b50[0x23464ae8,0x23469be0] htb=0x23fea3a4 ssga=0x23fea138
  410. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2538
  411. LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
  412. name=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  413. hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
  414. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  415. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
  416. lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
  417. pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
  418. ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
  419. LIBRARY OBJECT: object=230f7c68
  420. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  421. CHILDREN: size=16
  422. child# table reference handle
  423. ------ -------- --------- --------
  424. 0 23111d9c 23111a50 230f7b6c
  425. 1 23111d9c 23111bcc 23558d44
  426. DATA BLOCKS:
  427. data# heap pointer status pins change whr
  428. ----- -------- -------- --------- ---- ------ ---
  429. 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
  430. ----------------------------------------
  431. SO: 0x23464a9c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  432. LIBRARY OBJECT LOCK: lock=23464a9c handle=23558d44 mode=N
  433. call pin=(nil) session pin=0x234662dc hpc=0000 hlc=0000
  434. htl=0x23464ae8[0x2346a260,0x23464b50] htb=0x23fea3a4 ssga=0x23fea138
  435. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
  436. LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
  437. namespace=CRSR flags=RON/KGHP/PN0/[10010000]
  438. kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
  439. lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
  440. pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
  441. ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
  442. LIBRARY OBJECT: object=22ef63c0
  443. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  444. DEPENDENCIES: count=1 size=16
  445. READ ONLY DEPENDENCIES: count=1 size=16
  446. AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
  447. ACCESSES: count=1 size=16
  448. TRANSLATIONS: count=1 size=16
  449. DATA BLOCKS:
  450. data# heap pointer status pins change whr
  451. ----- -------- -------- --------- ---- ------ ---
  452. 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
  453. 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
  454. ----------------------------------------
  455. SO: 0x2346a214, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  456. LIBRARY OBJECT LOCK: lock=2346a214 handle=230f80e0 mode=N
  457. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  458. htl=0x2346a260[0x23fea3a4,0x23464ae8] htb=0x23fea3a4 ssga=0x23fea138
  459. user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2518
  460. LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
  461. name=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  462. hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
  463. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  464. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
  465. lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
  466. pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
  467. ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
  468. LIBRARY OBJECT: object=230f7c68
  469. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  470. CHILDREN: size=16
  471. child# table reference handle
  472. ------ -------- --------- --------
  473. 0 23111d9c 23111a50 230f7b6c
  474. 1 23111d9c 23111bcc 23558d44
  475. DATA BLOCKS:
  476. data# heap pointer status pins change whr
  477. ----- -------- -------- --------- ---- ------ ---
  478. 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
  479. ----------------------------------------
  480. SO: 0x2346a34c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  481. LIBRARY OBJECT LOCK: lock=2346a34c handle=237c0ff0 mode=N
  482. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  483. htl=0x2346a398[0x23fea5ec,0x23fea5ec] htb=0x23fea5ec ssga=0x23fea138
  484. user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24e5
  485. LIBRARY OBJECT HANDLE: handle=237c0ff0 mutex=0x237c10a4(0)
  486. name=SYS.TAB$
  487. hash=a78f9a16ae7d958fa97507587dbfe080 timestamp=06-23-2008 07:44:36
  488. namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
  489. kkkk-dddd-llll=0101-0101-0309 lock=N pin=0 latch#=1 hpc=0018 hlc=0018
  490. lwt=0x237c104c[0x237c104c,0x237c104c] ltm=0x237c1054[0x237c1054,0x237c1054]
  491. pwt=0x237c1030[0x237c1030,0x237c1030] ptm=0x237c1038[0x237c1038,0x237c1038]
  492. ref=0x237c106c[0x237c106c,0x237c106c] lnd=0x237c1078[0x237c1368,0x237e1e1c]
  493. LIBRARY OBJECT: object=237c0bd8
  494. type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  495. DATA BLOCKS:
  496. data# heap pointer status pins change whr
  497. ----- -------- -------- --------- ---- ------ ---
  498. 0 237f3e84 237c0c94 I/P/A/-/- 0 NONE 00
  499. 8 237c0df8 237c065c I/P/A/-/- 0 NONE 00
  500. 9 237c0ed4 0 I/-/-/-/- 0 NONE 0c
  501. ----------------------------------------
  502. SO: 0x234652bc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  503. LIBRARY OBJECT LOCK: lock=234652bc handle=237e1d94 mode=N
  504. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  505. htl=0x23465308[0x23fea94c,0x23fea94c] htb=0x23fea94c ssga=0x23fea138
  506. user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24e5
  507. LIBRARY OBJECT HANDLE: handle=237e1d94 mutex=0x237e1e48(0)
  508. name=SYS.C_OBJ#
  509. hash=67af8b0042f9ddc88acd448fb1d132ec timestamp=06-23-2008 07:44:36
  510. namespace=CLST flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
  511. kkkk-dddd-llll=0101-0101-0101 lock=N pin=0 latch#=1 hpc=0030 hlc=0030
  512. lwt=0x237e1df0[0x237e1df0,0x237e1df0] ltm=0x237e1df8[0x237e1df8,0x237e1df8]
  513. pwt=0x237e1dd4[0x237e1dd4,0x237e1dd4] ptm=0x237e1ddc[0x237e1ddc,0x237e1ddc]
  514. ref=0x237e1e10[0x237e1e10,0x237e1e10] lnd=0x237e1e1c[0x237c1078,0x245c2268]
  515. LIBRARY OBJECT: object=237e5e58
  516. type=CLST flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  517. DATA BLOCKS:
  518. data# heap pointer status pins change whr
  519. ----- -------- -------- --------- ---- ------ ---
  520. 0 237f9b3c 237e5f14 I/P/A/-/- 0 NONE 00
  521. 8 237e6078 237e5984 I/P/A/-/- 0 NONE 00
  522. ----------------------------------------
  523. SO: 0x23469bfc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  524. LIBRARY OBJECT LOCK: lock=23469bfc handle=237d6dc0 mode=N
  525. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  526. htl=0x23469c48[0x23fea2a4,0x23fea2a4] htb=0x23fea2a4 ssga=0x23fea138
  527. user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24d7
  528. LIBRARY OBJECT HANDLE: handle=237d6dc0 mutex=0x237d6e74(0)
  529. name=SYS.IND_ONLINE$
  530. hash=968162a4702a7cb77e2756f5dc261517 timestamp=06-23-2008 07:44:54
  531. namespace=TABL flags=KGHP/TIM/SML/[02000000]
  532. kkkk-dddd-llll=0000-0000-0000 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
  533. lwt=0x237d6e1c[0x237d6e1c,0x237d6e1c] ltm=0x237d6e24[0x237d6e24,0x237d6e24]
  534. pwt=0x237d6e00[0x237d6e00,0x237d6e00] ptm=0x237d6e08[0x237d6e08,0x237d6e08]
  535. ref=0x237d6e3c[0x237d6e3c,0x237d6e3c] lnd=0x237d6e48[0x236dacec,0x23548e88]
  536. LIBRARY OBJECT last freed from HPD addn data CBK
  537. ----------------------------------------
  538. SO: 0x23469fa4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  539. LIBRARY OBJECT LOCK: lock=23469fa4 handle=2377b540 mode=N
  540. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  541. htl=0x23469ff0[0x23fea304,0x23fea304] htb=0x23fea304 ssga=0x23fea138
  542. user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24d7
  543. LIBRARY OBJECT HANDLE: handle=2377b540 mutex=0x2377b5f4(0)
  544. name=SYS.IND$
  545. hash=a1467e86983aba8ff919785be9444723 timestamp=06-23-2008 07:44:36
  546. namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
  547. kkkk-dddd-llll=0101-0101-0309 lock=N pin=0 latch#=2 hpc=001a hlc=001a
  548. lwt=0x2377b59c[0x2377b59c,0x2377b59c] ltm=0x2377b5a4[0x2377b5a4,0x2377b5a4]
  549. pwt=0x2377b580[0x2377b580,0x2377b580] ptm=0x2377b588[0x2377b588,0x2377b588]
  550. ref=0x2377b5bc[0x2377b5bc,0x2377b5bc] lnd=0x2377b5c8[0x2377839c,0x2378189c]
  551. LIBRARY OBJECT: object=23777cb0
  552. type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
  553. DATA BLOCKS:
  554. data# heap pointer status pins change whr
  555. ----- -------- -------- --------- ---- ------ ---
  556. 0 2377b4d0 23777d6c I/P/A/-/- 0 NONE 00
  557. 8 23777ed0 23777734 I/P/A/-/- 0 NONE 00
  558. 9 23777fac 0 I/-/-/-/- 0 NONE 0c
  559. ----------------------------------------
  560. SO: 0x23469924, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  561. LIBRARY OBJECT LOCK: lock=23469924 handle=235135a8 mode=N
  562. call pin=(nil) session pin=0x2346657c hpc=0000 hlc=0000
  563. htl=0x23469970[0x234653d8,0x23fea5f4] htb=0x23fea5f4 ssga=0x23fea138
  564. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  565. LIBRARY OBJECT HANDLE: handle=235135a8 mutex=0x2351365c(0)
  566. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  567. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0010 hlc=0010
  568. lwt=0x23513604[0x23513604,0x23513604] ltm=0x2351360c[0x23469940,0x23474fd0]
  569. pwt=0x235135e8[0x235135e8,0x235135e8] ptm=0x235135f0[0x235135f0,0x235135f0]
  570. ref=0x23513624[0x23587694,0x23587694] lnd=0x23513630[0x23513630,0x23513630]
  571. LIBRARY OBJECT: object=2377e0f0
  572. DATA BLOCKS:
  573. data# heap pointer status pins change whr
  574. ----- -------- -------- --------- ---- ------ ---
  575. 0 236258bc 2377e240 I/P/A/-/- 0 NONE 00
  576. 6 23593dd4 0 I/-/-/-/- 0 NONE 04
  577. ----------------------------------------
  578. SO: 0x2346538c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  579. LIBRARY OBJECT LOCK: lock=2346538c handle=2356ad58 mode=N
  580. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  581. htl=0x234653d8[0x234699d8,0x23469970] htb=0x23fea5f4 ssga=0x23fea138
  582. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x24ac
  583. LIBRARY OBJECT HANDLE: handle=2356ad58 mutex=0x2356ae0c(2)
  584. name=
  585. select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#
  586. hash=16030b5c728b234081e54a3c95c2a581 timestamp=06-23-2008 08:56:27
  587. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
  588. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0022 hlc=0022
  589. lwt=0x2356adb4[0x2356adb4,0x2356adb4] ltm=0x2356adbc[0x2356adbc,0x2356adbc]
  590. pwt=0x2356ad98[0x2356ad98,0x2356ad98] ptm=0x2356ada0[0x2356ada0,0x2356ada0]
  591. ref=0x2356add4[0x2356add4,0x2356add4] lnd=0x2356ade0[0x23586a48,0x2357d910]
  592. LIBRARY OBJECT: object=2356a8e0
  593. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  594. CHILDREN: size=16
  595. child# table reference handle
  596. ------ -------- --------- --------
  597. 0 23587870 23587524 2356a7d8
  598. 1 23587870 23587694 235135a8
  599. DATA BLOCKS:
  600. data# heap pointer status pins change whr
  601. ----- -------- -------- --------- ---- ------ ---
  602. 0 2356ace8 2356a978 I/P/A/-/- 0 NONE 00
  603. ----------------------------------------
  604. SO: 0x234655fc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  605. LIBRARY OBJECT LOCK: lock=234655fc handle=235595c8 mode=N
  606. call pin=(nil) session pin=0x23466234 hpc=0000 hlc=0000
  607. htl=0x23465648[0x2346a1f8,0x23fea79c] htb=0x23fea79c ssga=0x23fea138
  608. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  609. LIBRARY OBJECT HANDLE: handle=235595c8 mutex=0x2355967c(0)
  610. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  611. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0010 hlc=0010
  612. lwt=0x23559624[0x23559624,0x23559624] ltm=0x2355962c[0x23465618,0x23474f00]
  613. pwt=0x23559608[0x23559608,0x23559608] ptm=0x23559610[0x23559610,0x23559610]
  614. ref=0x23559644[0x2352da94,0x2352da94] lnd=0x23559650[0x23559650,0x23559650]
  615. LIBRARY OBJECT: object=2355f7a8
  616. DATA BLOCKS:
  617. data# heap pointer status pins change whr
  618. ----- -------- -------- --------- ---- ------ ---
  619. 0 236fdc90 2355f8f8 I/P/A/-/- 0 NONE 00
  620. 6 2355ef38 0 I/-/-/-/- 0 NONE 04
  621. ----------------------------------------
  622. SO: 0x2346a1ac, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  623. LIBRARY OBJECT LOCK: lock=2346a1ac handle=235244f4 mode=N
  624. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  625. htl=0x2346a1f8[0x23464d58,0x23465648] htb=0x23fea79c ssga=0x23fea138
  626. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x247e
  627. LIBRARY OBJECT HANDLE: handle=235244f4 mutex=0x235245a8(2)
  628. name=
  629. select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
  630. hash=1d4a51a2c89ab6b07a3c64bebc5573b6 timestamp=06-23-2008 08:56:27
  631. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]
  632. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0024 hlc=0024
  633. lwt=0x23524550[0x23524550,0x23524550] ltm=0x23524558[0x23524558,0x23524558]
  634. pwt=0x23524534[0x23524534,0x23524534] ptm=0x2352453c[0x2352453c,0x2352453c]
  635. ref=0x23524570[0x23524570,0x23524570] lnd=0x2352457c[0x235226d0,0x2359d488]
  636. LIBRARY OBJECT: object=2352dce0
  637. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  638. CHILDREN: size=16
  639. child# table reference handle
  640. ------ -------- --------- --------
  641. 0 2352dc6c 2352d920 2352d7b4
  642. 1 2352dc6c 2352da94 235595c8
  643. DATA BLOCKS:
  644. data# heap pointer status pins change whr
  645. ----- -------- -------- --------- ---- ------ ---
  646. 0 23531564 2352dd78 I/P/A/-/- 0 NONE 00
  647. ----------------------------------------
  648. SO: 0x23469f3c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  649. LIBRARY OBJECT LOCK: lock=23469f3c handle=23523564 mode=N
  650. call pin=(nil) session pin=0x23465d9c hpc=0000 hlc=0000
  651. htl=0x23469f88[0x2346a608,0x23fea5bc] htb=0x23fea5bc ssga=0x23fea138
  652. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  653. LIBRARY OBJECT HANDLE: handle=23523564 mutex=0x23523618(0)
  654. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  655. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0010 hlc=0010
  656. lwt=0x235235c0[0x235235c0,0x235235c0] ltm=0x235235c8[0x23469f58,0x23474e30]
  657. pwt=0x235235a4[0x235235a4,0x235235a4] ptm=0x235235ac[0x235235ac,0x235235ac]
  658. ref=0x235235e0[0x2354d850,0x2354d850] lnd=0x235235ec[0x235235ec,0x235235ec]
  659. LIBRARY OBJECT: object=2359a940
  660. DATA BLOCKS:
  661. data# heap pointer status pins change whr
  662. ----- -------- -------- --------- ---- ------ ---
  663. 0 23744e00 2359aa90 I/P/A/-/- 0 NONE 00
  664. 6 2359a0d0 0 I/-/-/-/- 0 NONE 04
  665. ----------------------------------------
  666. SO: 0x2346a5bc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  667. LIBRARY OBJECT LOCK: lock=2346a5bc handle=2354deb8 mode=N
  668. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  669. htl=0x2346a608[0x23469b78,0x23469f88] htb=0x23fea5bc ssga=0x23fea138
  670. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2451
  671. LIBRARY OBJECT HANDLE: handle=2354deb8 mutex=0x2354df6c(2)
  672. name=
  673. select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
  674. hash=436a415b2251827617e919499a05b67a timestamp=06-23-2008 08:56:27
  675. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
  676. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0024 hlc=0024
  677. lwt=0x2354df14[0x2354df14,0x2354df14] ltm=0x2354df1c[0x2354df1c,0x2354df1c]
  678. pwt=0x2354def8[0x2354def8,0x2354def8] ptm=0x2354df00[0x2354df00,0x2354df00]
  679. ref=0x2354df34[0x2354df34,0x2354df34] lnd=0x2354df40[0x2353a760,0x2358adcc]
  680. LIBRARY OBJECT: object=2354daa0
  681. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  682. CHILDREN: size=16
  683. child# table reference handle
  684. ------ -------- --------- --------
  685. 0 2354da2c 2354d6e0 23531690
  686. 1 2354da2c 2354d850 23523564
  687. DATA BLOCKS:
  688. data# heap pointer status pins change whr
  689. ----- -------- -------- --------- ---- ------ ---
  690. 0 23543b78 2354db38 I/P/A/-/- 0 NONE 00
  691. ----------------------------------------
  692. SO: 0x23464f7c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  693. LIBRARY OBJECT LOCK: lock=23464f7c handle=2359ea9c mode=N
  694. call pin=(nil) session pin=0x23465d48 hpc=0000 hlc=0000
  695. htl=0x23464fc8[0x2346a128,0x23fea66c] htb=0x23fea66c ssga=0x23fea138
  696. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  697. LIBRARY OBJECT HANDLE: handle=2359ea9c mutex=0x2359eb50(0)
  698. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  699. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=000e hlc=000e
  700. lwt=0x2359eaf8[0x2359eaf8,0x2359eaf8] ltm=0x2359eb00[0x23464f98,0x234752a8]
  701. pwt=0x2359eadc[0x2359eadc,0x2359eadc] ptm=0x2359eae4[0x2359eae4,0x2359eae4]
  702. ref=0x2359eb18[0x235aa134,0x235aa134] lnd=0x2359eb24[0x2359eb24,0x2359eb24]
  703. LIBRARY OBJECT: object=235a7b20
  704. DATA BLOCKS:
  705. data# heap pointer status pins change whr
  706. ----- -------- -------- --------- ---- ------ ---
  707. 0 237742ac 235a7c70 I/P/A/-/- 0 NONE 00
  708. 6 235ae764 0 I/-/-/-/- 0 NONE 04
  709. ----------------------------------------
  710. SO: 0x2346a0dc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  711. LIBRARY OBJECT LOCK: lock=2346a0dc handle=2358ad44 mode=N
  712. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  713. htl=0x2346a128[0x234655e0,0x23464fc8] htb=0x23fea66c ssga=0x23fea138
  714. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x243b
  715. LIBRARY OBJECT HANDLE: handle=2358ad44 mutex=0x2358adf8(2)
  716. name=select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
  717. hash=b26a259f381e87d302773791f5e84a90 timestamp=06-23-2008 08:56:27
  718. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  719. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
  720. lwt=0x2358ada0[0x2358ada0,0x2358ada0] ltm=0x2358ada8[0x2358ada8,0x2358ada8]
  721. pwt=0x2358ad84[0x2358ad84,0x2358ad84] ptm=0x2358ad8c[0x2358ad8c,0x2358ad8c]
  722. ref=0x2358adc0[0x2358adc0,0x2358adc0] lnd=0x2358adcc[0x2354df40,0x23725b5c]
  723. LIBRARY OBJECT: object=2358a92c
  724. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  725. CHILDREN: size=16
  726. child# table reference handle
  727. ------ -------- --------- --------
  728. 0 235aa2f4 235a9fa8 235a9e3c
  729. 1 235aa2f4 235aa134 2359ea9c
  730. DATA BLOCKS:
  731. data# heap pointer status pins change whr
  732. ----- -------- -------- --------- ---- ------ ---
  733. 0 23590794 2358a9c4 I/P/A/-/- 0 NONE 00
  734. ----------------------------------------
  735. SO: 0x23465254, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  736. LIBRARY OBJECT LOCK: lock=23465254 handle=23548e00 mode=N
  737. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  738. htl=0x234652a0[0x23fea44c,0x23fea44c] htb=0x23fea44c ssga=0x23fea138
  739. user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x23de
  740. LIBRARY OBJECT HANDLE: handle=23548e00 mutex=0x23548eb4(0)
  741. name=SYS.SMON_SCN_TIME
  742. hash=9025a1f4376d6af6d9b3dfcfb050d64c timestamp=06-23-2008 07:44:52
  743. namespace=TABL flags=KGHP/TIM/SML/[02000000]
  744. kkkk-dddd-llll=0000-0000-0000 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
  745. lwt=0x23548e5c[0x23548e5c,0x23548e5c] ltm=0x23548e64[0x23548e64,0x23548e64]
  746. pwt=0x23548e40[0x23548e40,0x23548e40] ptm=0x23548e48[0x23548e48,0x23548e48]
  747. ref=0x23548e7c[0x23548e7c,0x23548e7c] lnd=0x23548e88[0x237d6e48,0x235b02e8]
  748. LIBRARY OBJECT last freed from HPD addn data CBK
  749. ----------------------------------------
  750. SO: 0x23464eac, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  751. LIBRARY OBJECT LOCK: lock=23464eac handle=23517b58 mode=N
  752. call pin=(nil) session pin=0x23465fe8 hpc=0000 hlc=0000
  753. htl=0x23464ef8[0x2346a5a0,0x23fea62c] htb=0x23fea62c ssga=0x23fea138
  754. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  755. LIBRARY OBJECT HANDLE: handle=23517b58 mutex=0x23517c0c(0)
  756. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  757. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0012 hlc=0012
  758. lwt=0x23517bb4[0x23517bb4,0x23517bb4] ltm=0x23517bbc[0x23464ec8,0x23464ec8]
  759. pwt=0x23517b98[0x23517b98,0x23517b98] ptm=0x23517ba0[0x23517ba0,0x23517ba0]
  760. ref=0x23517bd4[0x23503c00,0x23503c00] lnd=0x23517be0[0x23517be0,0x23517be0]
  761. LIBRARY OBJECT: object=23520cac
  762. DATA BLOCKS:
  763. data# heap pointer status pins change whr
  764. ----- -------- -------- --------- ---- ------ ---
  765. 0 236cc484 23520dfc I/P/A/-/- 0 NONE 00
  766. 6 23509f9c 0 I/-/-/-/- 0 NONE 04
  767. ----------------------------------------
  768. SO: 0x2346a554, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  769. LIBRARY OBJECT LOCK: lock=2346a554 handle=235042c8 mode=N
  770. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  771. htl=0x2346a5a0[0x23fea62c,0x23464ef8] htb=0x23fea62c ssga=0x23fea138
  772. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x241f
  773. LIBRARY OBJECT HANDLE: handle=235042c8 mutex=0x2350437c(2)
  774. name=select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
  775. hash=26947ac91d45c1242b247fc5f6b6f088 timestamp=06-23-2008 08:56:27
  776. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  777. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0026 hlc=0026
  778. lwt=0x23504324[0x23504324,0x23504324] ltm=0x2350432c[0x2350432c,0x2350432c]
  779. pwt=0x23504308[0x23504308,0x23504308] ptm=0x23504310[0x23504310,0x23504310]
  780. ref=0x23504344[0x23504344,0x23504344] lnd=0x23504350[0x23546dc8,0x2355590c]
  781. LIBRARY OBJECT: object=23503e50
  782. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  783. CHILDREN: size=16
  784. child# table reference handle
  785. ------ -------- --------- --------
  786. 0 23503ddc 23503a90 23503924
  787. 1 23503ddc 23503c00 23517b58
  788. DATA BLOCKS:
  789. data# heap pointer status pins change whr
  790. ----- -------- -------- --------- ---- ------ ---
  791. 0 23504258 23503ee8 I/P/A/-/- 0 NONE 00
  792. ----------------------------------------
  793. SO: 0x2346a144, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  794. LIBRARY OBJECT LOCK: lock=2346a144 handle=234fd368 mode=N
  795. call pin=(nil) session pin=0x23466330 hpc=0000 hlc=0000
  796. htl=0x2346a190[0x23464dc0,0x23fea624] htb=0x23fea624 ssga=0x23fea138
  797. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  798. LIBRARY OBJECT HANDLE: handle=234fd368 mutex=0x234fd41c(0)
  799. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  800. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0012 hlc=0012
  801. lwt=0x234fd3c4[0x234fd3c4,0x234fd3c4] ltm=0x234fd3cc[0x2346a160,0x2346a160]
  802. pwt=0x234fd3a8[0x234fd3a8,0x234fd3a8] ptm=0x234fd3b0[0x234fd3b0,0x234fd3b0]
  803. ref=0x234fd3e4[0x235064fc,0x235064fc] lnd=0x234fd3f0[0x234fd3f0,0x234fd3f0]
  804. LIBRARY OBJECT: object=23549e08
  805. DATA BLOCKS:
  806. data# heap pointer status pins change whr
  807. ----- -------- -------- --------- ---- ------ ---
  808. 0 236ed48c 23549f58 I/P/A/-/- 0 NONE 00
  809. 6 235220cc 0 I/-/-/-/- 0 NONE 04
  810. ----------------------------------------
  811. SO: 0x23464d74, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  812. LIBRARY OBJECT LOCK: lock=23464d74 handle=234fe3b4 mode=N
  813. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  814. htl=0x23464dc0[0x23fea624,0x2346a190] htb=0x23fea624 ssga=0x23fea138
  815. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2412
  816. LIBRARY OBJECT HANDLE: handle=234fe3b4 mutex=0x234fe468(2)
  817. name=select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
  818. hash=d751142c3b7971bd655864a445f58a87 timestamp=06-23-2008 08:56:27
  819. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  820. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0026 hlc=0026
  821. lwt=0x234fe410[0x234fe410,0x234fe410] ltm=0x234fe418[0x234fe418,0x234fe418]
  822. pwt=0x234fe3f4[0x234fe3f4,0x234fe3f4] ptm=0x234fe3fc[0x234fe3fc,0x234fe3fc]
  823. ref=0x234fe430[0x234fe430,0x234fe430] lnd=0x234fe43c[0x2355590c,0x235226d0]
  824. LIBRARY OBJECT: object=2350674c
  825. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  826. CHILDREN: size=16
  827. child# table reference handle
  828. ------ -------- --------- --------
  829. 0 235066d8 2350638c 23512484
  830. 1 235066d8 235064fc 234fd368
  831. DATA BLOCKS:
  832. data# heap pointer status pins change whr
  833. ----- -------- -------- --------- ---- ------ ---
  834. 0 234fe33c 235067e4 I/P/A/-/- 0 NONE 00
  835. ----------------------------------------
  836. SO: 0x2346a41c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  837. LIBRARY OBJECT LOCK: lock=2346a41c handle=23599fe4 mode=N
  838. call pin=(nil) session pin=0x234661e0 hpc=0000 hlc=0000
  839. htl=0x2346a468[0x23469d18,0x23fea74c] htb=0x23fea74c ssga=0x23fea138
  840. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  841. LIBRARY OBJECT HANDLE: handle=23599fe4 mutex=0x2359a098(0)
  842. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  843. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0014 hlc=0014
  844. lwt=0x2359a040[0x2359a040,0x2359a040] ltm=0x2359a048[0x2346a438,0x2346a438]
  845. pwt=0x2359a024[0x2359a024,0x2359a024] ptm=0x2359a02c[0x2359a02c,0x2359a02c]
  846. ref=0x2359a060[0x23557a80,0x23557a80] lnd=0x2359a06c[0x2359a06c,0x2359a06c]
  847. LIBRARY OBJECT: object=237e3230
  848. DATA BLOCKS:
  849. data# heap pointer status pins change whr
  850. ----- -------- -------- --------- ---- ------ ---
  851. 0 2366809c 237e3380 I/P/A/-/- 0 NONE 00
  852. 6 235477c4 0 I/-/-/-/- 0 NONE 04
  853. ----------------------------------------
  854. SO: 0x23469ccc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  855. LIBRARY OBJECT LOCK: lock=23469ccc handle=2355e4b4 mode=N
  856. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  857. htl=0x23469d18[0x23fea74c,0x2346a468] htb=0x23fea74c ssga=0x23fea138
  858. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x23ee
  859. LIBRARY OBJECT HANDLE: handle=2355e4b4 mutex=0x2355e568(2)
  860. name=select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1
  861. hash=2c7d8d54a642c499a38f8bd87da474ac timestamp=06-23-2008 08:56:27
  862. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  863. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=002a hlc=002a
  864. lwt=0x2355e510[0x2355e510,0x2355e510] ltm=0x2355e518[0x2355e518,0x2355e518]
  865. pwt=0x2355e4f4[0x2355e4f4,0x2355e4f4] ptm=0x2355e4fc[0x2355e4fc,0x2355e4fc]
  866. ref=0x2355e530[0x2355e530,0x2355e530] lnd=0x2355e53c[0x2359c270,0x2356164c]
  867. LIBRARY OBJECT: object=2355e03c
  868. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  869. CHILDREN: size=16
  870. child# table reference handle
  871. ------ -------- --------- --------
  872. 0 23557c5c 23557910 2355df40
  873. 1 23557c5c 23557a80 23599fe4
  874. DATA BLOCKS:
  875. data# heap pointer status pins change whr
  876. ----- -------- -------- --------- ---- ------ ---
  877. 0 2355e444 2355e0d4 I/P/A/-/- 0 NONE 00
  878. ----------------------------------------
  879. SO: 0x2346504c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  880. LIBRARY OBJECT LOCK: lock=2346504c handle=235134c4 mode=N
  881. call pin=(nil) session pin=0x23465c4c hpc=0000 hlc=0000
  882. htl=0x23465098[0x23469908,0x23fea9b4] htb=0x23fea9b4 ssga=0x23fea138
  883. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  884. LIBRARY OBJECT HANDLE: handle=235134c4 mutex=0x23513578(0)
  885. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  886. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0014 hlc=0014
  887. lwt=0x23513520[0x23513520,0x23513520] ltm=0x23513528[0x23465068,0x23465068]
  888. pwt=0x23513504[0x23513504,0x23513504] ptm=0x2351350c[0x2351350c,0x2351350c]
  889. ref=0x23513540[0x23515288,0x23515288] lnd=0x2351354c[0x2351354c,0x2351354c]
  890. LIBRARY OBJECT: object=234f91c0
  891. DATA BLOCKS:
  892. data# heap pointer status pins change whr
  893. ----- -------- -------- --------- ---- ------ ---
  894. 0 2371ec38 234f9310 I/P/A/-/- 0 NONE 00
  895. 6 237e3650 0 I/-/-/-/- 0 NONE 04
  896. ----------------------------------------
  897. SO: 0x234698bc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  898. LIBRARY OBJECT LOCK: lock=234698bc handle=2353a6d8 mode=N
  899. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  900. htl=0x23469908[0x23fea9b4,0x23465098] htb=0x23fea9b4 ssga=0x23fea138
  901. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x23e0
  902. LIBRARY OBJECT HANDLE: handle=2353a6d8 mutex=0x2353a78c(2)
  903. name=select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
  904. hash=12f772e1a2097382e4555ba057bc44f9 timestamp=06-23-2008 08:56:27
  905. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  906. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=002c hlc=002c
  907. lwt=0x2353a734[0x2353a734,0x2353a734] ltm=0x2353a73c[0x2353a73c,0x2353a73c]
  908. pwt=0x2353a718[0x2353a718,0x2353a718] ptm=0x2353a720[0x2353a720,0x2353a720]
  909. ref=0x2353a754[0x2353a754,0x2353a754] lnd=0x2353a760[0x235275a0,0x2354df40]
  910. LIBRARY OBJECT: object=2352787c
  911. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  912. CHILDREN: size=16
  913. child# table reference handle
  914. ------ -------- --------- --------
  915. 0 23515464 23515118 2353a5f4
  916. 1 23515464 23515288 235134c4
  917. DATA BLOCKS:
  918. data# heap pointer status pins change whr
  919. ----- -------- -------- --------- ---- ------ ---
  920. 0 23535538 23527914 I/P/A/-/- 0 NONE 00
  921. ----------------------------------------
  922. SO: 0x23464ca4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  923. LIBRARY OBJECT LOCK: lock=23464ca4 handle=23560c20 mode=N
  924. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  925. htl=0x23464cf0[0x23465030,0x23fea8c4] htb=0x23fea8c4 ssga=0x23fea138
  926. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  927. LIBRARY OBJECT HANDLE: handle=23560c20 mutex=0x23560cd4(0)
  928. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  929. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0004 hlc=0004
  930. lwt=0x23560c7c[0x23560c7c,0x23560c7c] ltm=0x23560c84[0x23464cc0,0x23464cc0]
  931. pwt=0x23560c60[0x23560c60,0x23560c60] ptm=0x23560c68[0x23560c68,0x23560c68]
  932. ref=0x23560c9c[0x23560d8c,0x23560d8c] lnd=0x23560ca8[0x23560ca8,0x23560ca8]
  933. LIBRARY OBJECT: object=237d2e74
  934. DATA BLOCKS:
  935. data# heap pointer status pins change whr
  936. ----- -------- -------- --------- ---- ------ ---
  937. 0 235cbe40 237d2fc4 I/P/A/-/- 0 NONE 00
  938. 6 237d2604 0 I/-/-/-/- 0 NONE 04
  939. ----------------------------------------
  940. SO: 0x23464fe4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  941. LIBRARY OBJECT LOCK: lock=23464fe4 handle=235615c4 mode=N
  942. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  943. htl=0x23465030[0x23fea8c4,0x23464cf0] htb=0x23fea8c4 ssga=0x23fea138
  944. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2345
  945. LIBRARY OBJECT HANDLE: handle=235615c4 mutex=0x23561678(2)
  946. name=select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0),nvl(spare1,0)from clu$ where obj#=:1
  947. hash=cc0bbf5f14f51baa02e1f0fcac6b9bdb timestamp=06-23-2008 08:56:27
  948. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  949. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0006 hlc=0006
  950. lwt=0x23561620[0x23561620,0x23561620] ltm=0x23561628[0x23561628,0x23561628]
  951. pwt=0x23561604[0x23561604,0x23561604] ptm=0x2356160c[0x2356160c,0x2356160c]
  952. ref=0x23561640[0x23561640,0x23561640] lnd=0x2356164c[0x2355e53c,0x23586a48]
  953. LIBRARY OBJECT: object=2356114c
  954. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  955. CHILDREN: size=16
  956. child# table reference handle
  957. ------ -------- --------- --------
  958. 0 235610d8 23560d8c 23560c20
  959. 1 235610d8 23560efc 230e4ac8
  960. DATA BLOCKS:
  961. data# heap pointer status pins change whr
  962. ----- -------- -------- --------- ---- ------ ---
  963. 0 23561554 235611e4 I/P/A/-/- 0 NONE 00
  964. ----------------------------------------
  965. SO: 0x2346a3b4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  966. LIBRARY OBJECT LOCK: lock=2346a3b4 handle=2358c158 mode=N
  967. call pin=(nil) session pin=0x234664d4 hpc=0000 hlc=0000
  968. htl=0x2346a400[0x2346a2c8,0x23fea5dc] htb=0x23fea5dc ssga=0x23fea138
  969. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  970. LIBRARY OBJECT HANDLE: handle=2358c158 mutex=0x2358c20c(0)
  971. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  972. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=000c hlc=000c
  973. lwt=0x2358c1b4[0x2358c1b4,0x2358c1b4] ltm=0x2358c1bc[0x2346a3d0,0x2346a3d0]
  974. pwt=0x2358c198[0x2358c198,0x2358c198] ptm=0x2358c1a0[0x2358c1a0,0x2358c1a0]
  975. ref=0x2358c1d4[0x2357fd98,0x2357fd98] lnd=0x2358c1e0[0x2358c1e0,0x2358c1e0]
  976. LIBRARY OBJECT: object=2358bd40
  977. DATA BLOCKS:
  978. data# heap pointer status pins change whr
  979. ----- -------- -------- --------- ---- ------ ---
  980. 0 237e1f40 2358be90 I/P/A/-/- 0 NONE 00
  981. 6 234eefa8 0 I/-/-/-/- 0 NONE 04
  982. ----------------------------------------
  983. SO: 0x2346a27c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  984. LIBRARY OBJECT LOCK: lock=2346a27c handle=235869c0 mode=N
  985. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  986. htl=0x2346a2c8[0x23fea5dc,0x2346a400] htb=0x23fea5dc ssga=0x23fea138
  987. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2322
  988. LIBRARY OBJECT HANDLE: handle=235869c0 mutex=0x23586a74(2)
  989. name=select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
  990. hash=ae93e4a5100360375a3ff87632f4667e timestamp=06-23-2008 08:56:27
  991. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  992. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0014 hlc=0014
  993. lwt=0x23586a1c[0x23586a1c,0x23586a1c] ltm=0x23586a24[0x23586a24,0x23586a24]
  994. pwt=0x23586a00[0x23586a00,0x23586a00] ptm=0x23586a08[0x23586a08,0x23586a08]
  995. ref=0x23586a3c[0x23586a3c,0x23586a3c] lnd=0x23586a48[0x2356164c,0x2356ade0]
  996. LIBRARY OBJECT: object=2357ffe8
  997. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  998. CHILDREN: size=16
  999. child# table reference handle
  1000. ------ -------- --------- --------
  1001. 0 2357ff74 2357fc28 235868dc
  1002. 1 2357ff74 2357fd98 2358c158
  1003. DATA BLOCKS:
  1004. data# heap pointer status pins change whr
  1005. ----- -------- -------- --------- ---- ------ ---
  1006. 0 2359926c 23580080 I/P/A/-/- 0 NONE 00
  1007. ----------------------------------------
  1008. SO: 0x2346998c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1009. LIBRARY OBJECT LOCK: lock=2346998c handle=235135a8 mode=N
  1010. call pin=(nil) session pin=0x23466624 hpc=0000 hlc=0000
  1011. htl=0x234699d8[0x2346a0c0,0x234653d8] htb=0x23fea5f4 ssga=0x23fea138
  1012. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  1013. LIBRARY OBJECT HANDLE: handle=235135a8 mutex=0x2351365c(0)
  1014. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  1015. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0010 hlc=0010
  1016. lwt=0x23513604[0x23513604,0x23513604] ltm=0x2351360c[0x23469940,0x23474fd0]
  1017. pwt=0x235135e8[0x235135e8,0x235135e8] ptm=0x235135f0[0x235135f0,0x235135f0]
  1018. ref=0x23513624[0x23587694,0x23587694] lnd=0x23513630[0x23513630,0x23513630]
  1019. LIBRARY OBJECT: object=2377e0f0
  1020. DATA BLOCKS:
  1021. data# heap pointer status pins change whr
  1022. ----- -------- -------- --------- ---- ------ ---
  1023. 0 236258bc 2377e240 I/P/A/-/- 0 NONE 00
  1024. 6 23593dd4 0 I/-/-/-/- 0 NONE 04
  1025. ----------------------------------------
  1026. SO: 0x2346a074, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1027. LIBRARY OBJECT LOCK: lock=2346a074 handle=2356ad58 mode=N
  1028. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  1029. htl=0x2346a0c0[0x23fea5f4,0x234699d8] htb=0x23fea5f4 ssga=0x23fea138
  1030. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x22fd
  1031. LIBRARY OBJECT HANDLE: handle=2356ad58 mutex=0x2356ae0c(2)
  1032. name=
  1033. select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#
  1034. hash=16030b5c728b234081e54a3c95c2a581 timestamp=06-23-2008 08:56:27
  1035. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
  1036. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0022 hlc=0022
  1037. lwt=0x2356adb4[0x2356adb4,0x2356adb4] ltm=0x2356adbc[0x2356adbc,0x2356adbc]
  1038. pwt=0x2356ad98[0x2356ad98,0x2356ad98] ptm=0x2356ada0[0x2356ada0,0x2356ada0]
  1039. ref=0x2356add4[0x2356add4,0x2356add4] lnd=0x2356ade0[0x23586a48,0x2357d910]
  1040. LIBRARY OBJECT: object=2356a8e0
  1041. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  1042. CHILDREN: size=16
  1043. child# table reference handle
  1044. ------ -------- --------- --------
  1045. 0 23587870 23587524 2356a7d8
  1046. 1 23587870 23587694 235135a8
  1047. DATA BLOCKS:
  1048. data# heap pointer status pins change whr
  1049. ----- -------- -------- --------- ---- ------ ---
  1050. 0 2356ace8 2356a978 I/P/A/-/- 0 NONE 00
  1051. ----------------------------------------
  1052. SO: 0x2346a484, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1053. LIBRARY OBJECT LOCK: lock=2346a484 handle=2351368c mode=N
  1054. call pin=(nil) session pin=0x234663d8 hpc=0000 hlc=0000
  1055. htl=0x2346a4d0[0x23469cb0,0x23fea85c] htb=0x23fea85c ssga=0x23fea138
  1056. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  1057. LIBRARY OBJECT HANDLE: handle=2351368c mutex=0x23513740(0)
  1058. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  1059. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=000a hlc=000a
  1060. lwt=0x235136e8[0x235136e8,0x235136e8] ltm=0x235136f0[0x2346a4a0,0x2346a4a0]
  1061. pwt=0x235136cc[0x235136cc,0x235136cc] ptm=0x235136d4[0x235136d4,0x235136d4]
  1062. ref=0x23513708[0x2356c170,0x2356c170] lnd=0x23513714[0x23513714,0x23513714]
  1063. LIBRARY OBJECT: object=23528820
  1064. DATA BLOCKS:
  1065. data# heap pointer status pins change whr
  1066. ----- -------- -------- --------- ---- ------ ---
  1067. 0 236bc0b0 23528970 I/P/A/-/- 0 NONE 00
  1068. 6 2377e510 0 I/-/-/-/- 0 NONE 04
  1069. ----------------------------------------
  1070. SO: 0x23469c64, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1071. LIBRARY OBJECT LOCK: lock=23469c64 handle=2357d888 mode=N
  1072. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  1073. htl=0x23469cb0[0x23fea85c,0x2346a4d0] htb=0x23fea85c ssga=0x23fea138
  1074. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x22de
  1075. LIBRARY OBJECT HANDLE: handle=2357d888 mutex=0x2357d93c(2)
  1076. name=select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
  1077. hash=f8e43e747a17f71f63993cf787e718ce timestamp=06-23-2008 08:56:27
  1078. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  1079. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
  1080. lwt=0x2357d8e4[0x2357d8e4,0x2357d8e4] ltm=0x2357d8ec[0x2357d8ec,0x2357d8ec]
  1081. pwt=0x2357d8c8[0x2357d8c8,0x2357d8c8] ptm=0x2357d8d0[0x2357d8d0,0x2357d8d0]
  1082. ref=0x2357d904[0x2357d904,0x2357d904] lnd=0x2357d910[0x2356ade0,0x23771e08]
  1083. LIBRARY OBJECT: object=2356c3c0
  1084. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  1085. CHILDREN: size=16
  1086. child# table reference handle
  1087. ------ -------- --------- --------
  1088. 0 2356c34c 2356c000 2356be94
  1089. 1 2356c34c 2356c170 2351368c
  1090. DATA BLOCKS:
  1091. data# heap pointer status pins change whr
  1092. ----- -------- -------- --------- ---- ------ ---
  1093. 0 23598178 2356c458 I/P/A/-/- 0 NONE 00
  1094. ----------------------------------------
  1095. SO: 0x23464d0c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1096. LIBRARY OBJECT LOCK: lock=23464d0c handle=235595c8 mode=N
  1097. call pin=(nil) session pin=0x23465f94 hpc=0000 hlc=0000
  1098. htl=0x23464d58[0x23469de8,0x2346a1f8] htb=0x23fea79c ssga=0x23fea138
  1099. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  1100. LIBRARY OBJECT HANDLE: handle=235595c8 mutex=0x2355967c(0)
  1101. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  1102. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0010 hlc=0010
  1103. lwt=0x23559624[0x23559624,0x23559624] ltm=0x2355962c[0x23465618,0x23474f00]
  1104. pwt=0x23559608[0x23559608,0x23559608] ptm=0x23559610[0x23559610,0x23559610]
  1105. ref=0x23559644[0x2352da94,0x2352da94] lnd=0x23559650[0x23559650,0x23559650]
  1106. LIBRARY OBJECT: object=2355f7a8
  1107. DATA BLOCKS:
  1108. data# heap pointer status pins change whr
  1109. ----- -------- -------- --------- ---- ------ ---
  1110. 0 236fdc90 2355f8f8 I/P/A/-/- 0 NONE 00
  1111. 6 2355ef38 0 I/-/-/-/- 0 NONE 04
  1112. ----------------------------------------
  1113. SO: 0x23469d9c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1114. LIBRARY OBJECT LOCK: lock=23469d9c handle=235244f4 mode=N
  1115. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  1116. htl=0x23469de8[0x23fea79c,0x23464d58] htb=0x23fea79c ssga=0x23fea138
  1117. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x22b1
  1118. LIBRARY OBJECT HANDLE: handle=235244f4 mutex=0x235245a8(2)
  1119. name=
  1120. select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
  1121. hash=1d4a51a2c89ab6b07a3c64bebc5573b6 timestamp=06-23-2008 08:56:27
  1122. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]
  1123. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0024 hlc=0024
  1124. lwt=0x23524550[0x23524550,0x23524550] ltm=0x23524558[0x23524558,0x23524558]
  1125. pwt=0x23524534[0x23524534,0x23524534] ptm=0x2352453c[0x2352453c,0x2352453c]
  1126. ref=0x23524570[0x23524570,0x23524570] lnd=0x2352457c[0x235226d0,0x2359d488]
  1127. LIBRARY OBJECT: object=2352dce0
  1128. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  1129. CHILDREN: size=16
  1130. child# table reference handle
  1131. ------ -------- --------- --------
  1132. 0 2352dc6c 2352d920 2352d7b4
  1133. 1 2352dc6c 2352da94 235595c8
  1134. DATA BLOCKS:
  1135. data# heap pointer status pins change whr
  1136. ----- -------- -------- --------- ---- ------ ---
  1137. 0 23531564 2352dd78 I/P/A/-/- 0 NONE 00
  1138. ----------------------------------------
  1139. SO: 0x23469b2c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1140. LIBRARY OBJECT LOCK: lock=23469b2c handle=23523564 mode=N
  1141. call pin=(nil) session pin=0x23465e44 hpc=0000 hlc=0000
  1142. htl=0x23469b78[0x23465238,0x2346a608] htb=0x23fea5bc ssga=0x23fea138
  1143. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  1144. LIBRARY OBJECT HANDLE: handle=23523564 mutex=0x23523618(0)
  1145. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  1146. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0010 hlc=0010
  1147. lwt=0x235235c0[0x235235c0,0x235235c0] ltm=0x235235c8[0x23469f58,0x23474e30]
  1148. pwt=0x235235a4[0x235235a4,0x235235a4] ptm=0x235235ac[0x235235ac,0x235235ac]
  1149. ref=0x235235e0[0x2354d850,0x2354d850] lnd=0x235235ec[0x235235ec,0x235235ec]
  1150. LIBRARY OBJECT: object=2359a940
  1151. DATA BLOCKS:
  1152. data# heap pointer status pins change whr
  1153. ----- -------- -------- --------- ---- ------ ---
  1154. 0 23744e00 2359aa90 I/P/A/-/- 0 NONE 00
  1155. 6 2359a0d0 0 I/-/-/-/- 0 NONE 04
  1156. ----------------------------------------
  1157. SO: 0x234651ec, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1158. LIBRARY OBJECT LOCK: lock=234651ec handle=2354deb8 mode=N
  1159. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  1160. htl=0x23465238[0x23fea5bc,0x23469b78] htb=0x23fea5bc ssga=0x23fea138
  1161. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2284
  1162. LIBRARY OBJECT HANDLE: handle=2354deb8 mutex=0x2354df6c(2)
  1163. name=
  1164. select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
  1165. hash=436a415b2251827617e919499a05b67a timestamp=06-23-2008 08:56:27
  1166. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
  1167. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0024 hlc=0024
  1168. lwt=0x2354df14[0x2354df14,0x2354df14] ltm=0x2354df1c[0x2354df1c,0x2354df1c]
  1169. pwt=0x2354def8[0x2354def8,0x2354def8] ptm=0x2354df00[0x2354df00,0x2354df00]
  1170. ref=0x2354df34[0x2354df34,0x2354df34] lnd=0x2354df40[0x2353a760,0x2358adcc]
  1171. LIBRARY OBJECT: object=2354daa0
  1172. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  1173. CHILDREN: size=16
  1174. child# table reference handle
  1175. ------ -------- --------- --------
  1176. 0 2354da2c 2354d6e0 23531690
  1177. 1 2354da2c 2354d850 23523564
  1178. DATA BLOCKS:
  1179. data# heap pointer status pins change whr
  1180. ----- -------- -------- --------- ---- ------ ---
  1181. 0 23543b78 2354db38 I/P/A/-/- 0 NONE 00
  1182. ----------------------------------------
  1183. SO: 0x23465594, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1184. LIBRARY OBJECT LOCK: lock=23465594 handle=2359ea9c mode=N
  1185. call pin=(nil) session pin=0x23466138 hpc=0000 hlc=0000
  1186. htl=0x234655e0[0x234651d0,0x2346a128] htb=0x23fea66c ssga=0x23fea138
  1187. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  1188. LIBRARY OBJECT HANDLE: handle=2359ea9c mutex=0x2359eb50(0)
  1189. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  1190. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=000e hlc=000e
  1191. lwt=0x2359eaf8[0x2359eaf8,0x2359eaf8] ltm=0x2359eb00[0x23464f98,0x234752a8]
  1192. pwt=0x2359eadc[0x2359eadc,0x2359eadc] ptm=0x2359eae4[0x2359eae4,0x2359eae4]
  1193. ref=0x2359eb18[0x235aa134,0x235aa134] lnd=0x2359eb24[0x2359eb24,0x2359eb24]
  1194. LIBRARY OBJECT: object=235a7b20
  1195. DATA BLOCKS:
  1196. data# heap pointer status pins change whr
  1197. ----- -------- -------- --------- ---- ------ ---
  1198. 0 237742ac 235a7c70 I/P/A/-/- 0 NONE 00
  1199. 6 235ae764 0 I/-/-/-/- 0 NONE 04
  1200. ----------------------------------------
  1201. SO: 0x23465184, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1202. LIBRARY OBJECT LOCK: lock=23465184 handle=2358ad44 mode=N
  1203. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  1204. htl=0x234651d0[0x23fea66c,0x234655e0] htb=0x23fea66c ssga=0x23fea138
  1205. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x226e
  1206. LIBRARY OBJECT HANDLE: handle=2358ad44 mutex=0x2358adf8(2)
  1207. name=select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
  1208. hash=b26a259f381e87d302773791f5e84a90 timestamp=06-23-2008 08:56:27
  1209. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
  1210. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
  1211. lwt=0x2358ada0[0x2358ada0,0x2358ada0] ltm=0x2358ada8[0x2358ada8,0x2358ada8]
  1212. pwt=0x2358ad84[0x2358ad84,0x2358ad84] ptm=0x2358ad8c[0x2358ad8c,0x2358ad8c]
  1213. ref=0x2358adc0[0x2358adc0,0x2358adc0] lnd=0x2358adcc[0x2354df40,0x23725b5c]
  1214. LIBRARY OBJECT: object=2358a92c
  1215. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  1216. CHILDREN: size=16
  1217. child# table reference handle
  1218. ------ -------- --------- --------
  1219. 0 235aa2f4 235a9fa8 235a9e3c
  1220. 1 235aa2f4 235aa134 2359ea9c
  1221. DATA BLOCKS:
  1222. data# heap pointer status pins change whr
  1223. ----- -------- -------- --------- ---- ------ ---
  1224. 0 23590794 2358a9c4 I/P/A/-/- 0 NONE 00
  1225. ----------------------------------------
  1226. SO: 0x2346a4ec, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1227. LIBRARY OBJECT LOCK: lock=2346a4ec handle=235cb2a8 mode=N
  1228. call pin=(nil) session pin=0x23466480 hpc=0000 hlc=0000
  1229. htl=0x2346a538[0x23465510,0x23fea4c4] htb=0x23fea4c4 ssga=0x23fea138
  1230. user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
  1231. LIBRARY OBJECT HANDLE: handle=235cb2a8 mutex=0x235cb35c(0)
  1232. namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
  1233. kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0002 hlc=0002
  1234. lwt=0x235cb304[0x235cb304,0x235cb304] ltm=0x235cb30c[0x2346a508,0x2346a508]
  1235. pwt=0x235cb2e8[0x235cb2e8,0x235cb2e8] ptm=0x235cb2f0[0x235cb2f0,0x235cb2f0]
  1236. ref=0x235cb324[0x235cb414,0x235cb414] lnd=0x235cb330[0x235cb330,0x235cb330]
  1237. LIBRARY OBJECT: object=235cae30
  1238. DATA BLOCKS:
  1239. data# heap pointer status pins change whr
  1240. ----- -------- -------- --------- ---- ------ ---
  1241. 0 235cb238 235caf80 I/P/A/-/- 0 NONE 00
  1242. 6 235c658c 0 I/-/-/-/- 0 NONE 04
  1243. ----------------------------------------
  1244. SO: 0x234654c4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1245. LIBRARY OBJECT LOCK: lock=234654c4 handle=235e5398 mode=N
  1246. call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
  1247. htl=0x23465510[0x23fea4c4,0x2346a538] htb=0x23fea4c4 ssga=0x23fea138
  1248. user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x225a
  1249. LIBRARY OBJECT HANDLE: handle=235e5398 mutex=0x235e544c(1)
  1250. name=delete from obj$ where obj# = :1
  1251. hash=f71aa535c97ed95d54ee311937a7a95b timestamp=06-23-2008 08:56:27
  1252. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/KST/DBN/MTX/[120100d4]
  1253. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0002 hlc=0002
  1254. lwt=0x235e53f4[0x235e53f4,0x235e53f4] ltm=0x235e53fc[0x235e53fc,0x235e53fc]
  1255. pwt=0x235e53d8[0x235e53d8,0x235e53d8] ptm=0x235e53e0[0x235e53e0,0x235e53e0]
  1256. ref=0x235e5414[0x235e5414,0x235e5414] lnd=0x235e5420[0x236ba90c,0x2373b280]
  1257. LIBRARY OBJECT: object=235cb7d4
  1258. type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
  1259. CHILDREN: size=16
  1260. child# table reference handle
  1261. ------ -------- --------- --------
  1262. 0 235cb760 235cb414 235cb2a8
  1263. DATA BLOCKS:
  1264. data# heap pointer status pins change whr
  1265. ----- -------- -------- --------- ---- ------ ---
  1266. 0 235e531c 235cb86c I/P/A/-/- 0 NONE 00
  1267. ----------------------------------------
  1268. SO: 0x255c6750, type: 5, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1269. (enqueue) TS-00000003-00000001 DID: 0001-0008-00000003
  1270. lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x2
  1271. res: 255d255c, mode: SX, prv: 255d2564, own: 2553e1dc, sess: 2553e1dc, proc: 2550ada8
  1272. ----------------------------------------
  1273. SO: 0x253fb760, type: 41, owner: 0x2553e1dc, flag: INIT/-/-/0x00
  1274. (dummy) nxc=2, nlb=1
  1275. ----------------------------------------
  1276. SO: 0x253f8b9c, type: 40, owner: 0x253fb760, flag: INIT/-/-/0x00
  1277. (trans) flg = 0x04, flg2 = 0x00, prx = 0x0, ros = 2147483647 bsn = 0x2512 spn = 0x2512
  1278. efd = 4
  1279. parent xid: 0x0000.000.00000000
  1280. env: (scn: 0x0000.00000000 xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 statement num=0 parent xid: xid: 0x0000.000.00000000 scn: 0x0000.00000000 0sch: scn: 0x0000.00000000)
  1281. cev: (spc = 0 arsp = 0 ubk tsn: 0 rdba: 0x00000000 useg tsn: 0 rdba: 0x00000000
  1282. hwm uba: 0x00000000.0000.00 col uba: 0x00000000.0000.00
  1283. num bl: 0 bk list: 0x0)
  1284. cr opc: 0x0 spc: 0 uba: 0x00000000.0000.00
  1285. (enqueue) <no resource>
  1286. res: 0, prv: 0, own: 0, sess: 0
  1287. xga: 0x0, heap: UGA
  1288. Trans IMU st: 2 Pool index 65535, Redo pool 0x253f8fc8, Undo pool 0x253f9044
  1289. Redo pool range [0x0 0xb7266a90 0xb7269290]
  1290. Undo pool range [0x0 0xb7264290 0xb7266a90]
  1291. ----------------------------------------
  1292. SO: 0x253f90b8, type: 40, owner: 0x253fb760, flag: INIT/-/-/0x00
  1293. (trans) flg = 0x04, flg2 = 0x00, prx = 0x253f8b9c, ros = 2147483647 bsn = 0x250f spn = 0x2510
  1294. efd = 4
  1295. parent xid: 0x0000.000.00000000
  1296. env: (scn: 0x0000.0002bc51 xid: 0x0008.025.00000063 uba: 0x00000000.0000.00 statement num=0 parent xid: xid: 0x0000.000.00000000 scn: 0x0000.00000000 0sch: scn: 0x0000.00000000)
  1297. cev: (spc = 1524 arsp = 0 ubk tsn: 1 rdba: 0x008039a4 useg tsn: 2147483647 rdba: 0x00000000
  1298. hwm uba: 0x008039a4.0038.35 col uba: 0x00000000.0000.00
  1299. num bl: 0 bk list: 0x0)
  1300. cr opc: 0x0 spc: 1524 uba: 0x008039a4.0038.35
  1301. (enqueue) CU-2304FA78-00000000 DID: 0001-0008-00000003
  1302. lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x0
  1303. res: 255d2b44, prv: 255d2b4c, own: 2553e1dc, sess: 2553e1dc
  1304. xga: 0x0, heap: UGA
  1305. Trans IMU st: 0 Pool index 65535, Redo pool 0x253f94e4, Undo pool 0x253f9560
  1306. Redo pool range [0x0 0xb72ad800 0xb72b0000]
  1307. Undo pool range [0x0 0xb72ab000 0xb72ad800]
  1308. ----------------------------------------
  1309. SO: 0x25789cd8, type: 39, owner: 0x253fb760, flag: -/-/-/0x00
  1310. (List of Blocks) next index = 3
  1311. index itli buffer hint rdba savepoint
  1312. -----------------------------------------------------------
  1313. 0 2 0x2538bf84 0x4011c4 0x242e
  1314. 1 2 0x2538bcb4 0x4011d2 0x2431
  1315. 2 2 0x2538bd68 0x4011da 0x2433
  1316. ----------------------------------------
  1317. SO: 0x2560539c, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
  1318. (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
  1319. event: 8, last message event: 18,
  1320. last message waited event: 18, messages read: 1
  1321. channel: (0x25605fe0) system events broadcast channel
  1322. scope: 2, event: 21, last mesage event: 18,
  1323. publishers/subscribers: 0/8,
  1324. messages published: 1
  1325. ----------------------------------------
  1326. SO: 0x2554b13c, type: 3, owner: 0x2550ada8, flag: INIT/-/-/0x00
  1327. (call) sess: cur 2553e1dc, rec 0, usr 2553e1dc; depth: 0
  1328. ----------------------------------------
  1329. SO: 0x252cd1e8, type: 16, owner: 0x2550ada8, flag: INIT/-/-/0x00
  1330. (osp req holder)
  1331. ===================================================
  1332. CURRENT SESSION'S INSTANTIATION STATE
  1333. -------------------------------------
  1334. current session=0x2553e1dc
  1335. KGI STATE DUMP for session=0x2553e1dc
  1336. -------------------------------------
  1337. INSTANTIATION OBJECT: object=0xb728cb38
  1338. type="KOKA open cursor"[1] lock=(nil) handle=(nil) body=(nil) level=0
  1339. flags=[40] executions=0
  1340. REST OF INSTANTIATION OBJECT:
  1341. address=0xb728cba4 size=12
  1342. (nil) 0x000005 0x00000a
  1343. -------------------------------------
  1344. INSTANTIATION OBJECT: object=0xb728cab4
  1345. type="KOKA pseudo cursor"[2] lock=(nil) handle=(nil) body=(nil) level=0
  1346. flags=[40] executions=0
  1347. REST OF INSTANTIATION OBJECT:
  1348. address=0xb728cb20 size=12
  1349. (nil) 0x000005 0x00000a
  1350. KGI STATE DUMP DONE for session=0x2553e1dc
  1351. ******************** Session Cursor Dump **********************
  1352. Current cursor: 0, pgadep: 0
  1353. Open cursors(pls, sys, hwm, max): 0(0, 0, 50, 50)
  1354. NULL 0 SYNTAX 0 PARSE 0 BOUND 0 FETCH 0 ROW 0
  1355. Cached frame pages(total, free):
  1356. 4k(6, 6), 8k(1, 1), 16k(0, 0), 32k(0, 0)
  1357. Session cached cursors
  1358. -----------------------------------------------------------
  1359. -------------- Generic Session Cached Cursors Dump --------
  1360. -----------------------------------------------------------
  1361. hash table=0xb7281970 cnt=20 LRU=0xb72778d0 cnt=20 hit=449 max=20 NumberOfTypes=3
  1362. type#0 name=KQD count=15
  1363. type#1 name=KQD BUN count=0
  1364. type#2 name=KKS count=5
  1365. Bucket#003 seg=0xb72819c4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1366. 0 cob=0xb72b9094 0 flg=0 typ=2 idx=3 cur=(nil) lru=0 flg=0 hdl=(nil)
  1367. 1 cob=0xb72b90a4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1368. 2 cob=0xb72b90b4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1369. 3 cob=0xb72b90c4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1370. Bucket#007 seg=0xb7281a44 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1371. 0 cob=0xb72b912c 0 flg=0 typ=2 idx=7 cur=(nil) lru=0 flg=0 hdl=(nil)
  1372. 1 cob=0xb72b913c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1373. 2 cob=0xb72b914c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1374. 3 cob=0xb72b915c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1375. Bucket#014 seg=0xb7281b24 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1376. 0 cob=0xb7293504 0 flg=0 typ=2 idx=e cur=(nil) lru=0 flg=0 hdl=(nil)
  1377. 1 cob=0xb7293514 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1378. 2 cob=0xb7293524 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1379. 3 cob=0xb7293534 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1380. Bucket#015 seg=0xb7281b44 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1381. 0 cob=0xb7287ec8 0 flg=0 typ=2 idx=f cur=(nil) lru=0 flg=0 hdl=(nil)
  1382. 1 cob=0xb7287ed8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1383. 2 cob=0xb7287ee8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1384. 3 cob=0xb7287ef8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1385. Bucket#020 seg=0xb7281be4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1386. 0 cob=0xb72b1408 0 flg=0 typ=0 idx=14 cur=(nil) lru=0 flg=0 hdl=(nil)
  1387. 1 cob=0xb72b1418 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1388. 2 cob=0xb72b1428 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1389. 3 cob=0xb72b1438 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1390. Bucket#028 seg=0xb7281ce4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1391. 0 cob=0xb72b0494 0 flg=0 typ=0 idx=1c cur=(nil) lru=0 flg=0 hdl=(nil)
  1392. 1 cob=0xb72b04a4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1393. 2 cob=0xb72b04b4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1394. 3 cob=0xb72b04c4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1395. Bucket#029 seg=0xb7281d04 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1396. 0 cob=0xb7293550 0 flg=0 typ=2 idx=1d cur=(nil) lru=0 flg=0 hdl=(nil)
  1397. 1 cob=0xb7293560 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1398. 2 cob=0xb7293570 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1399. 3 cob=0xb7293580 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1400. Bucket#039 seg=0xb7281e44 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1401. 0 cob=0xb729ba94 0 flg=0 typ=2 idx=27 cur=(nil) lru=0 flg=0 hdl=(nil)
  1402. 1 cob=0xb729baa4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1403. 2 cob=0xb729bab4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1404. 3 cob=0xb729bac4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1405. Bucket#046 seg=0xb7281f24 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1406. 0 cob=0xb72b947c 0 flg=0 typ=2 idx=2e cur=(nil) lru=0 flg=0 hdl=(nil)
  1407. 1 cob=0xb72b948c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1408. 2 cob=0xb72b949c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1409. 3 cob=0xb72b94ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1410. Bucket#049 seg=0xb7281f84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1411. 0 cob=0xb72b237c 0 flg=0 typ=0 idx=31 cur=(nil) lru=0 flg=0 hdl=(nil)
  1412. 1 cob=0xb72b238c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1413. 2 cob=0xb72b239c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1414. 3 cob=0xb72b23ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1415. Bucket#056 seg=0xb7282064 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=4
  1416. 0 cob=0xb729cbac 38 flg=0 typ=0 idx=38 cur=0xb72bf8b8 lru=1 flg=1 hdl=0x230f80e0
  1417. 1 cob=0xb729cbbc 10038 flg=0 typ=0 idx=10038 cur=0xb72cf534 lru=1 flg=1 hdl=0x230f80e0
  1418. 2 cob=0xb729cbcc 20038 flg=0 typ=0 idx=20038 cur=0xb72b24d8 lru=1 flg=1 hdl=0x230f80e0
  1419. 3 cob=0xb729cbdc 30038 flg=0 typ=0 idx=30038 cur=0xb72ba43c lru=1 flg=1 hdl=0x230f80e0
  1420. Bucket#065 seg=0xb7282184 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1421. 0 cob=0xb72b36fc 0 flg=0 typ=0 idx=41 cur=(nil) lru=0 flg=0 hdl=(nil)
  1422. 1 cob=0xb72b370c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1423. 2 cob=0xb72b371c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1424. 3 cob=0xb72b372c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1425. Bucket#073 seg=0xb7282284 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1426. 0 cob=0xb72b0264 0 flg=0 typ=2 idx=49 cur=(nil) lru=0 flg=0 hdl=(nil)
  1427. 1 cob=0xb72b0274 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1428. 2 cob=0xb72b0284 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1429. 3 cob=0xb72b0294 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1430. Bucket#079 seg=0xb7282344 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1431. 0 cob=0xb72cf468 0 flg=0 typ=2 idx=4f cur=(nil) lru=0 flg=0 hdl=(nil)
  1432. 1 cob=0xb72cf478 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1433. 2 cob=0xb72cf488 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1434. 3 cob=0xb72cf498 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1435. Bucket#087 seg=0xb7282444 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1436. 0 cob=0xb72cf41c 0 flg=0 typ=2 idx=57 cur=(nil) lru=0 flg=0 hdl=(nil)
  1437. 1 cob=0xb72cf42c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1438. 2 cob=0xb72cf43c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1439. 3 cob=0xb72cf44c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1440. Bucket#092 seg=0xb72824e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1441. 0 cob=0xb7296544 5c flg=0 typ=2 idx=5c cur=0xb72cfe28 lru=1 flg=1 hdl=0x235e5398
  1442. 1 cob=0xb7296554 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1443. 2 cob=0xb7296564 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1444. 3 cob=0xb7296574 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1445. Bucket#105 seg=0xb7282684 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1446. 0 cob=0xb72920fc 0 flg=0 typ=0 idx=69 cur=(nil) lru=0 flg=0 hdl=(nil)
  1447. 1 cob=0xb729210c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1448. 2 cob=0xb729211c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1449. 3 cob=0xb729212c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1450. Bucket#106 seg=0xb72826a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1451. 0 cob=0xb72b9430 0 flg=0 typ=2 idx=6a cur=(nil) lru=0 flg=0 hdl=(nil)
  1452. 1 cob=0xb72b9440 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1453. 2 cob=0xb72b9450 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1454. 3 cob=0xb72b9460 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1455. Bucket#111 seg=0xb7282744 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1456. 0 cob=0xb729a398 0 flg=0 typ=2 idx=6f cur=(nil) lru=0 flg=0 hdl=(nil)
  1457. 1 cob=0xb729a3a8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1458. 2 cob=0xb729a3b8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1459. 3 cob=0xb729a3c8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1460. Bucket#115 seg=0xb72827c4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1461. 0 cob=0xb7287e7c 0 flg=0 typ=2 idx=73 cur=(nil) lru=0 flg=0 hdl=(nil)
  1462. 1 cob=0xb7287e8c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1463. 2 cob=0xb7287e9c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1464. 3 cob=0xb7287eac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1465. Bucket#116 seg=0xb72827e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1466. 0 cob=0xb7292184 0 flg=0 typ=2 idx=74 cur=(nil) lru=0 flg=0 hdl=(nil)
  1467. 1 cob=0xb7292194 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1468. 2 cob=0xb72921a4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1469. 3 cob=0xb72921b4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1470. Bucket#122 seg=0xb72828a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1471. 0 cob=0xb72bf3e0 0 flg=0 typ=2 idx=7a cur=(nil) lru=0 flg=0 hdl=(nil)
  1472. 1 cob=0xb72bf3f0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1473. 2 cob=0xb72bf400 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1474. 3 cob=0xb72bf410 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1475. Bucket#123 seg=0xb72828c4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
  1476. 0 cob=0xb7287df4 7b flg=0 typ=0 idx=7b cur=0xb72b1574 lru=1 flg=5 hdl=0x2354deb8
  1477. 1 cob=0xb7287e04 1007b flg=0 typ=0 idx=1007b cur=0xb72bfa9c lru=1 flg=5 hdl=0x2354deb8
  1478. 2 cob=0xb7287e14 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1479. 3 cob=0xb7287e24 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1480. Bucket#124 seg=0xb72828e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1481. 0 cob=0xb7287f14 0 flg=0 typ=0 idx=7c cur=(nil) lru=0 flg=0 hdl=(nil)
  1482. 1 cob=0xb7287f24 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1483. 2 cob=0xb7287f34 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1484. 3 cob=0xb7287f44 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1485. Bucket#127 seg=0xb7282944 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1486. 0 cob=0xb729347c 7f flg=0 typ=0 idx=7f cur=0xb729fd54 lru=1 flg=5 hdl=0x235869c0
  1487. 1 cob=0xb729348c 0 flg=0 typ=2 idx=1007f cur=(nil) lru=0 flg=0 hdl=(nil)
  1488. 2 cob=0xb729349c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1489. 3 cob=0xb72934ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1490. Bucket#130 seg=0xb72829a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
  1491. 0 cob=0xb729ba0c 82 flg=0 typ=0 idx=82 cur=0xb72bf64c lru=1 flg=5 hdl=0x2356ad58
  1492. 1 cob=0xb729ba1c 10082 flg=0 typ=0 idx=10082 cur=0xb7298d78 lru=1 flg=5 hdl=0x2356ad58
  1493. 2 cob=0xb729ba2c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1494. 3 cob=0xb729ba3c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1495. Bucket#132 seg=0xb72829e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1496. 0 cob=0xb72ba31c 0 flg=0 typ=0 idx=84 cur=(nil) lru=0 flg=0 hdl=(nil)
  1497. 1 cob=0xb72ba32c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1498. 2 cob=0xb72ba33c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1499. 3 cob=0xb72ba34c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1500. Bucket#136 seg=0xb7282a64 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1501. 0 cob=0xb72b935c 88 flg=0 typ=0 idx=88 cur=0xb72bfe28 lru=1 flg=5 hdl=0x234fe3b4
  1502. 1 cob=0xb72b936c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1503. 2 cob=0xb72b937c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1504. 3 cob=0xb72b938c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1505. Bucket#137 seg=0xb7282a84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1506. 0 cob=0xb72b900c 89 flg=0 typ=0 idx=89 cur=0xb72b9178 lru=1 flg=5 hdl=0x235042c8
  1507. 1 cob=0xb72b901c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1508. 2 cob=0xb72b902c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1509. 3 cob=0xb72b903c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1510. Bucket#145 seg=0xb7282b84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
  1511. 0 cob=0xb728b1a4 91 flg=0 typ=0 idx=91 cur=0xb72cfb70 lru=1 flg=5 hdl=0x2358ad44
  1512. 1 cob=0xb728b1b4 10091 flg=0 typ=0 idx=10091 cur=0xb728637c lru=1 flg=5 hdl=0x2358ad44
  1513. 2 cob=0xb728b1c4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1514. 3 cob=0xb728b1d4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1515. Bucket#160 seg=0xb7282d64 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1516. 0 cob=0xb72921d0 0 flg=0 typ=2 idx=a0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1517. 1 cob=0xb72921e0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1518. 2 cob=0xb72921f0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1519. 3 cob=0xb7292200 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1520. Bucket#161 seg=0xb7282d84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1521. 0 cob=0xb72b93e4 0 flg=0 typ=2 idx=a1 cur=(nil) lru=0 flg=0 hdl=(nil)
  1522. 1 cob=0xb72b93f4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1523. 2 cob=0xb72b9404 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1524. 3 cob=0xb72b9414 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1525. Bucket#162 seg=0xb7282da4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1526. 0 cob=0xb729a3e4 0 flg=0 typ=2 idx=a2 cur=(nil) lru=0 flg=0 hdl=(nil)
  1527. 1 cob=0xb729a3f4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1528. 2 cob=0xb729a404 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1529. 3 cob=0xb729a414 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1530. Bucket#172 seg=0xb7282ee4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1531. 0 cob=0xb7296360 0 flg=0 typ=2 idx=ac cur=(nil) lru=0 flg=0 hdl=(nil)
  1532. 1 cob=0xb7296370 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1533. 2 cob=0xb7296380 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1534. 3 cob=0xb7296390 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1535. Bucket#173 seg=0xb7282f04 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1536. 0 cob=0xb72bb650 0 flg=0 typ=0 idx=ad cur=(nil) lru=0 flg=0 hdl=(nil)
  1537. 1 cob=0xb72bb660 100ad flg=0 typ=0 idx=100ad cur=0xb72bf468 lru=1 flg=5 hdl=0x2355e4b4
  1538. 2 cob=0xb72bb670 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1539. 3 cob=0xb72bb680 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1540. Bucket#183 seg=0xb7283044 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
  1541. 0 cob=0xb729ea7c b7 flg=0 typ=0 idx=b7 cur=0xb72b0600 lru=1 flg=5 hdl=0x235244f4
  1542. 1 cob=0xb729ea8c 100b7 flg=0 typ=0 idx=100b7 cur=0xb729cc44 lru=1 flg=5 hdl=0x235244f4
  1543. 2 cob=0xb729ea9c 0 flg=0 typ=0 idx=200b7 cur=(nil) lru=0 flg=0 hdl=(nil)
  1544. 3 cob=0xb729eaac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1545. Bucket#185 seg=0xb7283084 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1546. 0 cob=0xb729bae0 0 flg=0 typ=2 idx=b9 cur=(nil) lru=0 flg=0 hdl=(nil)
  1547. 1 cob=0xb729baf0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1548. 2 cob=0xb729bb00 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1549. 3 cob=0xb729bb10 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1550. Bucket#192 seg=0xb7283164 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1551. 0 cob=0xb729bb2c 0 flg=0 typ=2 idx=c0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1552. 1 cob=0xb729bb3c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1553. 2 cob=0xb729bb4c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1554. 3 cob=0xb729bb5c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1555. Bucket#202 seg=0xb72832a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1556. 0 cob=0xb7296314 0 flg=0 typ=2 idx=ca cur=(nil) lru=0 flg=0 hdl=(nil)
  1557. 1 cob=0xb7296324 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1558. 2 cob=0xb7296334 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1559. 3 cob=0xb7296344 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1560. Bucket#207 seg=0xb7283344 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1561. 0 cob=0xb7296590 cf flg=0 typ=0 idx=cf cur=0xb7289fb4 lru=1 flg=5 hdl=0x2357d888
  1562. 1 cob=0xb72965a0 0 flg=0 typ=2 idx=100cf cur=(nil) lru=0 flg=0 hdl=(nil)
  1563. 2 cob=0xb72965b0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1564. 3 cob=0xb72965c0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1565. Bucket#220 seg=0xb72834e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1566. 0 cob=0xb7291fdc dc flg=0 typ=0 idx=dc cur=0xb728a39c lru=1 flg=5 hdl=0x235615c4
  1567. 1 cob=0xb7291fec 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1568. 2 cob=0xb7291ffc 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1569. 3 cob=0xb729200c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1570. Bucket#240 seg=0xb7283764 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1571. 0 cob=0xb72b90e0 0 flg=0 typ=2 idx=f0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1572. 1 cob=0xb72b90f0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1573. 2 cob=0xb72b9100 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1574. 3 cob=0xb72b9110 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1575. Bucket#247 seg=0xb7283844 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1576. 0 cob=0xb72bf830 0 flg=0 typ=2 idx=f7 cur=(nil) lru=0 flg=0 hdl=(nil)
  1577. 1 cob=0xb72bf840 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1578. 2 cob=0xb72bf850 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1579. 3 cob=0xb72bf860 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1580. Bucket#250 seg=0xb72838a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
  1581. 0 cob=0xb72bc5c4 0 flg=0 typ=0 idx=fa cur=(nil) lru=0 flg=0 hdl=(nil)
  1582. 1 cob=0xb72bc5d4 100fa flg=0 typ=0 idx=100fa cur=0xb728a1b8 lru=1 flg=5 hdl=0x2353a6d8
  1583. 2 cob=0xb72bc5e4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1584. 3 cob=0xb72bc5f4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1585. Bucket#255 seg=0xb7283944 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
  1586. 0 cob=0xb729359c 0 flg=0 typ=2 idx=ff cur=(nil) lru=0 flg=0 hdl=(nil)
  1587. 1 cob=0xb72935ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1588. 2 cob=0xb72935bc 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1589. 3 cob=0xb72935cc 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
  1590. -----------------------------------------------------------
  1591. ------Finished Dumping Generic Session Cached Cursors------
  1592. -----------------------------------------------------------
  1593. ----------------------------------------
  1594. sqltxt(0x235e5398)=delete from obj$ where obj# = :1
  1595. hash=f71aa535c97ed95d54ee311937a7a95b
  1596. parent=0x235cb86c maxchild=01 plk=0x234654c4 ppn=n
  1597. cursor instantiation=0xb72cfe28
  1598. child#0(0x235cb2a8) pcs=0x235cba70
  1599. clk=0x2346a4ec ci=0x235caf80 pn=(nil) ctx=(nil)
  1600. kgsccflg=1 llk[0xb72b1578,0xb72778d0] idx=5c
  1601. xscflg=100400 fl2=1000400 fl3=22180 fl4=0
  1602. kkscoacd
  1603. Bind#0
  1604. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  1605. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1606. No bind buffers allocated
  1607. Frames pfr (nil) siz=3976 efr (nil) siz=3964
  1608. Cursor frame dump
  1609. ----------------------------------------
  1610. sqltxt(0x2354deb8)=
  1611. select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
  1612. hash=436a415b2251827617e919499a05b67a
  1613. parent=0x2354db38 maxchild=02 plk=0x234651ec ppn=n
  1614. cursor instantiation=0xb72b1574
  1615. child#1(0x23523564) pcs=0x2354d708
  1616. clk=0x23469b2c ci=0x2359aa90 pn=(nil) ctx=(nil)
  1617. kgsccflg=5 llk[0xb72cfb74,0xb72cfe2c] idx=7b
  1618. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1619. kkscoacd
  1620. Bind#0
  1621. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1622. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1623. kxsbbbfp=b7295ee4 bln=22 avl=03 flg=05
  1624. value=575
  1625. Frames pfr 0xb72962c0 siz=8400 efr 0xb7294d4c siz=8384
  1626. Cursor frame dump
  1627. kxscphp 0xb72901f0 siz=5204 inu=4484 nps=4452
  1628. kxscdfhp 0xb7290e50 siz=1000 inu=56 nps=0
  1629. kxscehp 0xb7291714 siz=1000 inu=108 nps=36
  1630. kxscefhp 0xb72900e8 siz=3048 inu=2240 nps=2208
  1631. ----------------------------------------
  1632. sqltxt(0x2358ad44)=select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
  1633. hash=b26a259f381e87d302773791f5e84a90
  1634. parent=0x2358a9c4 maxchild=02 plk=0x23465184 ppn=n
  1635. cursor instantiation=0xb72cfb70
  1636. child#1(0x2359ea9c) pcs=0x235a9fec
  1637. clk=0x23465594 ci=0x235a7c70 pn=(nil) ctx=(nil)
  1638. kgsccflg=5 llk[0xb728a3a0,0xb72b1578] idx=91
  1639. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1640. kkscoacd
  1641. Bind#0
  1642. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1643. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1644. kxsbbbfp=b72b2358 bln=22 avl=01 flg=05
  1645. value=0
  1646. Bind#1
  1647. oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
  1648. oacflg=18 fl2=0001 frm=01 csi=01 siz=32 off=0
  1649. kxsbbbfp=b72b232c bln=32 avl=16 flg=05
  1650. value="SMON_SCN_TO_TIME"
  1651. Bind#2
  1652. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1653. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1654. kxsbbbfp=b72b2308 bln=24 avl=02 flg=05
  1655. value=5
  1656. Frames pfr 0xb72b1cf8 siz=3740 efr 0xb72b0b90 siz=3728
  1657. Cursor frame dump
  1658. kxscphp 0xb7285ba8 siz=2016 inu=1556 nps=1492
  1659. kxscdfhp 0xb7290ed4 siz=1000 inu=56 nps=0
  1660. kxscehp 0xb72902f8 siz=1000 inu=228 nps=116
  1661. kxscefhp 0xb72908a4 siz=1000 inu=108 nps=36
  1662. ----------------------------------------
  1663. sqltxt(0x235615c4)=select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0),nvl(spare1,0)from clu$ where obj#=:1
  1664. hash=cc0bbf5f14f51baa02e1f0fcac6b9bdb
  1665. parent=0x235611e4 maxchild=02 plk=0x23464fe4 ppn=n
  1666. cursor instantiation=0xb728a39c
  1667. child#0(0x23560c20) pcs=0x235613e8
  1668. clk=0x23464ca4 ci=0x237d2fc4 pn=(nil) ctx=(nil)
  1669. kgsccflg=5 llk[0xb7289fb8,0xb72cfb74] idx=dc
  1670. xscflg=a0141436 fl2=45000401 fl3=2210c fl4=0
  1671. kkscoacd
  1672. Bind#0
  1673. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1674. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1675. kxsbbbfp=b72b2ec0 bln=22 avl=03 flg=05
  1676. value=573
  1677. Frames pfr 0xb72cfb1c siz=3464 efr 0xb729a2c8 siz=3452
  1678. Cursor frame dump
  1679. kxscphp 0xb72900e8 siz=3048 inu=2240 nps=2208
  1680. kxscdfhp 0xb7290610 siz=1000 inu=56 nps=0
  1681. kxscehp 0xb7290ab4 siz=1000 inu=108 nps=36
  1682. kxscefhp 0xb72908a4 siz=1000 inu=108 nps=36
  1683. ----------------------------------------
  1684. sqltxt(0x2357d888)=select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
  1685. hash=f8e43e747a17f71f63993cf787e718ce
  1686. parent=0x2356c458 maxchild=02 plk=0x23469c64 ppn=n
  1687. cursor instantiation=0xb7289fb4
  1688. child#1(0x2351368c) pcs=0x2356c028
  1689. clk=0x2346a484 ci=0x23528970 pn=(nil) ctx=(nil)
  1690. kgsccflg=5 llk[0xb72b0604,0xb728a3a0] idx=cf
  1691. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1692. kkscoacd
  1693. Bind#0
  1694. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1695. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1696. kxsbbbfp=b72baa08 bln=22 avl=03 flg=05
  1697. value=574
  1698. Frames pfr 0xb72baa70 siz=2176 efr 0xb72baac0 siz=2164
  1699. Cursor frame dump
  1700. kxscphp 0xb7290c40 siz=1000 inu=952 nps=920
  1701. kxscdfhp 0xb7290a30 siz=1000 inu=56 nps=0
  1702. kxscehp 0xb7290484 siz=1000 inu=108 nps=36
  1703. kxscefhp 0xb7290928 siz=2016 inu=1880 nps=1848
  1704. ----------------------------------------
  1705. sqltxt(0x235244f4)=
  1706. select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
  1707. hash=1d4a51a2c89ab6b07a3c64bebc5573b6
  1708. parent=0x2352dd78 maxchild=02 plk=0x23469d9c ppn=n
  1709. cursor instantiation=0xb72b0600
  1710. child#1(0x235595c8) pcs=0x2352d94c
  1711. clk=0x23464d0c ci=0x2355f8f8 pn=(nil) ctx=(nil)
  1712. kgsccflg=5 llk[0xb72bf650,0xb7289fb8] idx=b7
  1713. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1714. kkscoacd
  1715. Bind#0
  1716. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1717. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1718. kxsbbbfp=b729b5dc bln=22 avl=03 flg=05
  1719. value=573
  1720. Bind#1
  1721. No oacdef for this bind.
  1722. Frames pfr 0xb72bb4f0 siz=12136 efr 0xb729b994 siz=12112
  1723. Cursor frame dump
  1724. kxscphp 0xb7291588 siz=5264 inu=4600 nps=4552
  1725. kxscdfhp 0xb7290b38 siz=1000 inu=212 nps=0
  1726. kxscehp 0xb7291270 siz=1000 inu=128 nps=36
  1727. kxscefhp 0xb729079c siz=1000 inu=712 nps=680
  1728. ----------------------------------------
  1729. sqltxt(0x2356ad58)=
  1730. select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#
  1731. hash=16030b5c728b234081e54a3c95c2a581
  1732. parent=0x2356a978 maxchild=02 plk=0x2346a074 ppn=n
  1733. cursor instantiation=0xb72bf64c
  1734. child#1(0x235135a8) pcs=0x2358754c
  1735. clk=0x2346998c ci=0x2377e240 pn=(nil) ctx=(nil)
  1736. kgsccflg=5 llk[0xb728a1bc,0xb72b0604] idx=82
  1737. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1738. kkscoacd
  1739. Bind#0
  1740. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1741. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1742. kxsbbbfp=b729304c bln=22 avl=03 flg=05
  1743. value=573
  1744. Frames pfr 0xb7293428 siz=4308 efr 0xb7292690 siz=4296
  1745. Cursor frame dump
  1746. kxscphp 0xb7290f58 siz=3168 inu=2472 nps=2440
  1747. kxscdfhp 0xb7290cc4 siz=1000 inu=204 nps=0
  1748. kxscehp 0xb729058c siz=1000 inu=108 nps=36
  1749. kxscefhp 0xb72908a4 siz=1000 inu=108 nps=36
  1750. ----------------------------------------
  1751. sqltxt(0x2353a6d8)=select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
  1752. hash=12f772e1a2097382e4555ba057bc44f9
  1753. parent=0x23527914 maxchild=02 plk=0x234698bc ppn=n
  1754. cursor instantiation=0xb728a1b8
  1755. child#1(0x235134c4) pcs=0x23515140
  1756. clk=0x2346504c ci=0x234f9310 pn=(nil) ctx=(nil)
  1757. kgsccflg=5 llk[0xb72bf46c,0xb72bf650] idx=100fa
  1758. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1759. kkscoacd
  1760. Bind#0
  1761. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1762. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1763. kxsbbbfp=b7299344 bln=22 avl=03 flg=05
  1764. value=575
  1765. Frames pfr 0xb7299428 siz=2132 efr 0xb7299470 siz=2120
  1766. Cursor frame dump
  1767. kxscphp 0xb7290274 siz=1000 inu=828 nps=796
  1768. kxscdfhp 0xb7290400 siz=1000 inu=56 nps=0
  1769. kxscehp 0xb72908a4 siz=1000 inu=108 nps=36
  1770. kxscefhp 0xb729079c siz=1000 inu=712 nps=680
  1771. ----------------------------------------
  1772. sqltxt(0x2355e4b4)=select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1
  1773. hash=2c7d8d54a642c499a38f8bd87da474ac
  1774. parent=0x2355e0d4 maxchild=02 plk=0x23469ccc ppn=n
  1775. cursor instantiation=0xb72bf468
  1776. child#1(0x23599fe4) pcs=0x23557938
  1777. clk=0x2346a41c ci=0x237e3380 pn=(nil) ctx=(nil)
  1778. kgsccflg=5 llk[0xb729fd58,0xb728a1bc] idx=100ad
  1779. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1780. kkscoacd
  1781. Bind#0
  1782. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1783. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1784. kxsbbbfp=b72875b8 bln=22 avl=03 flg=05
  1785. value=575
  1786. Frames pfr 0xb7287644 siz=3036 efr 0xb728768c siz=3024
  1787. Cursor frame dump
  1788. kxscphp 0xb7290928 siz=2016 inu=1880 nps=1848
  1789. kxscdfhp 0xb7290d48 siz=1000 inu=204 nps=0
  1790. kxscehp 0xb7290508 siz=1000 inu=108 nps=36
  1791. kxscefhp 0xb729079c siz=1000 inu=712 nps=680
  1792. ----------------------------------------
  1793. sqltxt(0x235869c0)=select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
  1794. hash=ae93e4a5100360375a3ff87632f4667e
  1795. parent=0x23580080 maxchild=02 plk=0x2346a27c ppn=n
  1796. cursor instantiation=0xb729fd54
  1797. child#1(0x2358c158) pcs=0x2357fc50
  1798. clk=0x2346a3b4 ci=0x2358be90 pn=(nil) ctx=(nil)
  1799. kgsccflg=5 llk[0xb72bfe2c,0xb72bf46c] idx=7f
  1800. xscflg=a1141436 fl2=5000401 fl3=2210c fl4=0
  1801. kkscoacd
  1802. Bind#0
  1803. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1804. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1805. kxsbbbfp=b728a968 bln=22 avl=03 flg=05
  1806. value=575
  1807. Frames pfr 0xb72b3304 siz=2496 efr 0xb728ad38 siz=2484
  1808. Cursor frame dump
  1809. kxscphp 0xb7290694 siz=2016 inu=1180 nps=1148
  1810. kxscdfhp 0xb72909ac siz=1000 inu=56 nps=0
  1811. kxscehp 0xb7290dcc siz=1000 inu=108 nps=36
  1812. ----------------------------------------
  1813. sqltxt(0x234fe3b4)=select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
  1814. hash=d751142c3b7971bd655864a445f58a87
  1815. parent=0x235067e4 maxchild=02 plk=0x23464d74 ppn=n
  1816. cursor instantiation=0xb72bfe28
  1817. child#1(0x234fd368) pcs=0x235063b4
  1818. clk=0x2346a144 ci=0x23549f58 pn=(nil) ctx=(nil)
  1819. kgsccflg=5 llk[0xb72b917c,0xb729fd58] idx=88
  1820. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1821. kkscoacd
  1822. Bind#0
  1823. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1824. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1825. kxsbbbfp=b729ea58 bln=22 avl=03 flg=05
  1826. value=575
  1827. Frames pfr 0xb72866e0 siz=2704 efr 0xb7286728 siz=2692
  1828. Cursor frame dump
  1829. kxscphp 0xb729079c siz=1000 inu=712 nps=680
  1830. kxscdfhp 0xb728625c siz=1000 inu=56 nps=0
  1831. kxscehp 0xb7285c2c siz=1000 inu=108 nps=36
  1832. ----------------------------------------
  1833. sqltxt(0x235042c8)=select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
  1834. hash=26947ac91d45c1242b247fc5f6b6f088
  1835. parent=0x23503ee8 maxchild=02 plk=0x2346a554 ppn=n
  1836. cursor instantiation=0xb72b9178
  1837. child#1(0x23517b58) pcs=0x23503ab8
  1838. clk=0x23464eac ci=0x23520dfc pn=(nil) ctx=(nil)
  1839. kgsccflg=5 llk[0xb7286380,0xb72bfe2c] idx=89
  1840. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1841. kkscoacd
  1842. Bind#0
  1843. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1844. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1845. kxsbbbfp=b729de34 bln=22 avl=03 flg=05
  1846. value=575
  1847. Frames pfr 0xb729df8c siz=2736 efr 0xb729dfd4 siz=2724
  1848. Cursor frame dump
  1849. kxscphp 0xb7291dc8 siz=1000 inu=712 nps=680
  1850. kxscdfhp 0xb7291ab0 siz=1000 inu=56 nps=0
  1851. kxscehp 0xb7291d44 siz=1000 inu=108 nps=36
  1852. ----------------------------------------
  1853. sqltxt(0x2358ad44)=select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
  1854. hash=b26a259f381e87d302773791f5e84a90
  1855. parent=0x2358a9c4 maxchild=02 plk=0x2346a0dc ppn=n
  1856. cursor instantiation=0xb728637c
  1857. child#1(0x2359ea9c) pcs=0x235a9fec
  1858. clk=0x23464f7c ci=0x235a7c70 pn=(nil) ctx=(nil)
  1859. kgsccflg=5 llk[0xb72bfaa0,0xb72b917c] idx=10091
  1860. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1861. kkscoacd
  1862. Bind#0
  1863. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1864. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1865. kxsbbbfp=b729d61c bln=22 avl=01 flg=05
  1866. value=0
  1867. Bind#1
  1868. oacdty=01 mxl=32(11) mxlc=00 mal=00 scl=00 pre=00
  1869. oacflg=18 fl2=0001 frm=01 csi=01 siz=32 off=0
  1870. kxsbbbfp=b729d5f0 bln=32 avl=11 flg=05
  1871. value="IND_ONLINE$"
  1872. Bind#2
  1873. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1874. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1875. kxsbbbfp=b729d5cc bln=24 avl=02 flg=05
  1876. value=1
  1877. Frames pfr 0xb729cfbc siz=3740 efr 0xb7299b20 siz=3728
  1878. Cursor frame dump
  1879. kxscphp 0xb7291e4c siz=2016 inu=1556 nps=1492
  1880. kxscdfhp 0xb7291924 siz=1000 inu=56 nps=0
  1881. kxscehp 0xb7291cc0 siz=1000 inu=228 nps=116
  1882. ----------------------------------------
  1883. sqltxt(0x2354deb8)=
  1884. select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
  1885. hash=436a415b2251827617e919499a05b67a
  1886. parent=0x2354db38 maxchild=02 plk=0x2346a5bc ppn=n
  1887. cursor instantiation=0xb72bfa9c
  1888. child#1(0x23523564) pcs=0x2354d708
  1889. clk=0x23469f3c ci=0x2359aa90 pn=(nil) ctx=(nil)
  1890. kgsccflg=5 llk[0xb729cc48,0xb7286380] idx=1007b
  1891. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1892. kkscoacd
  1893. Bind#0
  1894. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1895. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1896. kxsbbbfp=b7297f2c bln=22 avl=03 flg=05
  1897. value=731
  1898. Frames pfr 0xb7298308 siz=8400 efr 0xb7296d94 siz=8384
  1899. Cursor frame dump
  1900. kxscphp 0xb7291bb8 siz=5204 inu=4484 nps=4452
  1901. kxscdfhp 0xb7291798 siz=1000 inu=56 nps=0
  1902. kxscehp 0xb7291a2c siz=1000 inu=108 nps=36
  1903. ----------------------------------------
  1904. sqltxt(0x235244f4)=
  1905. select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
  1906. hash=1d4a51a2c89ab6b07a3c64bebc5573b6
  1907. parent=0x2352dd78 maxchild=02 plk=0x2346a1ac ppn=n
  1908. cursor instantiation=0xb729cc44
  1909. child#1(0x235595c8) pcs=0x2352d94c
  1910. clk=0x234655fc ci=0x2355f8f8 pn=(nil) ctx=(nil)
  1911. kgsccflg=5 llk[0xb7298d7c,0xb72bfaa0] idx=100b7
  1912. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1913. kkscoacd
  1914. Bind#0
  1915. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1916. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1917. kxsbbbfp=b72befb0 bln=22 avl=03 flg=05
  1918. value=731
  1919. Bind#1
  1920. No oacdef for this bind.
  1921. Frames pfr 0xb72bdd90 siz=12136 efr 0xb72bf368 siz=12112
  1922. Cursor frame dump
  1923. kxscphp 0xb7291b34 siz=5264 inu=4600 nps=4552
  1924. kxscdfhp 0xb72918a0 siz=1000 inu=212 nps=0
  1925. kxscehp 0xb7291480 siz=1000 inu=128 nps=36
  1926. ----------------------------------------
  1927. sqltxt(0x2356ad58)=
  1928. select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#
  1929. hash=16030b5c728b234081e54a3c95c2a581
  1930. parent=0x2356a978 maxchild=02 plk=0x2346538c ppn=n
  1931. cursor instantiation=0xb7298d78
  1932. child#1(0x235135a8) pcs=0x2358754c
  1933. clk=0x23469924 ci=0x2377e240 pn=(nil) ctx=(nil)
  1934. kgsccflg=5 llk[0xb72bf8bc,0xb729cc48] idx=10082
  1935. xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
  1936. kkscoacd
  1937. Bind#0
  1938. oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  1939. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1940. kxsbbbfp=b72bd2a8 bln=22 avl=03 flg=05
  1941. value=731
  1942. Frames pfr 0xb72bd684 siz=4308 efr 0xb72bc8ec siz=4296
  1943. Cursor frame dump
  1944. kxscphp 0xb72919a8 siz=3184 inu=2472 nps=2440
  1945. kxscdfhp 0xb7291060 siz=1000 inu=204 nps=0
  1946. kxscehp 0xb729037c siz=1000 inu=108 nps=36
  1947. ----------------------------------------
  1948. sqltxt(0x230f80e0)=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  1949. hash=6d11d7de2049577d933d2385337fc737
  1950. parent=0x230f7d00 maxchild=02 plk=0x2346a214 ppn=n
  1951. cursor instantiation=0xb72bf8b8
  1952. child#1(0x23558d44) pcs=0x23111a84
  1953. clk=0x23464a9c ci=0x22ef6510 pn=(nil) ctx=0x23521f04
  1954. kgsccflg=1 llk[0xb72cf538,0xb7298d7c] idx=38
  1955. xscflg=100410 fl2=1000401 fl3=22100 fl4=0
  1956. Bind bytecodes
  1957. Opcode = 1 Unoptimized
  1958. Offsi = 36, Offsi = 0
  1959. Opcode = 1 Unoptimized
  1960. Offsi = 36, Offsi = 20
  1961. kkscoacd
  1962. Bind#0
  1963. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  1964. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1965. No bind buffers allocated
  1966. Bind#1
  1967. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  1968. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1969. No bind buffers allocated
  1970. Frames pfr (nil) siz=3160 efr (nil) siz=3148
  1971. Cursor frame dump
  1972. enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
  1973. pnxt: 2.0x00000004 pnxt: 1.0x00000008
  1974. ----------------------------------------
  1975. sqltxt(0x230f80e0)=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  1976. hash=6d11d7de2049577d933d2385337fc737
  1977. parent=0x230f7d00 maxchild=02 plk=0x23464b04 ppn=n
  1978. cursor instantiation=0xb72cf534
  1979. child#1(0x23558d44) pcs=0x23111a84
  1980. clk=0x23469b94 ci=0x22ef6510 pn=(nil) ctx=0x23521f04
  1981. kgsccflg=1 llk[0xb72b24dc,0xb72bf8bc] idx=10038
  1982. xscflg=100410 fl2=1000401 fl3=22100 fl4=0
  1983. Bind bytecodes
  1984. Opcode = 1 Unoptimized
  1985. Offsi = 36, Offsi = 0
  1986. Opcode = 1 Unoptimized
  1987. Offsi = 36, Offsi = 20
  1988. kkscoacd
  1989. Bind#0
  1990. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  1991. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1992. No bind buffers allocated
  1993. Bind#1
  1994. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  1995. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  1996. No bind buffers allocated
  1997. Frames pfr (nil) siz=3160 efr (nil) siz=3148
  1998. Cursor frame dump
  1999. enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
  2000. pnxt: 2.0x00000004 pnxt: 1.0x00000008
  2001. ----------------------------------------
  2002. sqltxt(0x230f80e0)=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  2003. hash=6d11d7de2049577d933d2385337fc737
  2004. parent=0x230f7d00 maxchild=02 plk=0x23464964 ppn=n
  2005. cursor instantiation=0xb72b24d8
  2006. child#1(0x23558d44) pcs=0x23111a84
  2007. clk=0x23464bd4 ci=0x22ef6510 pn=(nil) ctx=0x23521f04
  2008. kgsccflg=1 llk[0xb72ba440,0xb72cf538] idx=20038
  2009. xscflg=100410 fl2=1000401 fl3=22100 fl4=0
  2010. Bind bytecodes
  2011. Opcode = 1 Unoptimized
  2012. Offsi = 36, Offsi = 0
  2013. Opcode = 1 Unoptimized
  2014. Offsi = 36, Offsi = 20
  2015. kkscoacd
  2016. Bind#0
  2017. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  2018. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  2019. No bind buffers allocated
  2020. Bind#1
  2021. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  2022. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  2023. No bind buffers allocated
  2024. Frames pfr (nil) siz=3160 efr (nil) siz=3148
  2025. Cursor frame dump
  2026. enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
  2027. pnxt: 2.0x00000004 pnxt: 1.0x00000008
  2028. ----------------------------------------
  2029. sqltxt(0x230f80e0)=select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
  2030. hash=6d11d7de2049577d933d2385337fc737
  2031. parent=0x230f7d00 maxchild=02 plk=0x23469ac4 ppn=n
  2032. cursor instantiation=0xb72ba43c
  2033. child#1(0x23558d44) pcs=0x23111a84
  2034. clk=0x2346482c ci=0x22ef6510 pn=(nil) ctx=0x23521f04
  2035. kgsccflg=1 llk[0xb72778d0,0xb72b24dc] idx=30038
  2036. xscflg=100410 fl2=1000401 fl3=22100 fl4=0
  2037. Bind bytecodes
  2038. Opcode = 1 Unoptimized
  2039. Offsi = 36, Offsi = 0
  2040. Opcode = 1 Unoptimized
  2041. Offsi = 36, Offsi = 20
  2042. kkscoacd
  2043. Bind#0
  2044. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  2045. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  2046. No bind buffers allocated
  2047. Bind#1
  2048. oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
  2049. oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
  2050. No bind buffers allocated
  2051. Frames pfr (nil) siz=3160 efr (nil) siz=3148
  2052. Cursor frame dump
  2053. enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
  2054. pnxt: 2.0x00000004 pnxt: 1.0x00000008
  2055. Memory dump of process state object:
  2056. Dump of memory from 0x2550ADA8 to 0x2550B35C
  2057. 2550ADA0 00000102 00000000 [........]
  2058. 2550ADB0 00000000 00000000 00000000 234546D8 [.............FE#]
  2059. 2550ADC0 252CD1F4 2554B13C 252CC47C 00000000 [..,%<.T%|.,%....]
  2060. 2550ADD0 252CC4E0 252CC4E0 252CD1E8 00001601 [..,%..,%..,%....]
  2061. 2550ADE0 2553E1DC 2554B13C 00000008 2554C00C [..S%<.T%......T%]
  2062. 2550ADF0 2554C184 00000000 256053C0 234546F0 [..T%.....S`%.FE#]
  2063. 2550AE00 00000000 00000000 00000000 00000000 [................]
  2064. Repeat 3 times
  2065. 2550AE40 00000000 00170000 00000000 00040000 [................]
  2066. 2550AE50 00000000 00060000 00000000 000A0000 [................]
  2067. 2550AE60 00000000 000A0000 00000000 00040000 [................]
  2068. 2550AE70 00000000 00070000 00000000 000A0000 [................]
  2069. 2550AE80 00000000 00040000 00000000 00050000 [................]
  2070. 2550AE90 00000000 00110000 00000000 00000000 [................]
  2071. 2550AEA0 00000000 00000000 00000000 00000000 [................]
  2072. Repeat 1 times
  2073. 2550AEC0 485EF4BA 00000000 00000000 00000000 [..^H............]
  2074. 2550AED0 00000000 00000000 00000000 2550AEDC [..............P%]
  2075. 2550AEE0 2550AEDC 00000000 00000000 FFFFFFFF [..P%............]
  2076. 2550AEF0 2550AEF0 2550AEF0 00000000 00000000 [..P%..P%........]
  2077. 2550AF00 00000000 00000000 00000000 00000245 [............E...]
  2078. 2550AF10 00000000 00005645 00000090 00000004 [....EV..........]
  2079. 2550AF20 0000000F 00000011 2550C478 2550C478 [........x.P%x.P%]
  2080. 2550AF30 00010000 00000000 00000000 00000000 [................]
  2081. 2550AF40 00000000 00000000 00000000 00000000 [................]
  2082. Repeat 1 times
  2083. 2550AF60 000019C2 00000000 00000000 00000000 [................]
  2084. 2550AF70 00000000 00000000 00000000 00000000 [................]
  2085. Repeat 2 times
  2086. 2550AFA0 2550ADA8 00000000 00000000 00000000 [..P%............]
  2087. 2550AFB0 00000000 00000000 00000000 00000000 [................]
  2088. Repeat 5 times
  2089. 2550B010 00000000 00000000 485EF4BA 2550B01C [..........^H..P%]
  2090. 2550B020 2550B01C 00000000 00000000 00000001 [..P%............]
  2091. 2550B030 00000000 00000000 000C8001 0000000C [................]
  2092. 2550B040 000019C2 0216DA4E B74478D0 00000000 [....N....xD.....]
  2093. 2550B050 00000000 00000000 00000000 00000000 [................]
  2094. Repeat 1 times
  2095. 2550B070 00000004 FFFFFFFF 00000000 00000000 [................]
  2096. 2550B080 00000000 00000000 00000000 00000000 [................]
  2097. Repeat 7 times
  2098. 2550B100 6361726F 0000656C 00000000 00000000 [oracle..........]
  2099. 2550B110 00000000 00000000 00000000 00000000 [................]
  2100. 2550B120 00000006 746E6578 72656769 00000000 [....xentiger....]
  2101. 2550B130 00000000 00000000 00000000 00000000 [................]
  2102. Repeat 2 times
  2103. 2550B160 00000000 00000008 4E4B4E55 004E574F [........UNKNOWN.]
  2104. 2550B170 00000000 00000000 00000000 00000000 [................]
  2105. 2550B180 00000000 00000000 00000008 34393536 [............6594]
  2106. 2550B190 00000000 00000000 00000000 00000000 [................]
  2107. 2550B1A0 00000000 00000004 6361726F 7840656C [........oracle@x]
  2108. 2550B1B0 69746E65 20726567 4F4D5328 0000294E [entiger (SMON)..]
  2109. 2550B1C0 00000000 00000000 00000000 00000000 [................]
  2110. 2550B1D0 00000000 00000000 00000016 00000002 [................]
  2111. 2550B1E0 00000000 00000000 00000000 00000000 [................]
  2112. Repeat 9 times
  2113. 2550B280 00000000 00000200 00000000 00000000 [................]
  2114. 2550B290 00000000 00000000 25513CE4 2550B850 [.........<Q%P.P%]
  2115. 2550B2A0 2550ACE8 00000000 255DC7C0 00000000 [..P%......]%....]
  2116. 2550B2B0 00000000 00000000 00000000 00000000 [................]
  2117. 2550B2C0 00000000 2550B2C4 2550B2C4 00080000 [......P%..P%....]
  2118. 2550B2D0 00000000 0003949D 00071F11 000B949D [................]
  2119. 2550B2E0 00011CE8 00000000 000081B8 00000000 [................]
  2120. 2550B2F0 00024704 00000000 00000814 00000000 [.G..............]
  2121. 2550B300 00000088 00000000 00000814 00000000 [................]
  2122. 2550B310 00000000 00000000 00000000 00000000 [................]
  2123. Repeat 3 times
  2124. 2550B350 00000000 00000000 00000003 [............]
  2125. Symbolic dump of process state object:
  2126. KSUPRFLG = 22
  2127. KSUPRSER = 1
  2128. KSUPRIOC = 0
  2129. KSLLALAQ = 0X00000000
  2130. KSLLAWAT = 0X00000000
  2131. KSLLAWHY = 0
  2132. KSLLAWER = 0
  2133. KSLLALOW = 0
  2134. KSLLAPSC = 15
  2135. KSLLAPRC = 17
  2136. KSLLAPRV = 144
  2137. KSLLAPSN = 4
  2138. KSLLID1R = 0
  2139. KSLLID2R = 0
  2140. KSLLRTYP = ''
  2141. KSLLRMTY = 0
  2142. KSUPRPID = ''
  2143. KSUPRUNM = 'oracle'
  2144. KSUPRMNM = ''
  2145. KSUPRPNM = 'oracle@xentiger (SMON)'
  2146. KSUPRTID = ''
  2147. KSSRCOBJ = 0X00000000
  2148. KSSRCFRE = 0X00000000
  2149. KSSRCSRC = 0X00000000
  2150. KSSRCDST = 0X00000000
  2151. KSASTQNX = 0X2550B01C
  2152. KSASTQPR = 0X2550B01C
  2153. KSASTRPL = 0
  2154. KSUPRPUM = 466705
  2155. KSUPRPNAM = 234653
  2156. KSUPRPRAM = 524288
  2157. KSUPRPFM = 0
  2158. KSUPRPMM = 758941
  2159. KSFD PGA DUMPS
  2160. Number of completed I/O requests=0 flags=0
  2161. END OF PROCESS STATE
  2162. *** 2008-06-23 09:01:49.429
  2163. SMON: following errors trapped and ignored:
  2164. ORA-00376: file 1 cannot be read at this time
  2165. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2166. *** 2008-06-23 09:01:59.433
  2167. SMON: following errors trapped and ignored:
  2168. ORA-00376: file 1 cannot be read at this time
  2169. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2170. *** 2008-06-23 09:02:09.435
  2171. SMON: following errors trapped and ignored:
  2172. ORA-00376: file 1 cannot be read at this time
  2173. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2174. *** 2008-06-23 09:02:19.438
  2175. SMON: following errors trapped and ignored:
  2176. ORA-00376: file 1 cannot be read at this time
  2177. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2178. *** 2008-06-23 09:02:29.442
  2179. SMON: following errors trapped and ignored:
  2180. ORA-00376: file 1 cannot be read at this time
  2181. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2182. *** 2008-06-23 09:02:39.445
  2183. SMON: following errors trapped and ignored:
  2184. ORA-00376: file 1 cannot be read at this time
  2185. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2186. *** 2008-06-23 09:02:49.449
  2187. SMON: following errors trapped and ignored:
  2188. ORA-00376: file 1 cannot be read at this time
  2189. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2190. *** 2008-06-23 09:02:59.451
  2191. SMON: following errors trapped and ignored:
  2192. ORA-00376: file 1 cannot be read at this time
  2193. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2194. *** 2008-06-23 09:03:09.455
  2195. SMON: following errors trapped and ignored:
  2196. ORA-00376: file 1 cannot be read at this time
  2197. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2198. *** 2008-06-23 09:03:19.458
  2199. SMON: following errors trapped and ignored:
  2200. ORA-00376: file 1 cannot be read at this time
  2201. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2202. *** 2008-06-23 09:03:29.462
  2203. SMON: following errors trapped and ignored:
  2204. ORA-00376: file 1 cannot be read at this time
  2205. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2206. *** 2008-06-23 09:03:39.465
  2207. SMON: following errors trapped and ignored:
  2208. ORA-00376: file 1 cannot be read at this time
  2209. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2210. *** 2008-06-23 09:03:49.468
  2211. SMON: following errors trapped and ignored:
  2212. ORA-00376: file 1 cannot be read at this time
  2213. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2214. *** 2008-06-23 09:03:59.470
  2215. SMON: following errors trapped and ignored:
  2216. ORA-00376: file 1 cannot be read at this time
  2217. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2218. *** 2008-06-23 09:04:09.472
  2219. Serial Transaction recovery caught exception 376
  2220. *** 2008-06-23 09:04:09.472
  2221. SMON: following errors trapped and ignored:
  2222. ORA-00376: file 1 cannot be read at this time
  2223. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2224. *** 2008-06-23 09:04:19.475
  2225. SMON: following errors trapped and ignored:
  2226. ORA-00376: file 1 cannot be read at this time
  2227. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2228. *** 2008-06-23 09:04:29.479
  2229. SMON: following errors trapped and ignored:
  2230. ORA-00376: file 1 cannot be read at this time
  2231. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2232. *** 2008-06-23 09:04:39.481
  2233. SMON: following errors trapped and ignored:
  2234. ORA-00376: file 1 cannot be read at this time
  2235. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2236. *** 2008-06-23 09:04:49.484
  2237. SMON: following errors trapped and ignored:
  2238. ORA-00376: file 1 cannot be read at this time
  2239. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2240. *** 2008-06-23 09:04:59.488
  2241. SMON: following errors trapped and ignored:
  2242. ORA-00376: file 1 cannot be read at this time
  2243. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2244. *** 2008-06-23 09:05:09.491
  2245. SMON: following errors trapped and ignored:
  2246. ORA-00376: file 1 cannot be read at this time
  2247. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2248. *** 2008-06-23 09:05:19.494
  2249. SMON: following errors trapped and ignored:
  2250. ORA-00376: file 1 cannot be read at this time
  2251. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2252. *** 2008-06-23 09:05:29.498
  2253. SMON: following errors trapped and ignored:
  2254. ORA-00376: file 1 cannot be read at this time
  2255. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2256. *** 2008-06-23 09:05:39.501
  2257. SMON: following errors trapped and ignored:
  2258. ORA-00376: file 1 cannot be read at this time
  2259. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2260. *** 2008-06-23 09:05:49.505
  2261. SMON: following errors trapped and ignored:
  2262. ORA-00376: file 1 cannot be read at this time
  2263. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2264. *** 2008-06-23 09:05:59.508
  2265. SMON: following errors trapped and ignored:
  2266. ORA-00376: file 1 cannot be read at this time
  2267. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2268. *** 2008-06-23 09:06:09.511
  2269. SMON: following errors trapped and ignored:
  2270. ORA-00376: file 1 cannot be read at this time
  2271. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2272. *** 2008-06-23 09:06:19.515
  2273. SMON: following errors trapped and ignored:
  2274. ORA-00376: file 1 cannot be read at this time
  2275. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2276. *** 2008-06-23 09:06:29.517
  2277. SMON: following errors trapped and ignored:
  2278. ORA-00376: file 1 cannot be read at this time
  2279. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2280. *** 2008-06-23 09:06:39.520
  2281. SMON: following errors trapped and ignored:
  2282. ORA-00376: file 1 cannot be read at this time
  2283. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2284. *** 2008-06-23 09:06:49.522
  2285. Serial Transaction recovery caught exception 376
  2286. *** 2008-06-23 09:06:49.522
  2287. SMON: following errors trapped and ignored:
  2288. ORA-00376: file 1 cannot be read at this time
  2289. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2290. *** 2008-06-23 09:06:59.525
  2291. SMON: following errors trapped and ignored:
  2292. ORA-00376: file 1 cannot be read at this time
  2293. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2294. *** 2008-06-23 09:07:09.529
  2295. SMON: following errors trapped and ignored:
  2296. ORA-00376: file 1 cannot be read at this time
  2297. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2298. *** 2008-06-23 09:07:19.531
  2299. SMON: following errors trapped and ignored:
  2300. ORA-00376: file 1 cannot be read at this time
  2301. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2302. *** 2008-06-23 09:07:29.534
  2303. SMON: following errors trapped and ignored:
  2304. ORA-00376: file 1 cannot be read at this time
  2305. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2306. *** 2008-06-23 09:07:39.537
  2307. SMON: following errors trapped and ignored:
  2308. ORA-00376: file 1 cannot be read at this time
  2309. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2310. *** 2008-06-23 09:07:49.541
  2311. SMON: following errors trapped and ignored:
  2312. ORA-00376: file 1 cannot be read at this time
  2313. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2314. *** 2008-06-23 09:07:59.543
  2315. SMON: following errors trapped and ignored:
  2316. ORA-00376: file 1 cannot be read at this time
  2317. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
  2318. *** 2008-06-23 09:08:09.547
  2319. SMON: following errors trapped and ignored:
  2320. ORA-00376: file 1 cannot be read at this time
  2321. ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement