Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dump file /u01/app/oracle/product/10.2.0/db_1/rdbms/log/babydb_smon_6594.trc
- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
- With the Partitioning, OLAP and Data Mining options
- ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
- System name: Linux
- Node name: xentiger
- Release: 2.6.26-rc5
- Version: #15 SMP Tue Jun 17 11:21:26 SGT 2008
- Machine: i686
- Instance name: babydb
- Redo thread mounted by this instance: 1
- Oracle process number: 8
- Unix process pid: 6594, image: oracle@xentiger (SMON)
- *** 2008-06-23 09:01:35.266
- *** SERVICE NAME:() 2008-06-23 09:01:35.265
- *** SESSION ID:(32.1) 2008-06-23 09:01:35.265
- Serial Transaction recovery caught exception 376
- *** 2008-06-23 09:01:35.266
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- ktsmgtur(): TUR was not tuned for 313 secs
- *** 2008-06-23 09:01:36.298
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:01:37.301
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:01:38.304
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:01:39.306
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- ===================================================
- PROCESS STATE
- -------------
- Process global information:
- process: 0x2550ada8, call: 0x2554b13c, xact: (nil), curses: 0x2553e1dc, usrses: 0x2553e1dc
- ----------------------------------------
- SO: 0x2550ada8, type: 2, owner: (nil), flag: INIT/-/-/0x00
- (process) Oracle pid=8, calls cur/top: 0x2554b13c/0x2554b13c, flag: (16) SYSTEM
- int error: 0, call error: 0, sess error: 0, txn error 0
- (post info) last post received: 0 0 144
- last post received-location: ktmchg
- last process to post me: 2550c478 4 0
- last post sent: 581 0 4
- last post sent-location: kslpsr
- last process posted by me: 2550c478 4 0
- (latch info) wait_event=0 bits=0
- Process Group: DEFAULT, pseudo proc: 0x25513ce4
- O/S info: user: oracle, term: UNKNOWN, ospid: 6594
- OSD pid info: Unix process pid: 6594, image: oracle@xentiger (SMON)
- Dump of memory from 0x25505EB0 to 0x25506034
- 25505EB0 0000000E 252CD1E8 00000010 0003139D [......,%........]
- 25505EC0 2554B13C 00000003 0003139D 2560539C [<.T%.........S`%]
- 25505ED0 0000000B 0003139D 2553E1DC 00000004 [..........S%....]
- 25505EE0 00031291 25605438 0000000B 0003139D [....8T`%........]
- 25505EF0 256054D4 0000000B 0003139D 25605D6C [.T`%........l]`%]
- 25505F00 0000000B 0003139D 25708D40 00000007 [[email protected]%....]
- 25505F10 0003139D 25708DC4 00000007 0003139D [......p%........]
- 25505F20 25708E48 00000007 0003139D 25708ECC [H.p%..........p%]
- 25505F30 00000007 0003139D 25708F50 00000007 [........P.p%....]
- 25505F40 0003139D 25708FD4 00000007 0003139D [......p%........]
- 25505F50 234546CC 0000000B 0003139D 00000000 [.FE#............]
- 25505F60 00000000 00000000 00000000 00000000 [................]
- Repeat 12 times
- 25506030 00000000 [....]
- ----------------------------------------
- SO: 0x234546cc, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
- event: 1, last message event: 1,
- last message waited event: 1, messages read: 0
- channel: (0x25606520) Get Segment Information Channel
- scope: 0, event: 1, last mesage event: 0,
- publishers/subscribers: 0/1,
- messages published: 0
- (FOB) flags=2 fib=0x25713adc incno=0 pending i/o cnt=0
- fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_temp_45xrzk9w_.tmp
- fno=41 lblksz=4 fsiz=201667104
- (FOB) flags=2 fib=0x2571379c incno=0 pending i/o cnt=0
- fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_art_ts_45xwwb53_.dbf
- fno=5 lblksz=4 fsiz=201667104
- (FOB) flags=2 fib=0x2571345c incno=0 pending i/o cnt=0
- fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_users_45xrzkd7_.dbf
- fno=4 lblksz=4 fsiz=201667104
- (FOB) flags=2 fib=0x2571311c incno=0 pending i/o cnt=0
- fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_sysaux_45xrzfkp_.dbf
- fno=3 lblksz=4 fsiz=201667104
- (FOB) flags=2 fib=0x25712dcc incno=0 pending i/o cnt=0
- fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_undotbs1_45xrzdob_.dbf
- fno=2 lblksz=4 fsiz=201667104
- (FOB) flags=2 fib=0x25712a8c incno=0 pending i/o cnt=0
- fname=/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf
- fno=1 lblksz=4 fsiz=201667104
- ----------------------------------------
- SO: 0x25605d6c, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
- event: 1, last message event: 3,
- last message waited event: 3, messages read: 1
- channel: (0x25606360) obj stat del channel
- scope: 4, event: 3, last mesage event: 3,
- publishers/subscribers: 0/1,
- messages published: 1
- ----------------------------------------
- SO: 0x256054d4, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
- event: 1, last message event: 1,
- last message waited event: 1, messages read: 0
- channel: (0x25608f20) KTF time scn map
- scope: 7, event: 1, last mesage event: 0,
- publishers/subscribers: 0/1,
- messages published: 0
- ----------------------------------------
- SO: 0x25605438, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
- event: 7, last message event: 12,
- last message waited event: 12, messages read: 1
- channel: (0x25608ac0) scumnt mount lock
- scope: 1, event: 15, last mesage event: 12,
- publishers/subscribers: 0/8,
- messages published: 1
- ----------------------------------------
- SO: 0x2553e1dc, type: 4, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (session) sid: 32 trans: (nil), creator: 0x2550ada8, flag: (100051) USR/- BSY/-/-/-/-/-
- DID: 0001-0008-00000003, short-term DID: 0000-0000-00000000
- txn branch: (nil)
- oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS
- last wait for 'smon timer' blocking sess=0x(nil) seq=330 wait_time=976754 seconds since wait started=0
- sleep time=1, failed=4, =0
- Dumping Session Wait History
- for 'smon timer' count=1 wait_time=976754
- sleep time=1, failed=4, =0
- for 'smon timer' count=1 wait_time=977004
- sleep time=1, failed=3, =0
- for 'smon timer' count=1 wait_time=976907
- sleep time=1, failed=2, =0
- for 'smon timer' count=1 wait_time=976955
- sleep time=1, failed=1, =0
- for 'smon timer' count=1 wait_time=293013277
- sleep time=12c, failed=0, =0
- for 'smon timer' count=1 wait_time=5
- sleep time=12c, failed=0, =0
- for 'smon timer' count=1 wait_time=4451554
- sleep time=12c, failed=0, =0
- for 'smon timer' count=1 wait_time=9655
- sleep time=12c, failed=0, =0
- for 'smon timer' count=1 wait_time=18045
- sleep time=12c, failed=0, =0
- for 'smon timer' count=1 wait_time=138147
- sleep time=12c, failed=0, =0
- temporary object counter: 0
- ----------------------------------------
- UOL used : 0
- KGX Atomic Operation Log 0x23fee38c
- Mutex (nil)(0, 0) idn 0 oper NONE
- Cursor Parent uid 32 efd 10 whr 13 slp 0
- oper=NONE pt1=0x22eebcb0 pt2=0x22eebcec pt3=(nil)
- pt4=(nil) u41=0 stt=0
- KGX Atomic Operation Log 0x23fee3b4
- Mutex 0x2370a544(0, 0) idn 0 oper NONE
- Cursor Stat uid 32 efd 14 whr 1 slp 0
- oper=NONE pt1=0x2370a490 pt2=(nil) pt3=(nil)
- pt4=(nil) u41=0 stt=8
- KGX Atomic Operation Log 0x23fee3dc
- Mutex (nil)(0, 0) idn 0 oper NONE
- Cursor Stat uid 32 efd 0 whr 0 slp 0
- oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
- pt4=(nil) u41=0 stt=0
- ----------------------------------------
- SO: 0x23469d34, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469d34 handle=237743dc mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469d80[0x23fea284,0x23fea284] htb=0x23fea284 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
- LIBRARY OBJECT HANDLE: handle=237743dc mutex=0x23774490(0)
- name=SYS.USER$
- hash=6d8063e933741c7b437132a225321413 timestamp=06-23-2008 07:44:36
- namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
- kkkk-dddd-llll=0101-0101-0309 lock=N pin=0 latch#=3 hpc=0026 hlc=0026
- lwt=0x23774438[0x23774438,0x23774438] ltm=0x23774440[0x23774440,0x23774440]
- pwt=0x2377441c[0x2377441c,0x2377441c] ptm=0x23774424[0x23774424,0x23774424]
- ref=0x23774458[0x23774458,0x23774458] lnd=0x23774464[0x23771e08,0x237787c0]
- LIBRARY OBJECT: object=2377171c
- type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23778100 237717d8 I/P/A/-/- 0 NONE 00
- 8 2377193c 237711a0 I/P/A/-/- 0 NONE 00
- 9 23771a18 0 I/-/-/-/- 0 NONE 0c
- ----------------------------------------
- SO: 0x23469e6c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469e6c handle=237a82d8 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469eb8[0x23fea6c4,0x23fea6c4] htb=0x23fea6c4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
- LIBRARY OBJECT HANDLE: handle=237a82d8 mutex=0x237a838c(0)
- name=SYS.C_USER#
- hash=dc7b39edaba41b1e78a8b32400c7659b timestamp=06-23-2008 07:44:36
- namespace=CLST flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
- kkkk-dddd-llll=0101-0101-0101 lock=N pin=0 latch#=1 hpc=0028 hlc=0028
- lwt=0x237a8334[0x237a8334,0x237a8334] ltm=0x237a833c[0x237a833c,0x237a833c]
- pwt=0x237a8318[0x237a8318,0x237a8318] ptm=0x237a8320[0x237a8320,0x237a8320]
- ref=0x237a8354[0x237a8354,0x237a8354] lnd=0x237a8360[0x23789788,0x237c1210]
- LIBRARY OBJECT: object=237a7e60
- type=CLST flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 237a8268 237a7f1c I/P/A/-/- 0 NONE 00
- 8 237a8080 237a798c I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464ddc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464ddc handle=23739f58 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23464e28[0x23fea234,0x23fea234] htb=0x23fea234 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
- LIBRARY OBJECT HANDLE: handle=23739f58 mutex=0x2373a00c(0)
- name=SYS.TYPE$
- hash=848fe7317866b0836cf6e9e8b1243909 timestamp=06-23-2008 07:44:39
- namespace=TABL flags=KGHP/TIM/SML/[02000000]
- kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=3 hpc=0004 hlc=0004
- lwt=0x23739fb4[0x23739fb4,0x23739fb4] ltm=0x23739fbc[0x23739fbc,0x23739fbc]
- pwt=0x23739f98[0x23739f98,0x23739f98] ptm=0x23739fa0[0x23739fa0,0x23739fa0]
- ref=0x23739fd4[0x23739fd4,0x23739fd4] lnd=0x23739fe0[0x2375d928,0x22fbde40]
- LIBRARY OBJECT: object=23111e10
- type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 22f6417c 23111ea8 I/-/A/-/- 0 NONE 00
- 8 23112030 23232a70 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23469e04, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469e04 handle=2368a16c mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469e50[0x23fea82c,0x23fea82c] htb=0x23fea82c ssga=0x23fea138
- user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
- LIBRARY OBJECT HANDLE: handle=2368a16c mutex=0x2368a220(0)
- name=SYS.C_TOID_VERSION#
- hash=691fc8421edb665863186250e09462c8 timestamp=06-23-2008 07:44:39
- namespace=CLST flags=KGHP/TIM/SML/[02000000]
- kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=2 hpc=0004 hlc=0004
- lwt=0x2368a1c8[0x2368a1c8,0x2368a1c8] ltm=0x2368a1d0[0x2368a1d0,0x2368a1d0]
- pwt=0x2368a1ac[0x2368a1ac,0x2368a1ac] ptm=0x2368a1b4[0x2368a1b4,0x2368a1b4]
- ref=0x2368a1e8[0x2368a1e8,0x2368a1e8] lnd=0x2368a1f4[0x2368a1f4,0x2368a1f4]
- LIBRARY OBJECT: object=237bc558
- type=CLST flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23732af4 237bc614 I/-/A/-/- 0 NONE 00
- 8 237bc778 23133204 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346545c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346545c handle=2378aa84 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x234654a8[0x23fea45c,0x23fea45c] htb=0x23fea45c ssga=0x23fea138
- user=2553e1dc session=25534c3c count=0 flags=LRU/[4000] savepoint=0x2574
- LIBRARY OBJECT HANDLE: handle=2378aa84 mutex=0x2378ab38(0)
- name=SYS.OBJ$
- hash=6bd508fcca69602620c1816e61c9fe4e timestamp=06-23-2008 07:44:36
- namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
- kkkk-dddd-llll=0101-0501-0709 lock=N pin=0 latch#=3 hpc=0024 hlc=0024
- lwt=0x2378aae0[0x2378aae0,0x2378aae0] ltm=0x2378aae8[0x2378aae8,0x2378aae8]
- pwt=0x2378aac4[0x2378aac4,0x2378aac4] ptm=0x2378aacc[0x2378aacc,0x2378aacc]
- ref=0x2378ab00[0x2378ab00,0x2378ab00] lnd=0x2378ab0c[0x237787c0,0x23783eec]
- LIBRARY OBJECT: object=2377afc0
- type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23784020 2377b07c I/P/A/-/- 0 NONE 00
- 8 2377b1e0 2377ac60 I/P/A/-/- 0 NONE 00
- 9 2377b344 0 I/-/-/-/- 0 NONE 0c
- 10 237d3f78 2372bb14 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346482c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346482c handle=23558d44 mode=N
- call pin=(nil) session pin=0x234660e4 hpc=0000 hlc=0000
- htl=0x23464878[0x23469b10,0x23fea3a4] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
- namespace=CRSR flags=RON/KGHP/PN0/[10010000]
- kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
- lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
- pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
- ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
- LIBRARY OBJECT: object=22ef63c0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- DEPENDENCIES: count=1 size=16
- READ ONLY DEPENDENCIES: count=1 size=16
- AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
- ACCESSES: count=1 size=16
- TRANSLATIONS: count=1 size=16
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
- 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23469ac4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469ac4 handle=230f80e0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469b10[0x23464c20,0x23464878] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2576
- LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
- 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
- hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
- lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
- pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
- ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
- LIBRARY OBJECT: object=230f7c68
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23111d9c 23111a50 230f7b6c
- 1 23111d9c 23111bcc 23558d44
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464bd4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464bd4 handle=23558d44 mode=N
- call pin=(nil) session pin=0x23465e98 hpc=0000 hlc=0000
- htl=0x23464c20[0x234649b0,0x23469b10] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
- namespace=CRSR flags=RON/KGHP/PN0/[10010000]
- kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
- lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
- pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
- ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
- LIBRARY OBJECT: object=22ef63c0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- DEPENDENCIES: count=1 size=16
- READ ONLY DEPENDENCIES: count=1 size=16
- AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
- ACCESSES: count=1 size=16
- TRANSLATIONS: count=1 size=16
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
- 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464964, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464964 handle=230f80e0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x234649b0[0x23469be0,0x23464c20] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2557
- LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
- 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
- hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
- lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
- pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
- ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
- LIBRARY OBJECT: object=230f7c68
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23111d9c 23111a50 230f7b6c
- 1 23111d9c 23111bcc 23558d44
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23469b94, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469b94 handle=23558d44 mode=N
- call pin=(nil) session pin=0x234665d0 hpc=0000 hlc=0000
- htl=0x23469be0[0x23464b50,0x234649b0] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
- namespace=CRSR flags=RON/KGHP/PN0/[10010000]
- kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
- lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
- pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
- ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
- LIBRARY OBJECT: object=22ef63c0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- DEPENDENCIES: count=1 size=16
- READ ONLY DEPENDENCIES: count=1 size=16
- AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
- ACCESSES: count=1 size=16
- TRANSLATIONS: count=1 size=16
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
- 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464b04, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464b04 handle=230f80e0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23464b50[0x23464ae8,0x23469be0] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2538
- LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
- 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
- hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
- lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
- pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
- ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
- LIBRARY OBJECT: object=230f7c68
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23111d9c 23111a50 230f7b6c
- 1 23111d9c 23111bcc 23558d44
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464a9c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464a9c handle=23558d44 mode=N
- call pin=(nil) session pin=0x234662dc hpc=0000 hlc=0000
- htl=0x23464ae8[0x2346a260,0x23464b50] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23558d44 mutex=0x23558df8(0)
- namespace=CRSR flags=RON/KGHP/PN0/[10010000]
- kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0012 hlc=0012
- lwt=0x23558da0[0x23558da0,0x23558da0] ltm=0x23558da8[0x23558da8,0x23558da8]
- pwt=0x23558d84[0x23558d84,0x23558d84] ptm=0x23558d8c[0x23558d8c,0x23558d8c]
- ref=0x23558dc0[0x23111bcc,0x23111bcc] lnd=0x23558dcc[0x23558dcc,0x23558dcc]
- LIBRARY OBJECT: object=22ef63c0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- DEPENDENCIES: count=1 size=16
- READ ONLY DEPENDENCIES: count=1 size=16
- AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
- ACCESSES: count=1 size=16
- TRANSLATIONS: count=1 size=16
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23559248 22ef6510 I/P/A/-/- 0 NONE 00
- 6 2328382c 23521f04 I/-/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a214, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a214 handle=230f80e0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a260[0x23fea3a4,0x23464ae8] htb=0x23fea3a4 ssga=0x23fea138
- user=2553e1dc session=25534c3c count=1 flags=[0000] savepoint=0x2518
- LIBRARY OBJECT HANDLE: handle=230f80e0 mutex=0x230f8194(2)
- 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
- hash=6d11d7de2049577d933d2385337fc737 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
- lwt=0x230f813c[0x230f813c,0x230f813c] ltm=0x230f8144[0x230f8144,0x230f8144]
- pwt=0x230f8120[0x230f8120,0x230f8120] ptm=0x230f8128[0x230f8128,0x230f8128]
- ref=0x230f815c[0x230f815c,0x230f815c] lnd=0x230f8168[0x22fbf8d0,0x231b7e8c]
- LIBRARY OBJECT: object=230f7c68
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23111d9c 23111a50 230f7b6c
- 1 23111d9c 23111bcc 23558d44
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 230f8070 230f7d00 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a34c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a34c handle=237c0ff0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a398[0x23fea5ec,0x23fea5ec] htb=0x23fea5ec ssga=0x23fea138
- user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24e5
- LIBRARY OBJECT HANDLE: handle=237c0ff0 mutex=0x237c10a4(0)
- name=SYS.TAB$
- hash=a78f9a16ae7d958fa97507587dbfe080 timestamp=06-23-2008 07:44:36
- namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
- kkkk-dddd-llll=0101-0101-0309 lock=N pin=0 latch#=1 hpc=0018 hlc=0018
- lwt=0x237c104c[0x237c104c,0x237c104c] ltm=0x237c1054[0x237c1054,0x237c1054]
- pwt=0x237c1030[0x237c1030,0x237c1030] ptm=0x237c1038[0x237c1038,0x237c1038]
- ref=0x237c106c[0x237c106c,0x237c106c] lnd=0x237c1078[0x237c1368,0x237e1e1c]
- LIBRARY OBJECT: object=237c0bd8
- type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 237f3e84 237c0c94 I/P/A/-/- 0 NONE 00
- 8 237c0df8 237c065c I/P/A/-/- 0 NONE 00
- 9 237c0ed4 0 I/-/-/-/- 0 NONE 0c
- ----------------------------------------
- SO: 0x234652bc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=234652bc handle=237e1d94 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23465308[0x23fea94c,0x23fea94c] htb=0x23fea94c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24e5
- LIBRARY OBJECT HANDLE: handle=237e1d94 mutex=0x237e1e48(0)
- name=SYS.C_OBJ#
- hash=67af8b0042f9ddc88acd448fb1d132ec timestamp=06-23-2008 07:44:36
- namespace=CLST flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
- kkkk-dddd-llll=0101-0101-0101 lock=N pin=0 latch#=1 hpc=0030 hlc=0030
- lwt=0x237e1df0[0x237e1df0,0x237e1df0] ltm=0x237e1df8[0x237e1df8,0x237e1df8]
- pwt=0x237e1dd4[0x237e1dd4,0x237e1dd4] ptm=0x237e1ddc[0x237e1ddc,0x237e1ddc]
- ref=0x237e1e10[0x237e1e10,0x237e1e10] lnd=0x237e1e1c[0x237c1078,0x245c2268]
- LIBRARY OBJECT: object=237e5e58
- type=CLST flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 237f9b3c 237e5f14 I/P/A/-/- 0 NONE 00
- 8 237e6078 237e5984 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23469bfc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469bfc handle=237d6dc0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469c48[0x23fea2a4,0x23fea2a4] htb=0x23fea2a4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24d7
- LIBRARY OBJECT HANDLE: handle=237d6dc0 mutex=0x237d6e74(0)
- name=SYS.IND_ONLINE$
- hash=968162a4702a7cb77e2756f5dc261517 timestamp=06-23-2008 07:44:54
- namespace=TABL flags=KGHP/TIM/SML/[02000000]
- kkkk-dddd-llll=0000-0000-0000 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
- lwt=0x237d6e1c[0x237d6e1c,0x237d6e1c] ltm=0x237d6e24[0x237d6e24,0x237d6e24]
- pwt=0x237d6e00[0x237d6e00,0x237d6e00] ptm=0x237d6e08[0x237d6e08,0x237d6e08]
- ref=0x237d6e3c[0x237d6e3c,0x237d6e3c] lnd=0x237d6e48[0x236dacec,0x23548e88]
- LIBRARY OBJECT last freed from HPD addn data CBK
- ----------------------------------------
- SO: 0x23469fa4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469fa4 handle=2377b540 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469ff0[0x23fea304,0x23fea304] htb=0x23fea304 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x24d7
- LIBRARY OBJECT HANDLE: handle=2377b540 mutex=0x2377b5f4(0)
- name=SYS.IND$
- hash=a1467e86983aba8ff919785be9444723 timestamp=06-23-2008 07:44:36
- namespace=TABL flags=PKP/KGHP/TIM/KEP/SML/BSO/[02900002]
- kkkk-dddd-llll=0101-0101-0309 lock=N pin=0 latch#=2 hpc=001a hlc=001a
- lwt=0x2377b59c[0x2377b59c,0x2377b59c] ltm=0x2377b5a4[0x2377b5a4,0x2377b5a4]
- pwt=0x2377b580[0x2377b580,0x2377b580] ptm=0x2377b588[0x2377b588,0x2377b588]
- ref=0x2377b5bc[0x2377b5bc,0x2377b5bc] lnd=0x2377b5c8[0x2377839c,0x2378189c]
- LIBRARY OBJECT: object=23777cb0
- type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2377b4d0 23777d6c I/P/A/-/- 0 NONE 00
- 8 23777ed0 23777734 I/P/A/-/- 0 NONE 00
- 9 23777fac 0 I/-/-/-/- 0 NONE 0c
- ----------------------------------------
- SO: 0x23469924, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469924 handle=235135a8 mode=N
- call pin=(nil) session pin=0x2346657c hpc=0000 hlc=0000
- htl=0x23469970[0x234653d8,0x23fea5f4] htb=0x23fea5f4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=235135a8 mutex=0x2351365c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0010 hlc=0010
- lwt=0x23513604[0x23513604,0x23513604] ltm=0x2351360c[0x23469940,0x23474fd0]
- pwt=0x235135e8[0x235135e8,0x235135e8] ptm=0x235135f0[0x235135f0,0x235135f0]
- ref=0x23513624[0x23587694,0x23587694] lnd=0x23513630[0x23513630,0x23513630]
- LIBRARY OBJECT: object=2377e0f0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236258bc 2377e240 I/P/A/-/- 0 NONE 00
- 6 23593dd4 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346538c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346538c handle=2356ad58 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x234653d8[0x234699d8,0x23469970] htb=0x23fea5f4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x24ac
- LIBRARY OBJECT HANDLE: handle=2356ad58 mutex=0x2356ae0c(2)
- name=
- 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#
- hash=16030b5c728b234081e54a3c95c2a581 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0022 hlc=0022
- lwt=0x2356adb4[0x2356adb4,0x2356adb4] ltm=0x2356adbc[0x2356adbc,0x2356adbc]
- pwt=0x2356ad98[0x2356ad98,0x2356ad98] ptm=0x2356ada0[0x2356ada0,0x2356ada0]
- ref=0x2356add4[0x2356add4,0x2356add4] lnd=0x2356ade0[0x23586a48,0x2357d910]
- LIBRARY OBJECT: object=2356a8e0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23587870 23587524 2356a7d8
- 1 23587870 23587694 235135a8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2356ace8 2356a978 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x234655fc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=234655fc handle=235595c8 mode=N
- call pin=(nil) session pin=0x23466234 hpc=0000 hlc=0000
- htl=0x23465648[0x2346a1f8,0x23fea79c] htb=0x23fea79c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=235595c8 mutex=0x2355967c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0010 hlc=0010
- lwt=0x23559624[0x23559624,0x23559624] ltm=0x2355962c[0x23465618,0x23474f00]
- pwt=0x23559608[0x23559608,0x23559608] ptm=0x23559610[0x23559610,0x23559610]
- ref=0x23559644[0x2352da94,0x2352da94] lnd=0x23559650[0x23559650,0x23559650]
- LIBRARY OBJECT: object=2355f7a8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236fdc90 2355f8f8 I/P/A/-/- 0 NONE 00
- 6 2355ef38 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346a1ac, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a1ac handle=235244f4 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a1f8[0x23464d58,0x23465648] htb=0x23fea79c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x247e
- LIBRARY OBJECT HANDLE: handle=235244f4 mutex=0x235245a8(2)
- name=
- 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$
- hash=1d4a51a2c89ab6b07a3c64bebc5573b6 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0024 hlc=0024
- lwt=0x23524550[0x23524550,0x23524550] ltm=0x23524558[0x23524558,0x23524558]
- pwt=0x23524534[0x23524534,0x23524534] ptm=0x2352453c[0x2352453c,0x2352453c]
- ref=0x23524570[0x23524570,0x23524570] lnd=0x2352457c[0x235226d0,0x2359d488]
- LIBRARY OBJECT: object=2352dce0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 2352dc6c 2352d920 2352d7b4
- 1 2352dc6c 2352da94 235595c8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23531564 2352dd78 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23469f3c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469f3c handle=23523564 mode=N
- call pin=(nil) session pin=0x23465d9c hpc=0000 hlc=0000
- htl=0x23469f88[0x2346a608,0x23fea5bc] htb=0x23fea5bc ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23523564 mutex=0x23523618(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0010 hlc=0010
- lwt=0x235235c0[0x235235c0,0x235235c0] ltm=0x235235c8[0x23469f58,0x23474e30]
- pwt=0x235235a4[0x235235a4,0x235235a4] ptm=0x235235ac[0x235235ac,0x235235ac]
- ref=0x235235e0[0x2354d850,0x2354d850] lnd=0x235235ec[0x235235ec,0x235235ec]
- LIBRARY OBJECT: object=2359a940
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23744e00 2359aa90 I/P/A/-/- 0 NONE 00
- 6 2359a0d0 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346a5bc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a5bc handle=2354deb8 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a608[0x23469b78,0x23469f88] htb=0x23fea5bc ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2451
- LIBRARY OBJECT HANDLE: handle=2354deb8 mutex=0x2354df6c(2)
- name=
- 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# (+)
- hash=436a415b2251827617e919499a05b67a timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0024 hlc=0024
- lwt=0x2354df14[0x2354df14,0x2354df14] ltm=0x2354df1c[0x2354df1c,0x2354df1c]
- pwt=0x2354def8[0x2354def8,0x2354def8] ptm=0x2354df00[0x2354df00,0x2354df00]
- ref=0x2354df34[0x2354df34,0x2354df34] lnd=0x2354df40[0x2353a760,0x2358adcc]
- LIBRARY OBJECT: object=2354daa0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 2354da2c 2354d6e0 23531690
- 1 2354da2c 2354d850 23523564
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23543b78 2354db38 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464f7c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464f7c handle=2359ea9c mode=N
- call pin=(nil) session pin=0x23465d48 hpc=0000 hlc=0000
- htl=0x23464fc8[0x2346a128,0x23fea66c] htb=0x23fea66c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=2359ea9c mutex=0x2359eb50(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=000e hlc=000e
- lwt=0x2359eaf8[0x2359eaf8,0x2359eaf8] ltm=0x2359eb00[0x23464f98,0x234752a8]
- pwt=0x2359eadc[0x2359eadc,0x2359eadc] ptm=0x2359eae4[0x2359eae4,0x2359eae4]
- ref=0x2359eb18[0x235aa134,0x235aa134] lnd=0x2359eb24[0x2359eb24,0x2359eb24]
- LIBRARY OBJECT: object=235a7b20
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 237742ac 235a7c70 I/P/A/-/- 0 NONE 00
- 6 235ae764 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346a0dc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a0dc handle=2358ad44 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a128[0x234655e0,0x23464fc8] htb=0x23fea66c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x243b
- LIBRARY OBJECT HANDLE: handle=2358ad44 mutex=0x2358adf8(2)
- 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
- hash=b26a259f381e87d302773791f5e84a90 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
- lwt=0x2358ada0[0x2358ada0,0x2358ada0] ltm=0x2358ada8[0x2358ada8,0x2358ada8]
- pwt=0x2358ad84[0x2358ad84,0x2358ad84] ptm=0x2358ad8c[0x2358ad8c,0x2358ad8c]
- ref=0x2358adc0[0x2358adc0,0x2358adc0] lnd=0x2358adcc[0x2354df40,0x23725b5c]
- LIBRARY OBJECT: object=2358a92c
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 235aa2f4 235a9fa8 235a9e3c
- 1 235aa2f4 235aa134 2359ea9c
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23590794 2358a9c4 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23465254, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23465254 handle=23548e00 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x234652a0[0x23fea44c,0x23fea44c] htb=0x23fea44c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=0 flags=LRU/[4000] savepoint=0x23de
- LIBRARY OBJECT HANDLE: handle=23548e00 mutex=0x23548eb4(0)
- name=SYS.SMON_SCN_TIME
- hash=9025a1f4376d6af6d9b3dfcfb050d64c timestamp=06-23-2008 07:44:52
- namespace=TABL flags=KGHP/TIM/SML/[02000000]
- kkkk-dddd-llll=0000-0000-0000 lock=N pin=0 latch#=1 hpc=0002 hlc=0002
- lwt=0x23548e5c[0x23548e5c,0x23548e5c] ltm=0x23548e64[0x23548e64,0x23548e64]
- pwt=0x23548e40[0x23548e40,0x23548e40] ptm=0x23548e48[0x23548e48,0x23548e48]
- ref=0x23548e7c[0x23548e7c,0x23548e7c] lnd=0x23548e88[0x237d6e48,0x235b02e8]
- LIBRARY OBJECT last freed from HPD addn data CBK
- ----------------------------------------
- SO: 0x23464eac, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464eac handle=23517b58 mode=N
- call pin=(nil) session pin=0x23465fe8 hpc=0000 hlc=0000
- htl=0x23464ef8[0x2346a5a0,0x23fea62c] htb=0x23fea62c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23517b58 mutex=0x23517c0c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0012 hlc=0012
- lwt=0x23517bb4[0x23517bb4,0x23517bb4] ltm=0x23517bbc[0x23464ec8,0x23464ec8]
- pwt=0x23517b98[0x23517b98,0x23517b98] ptm=0x23517ba0[0x23517ba0,0x23517ba0]
- ref=0x23517bd4[0x23503c00,0x23503c00] lnd=0x23517be0[0x23517be0,0x23517be0]
- LIBRARY OBJECT: object=23520cac
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236cc484 23520dfc I/P/A/-/- 0 NONE 00
- 6 23509f9c 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346a554, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a554 handle=235042c8 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a5a0[0x23fea62c,0x23464ef8] htb=0x23fea62c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x241f
- LIBRARY OBJECT HANDLE: handle=235042c8 mutex=0x2350437c(2)
- 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#
- hash=26947ac91d45c1242b247fc5f6b6f088 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0026 hlc=0026
- lwt=0x23504324[0x23504324,0x23504324] ltm=0x2350432c[0x2350432c,0x2350432c]
- pwt=0x23504308[0x23504308,0x23504308] ptm=0x23504310[0x23504310,0x23504310]
- ref=0x23504344[0x23504344,0x23504344] lnd=0x23504350[0x23546dc8,0x2355590c]
- LIBRARY OBJECT: object=23503e50
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23503ddc 23503a90 23503924
- 1 23503ddc 23503c00 23517b58
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23504258 23503ee8 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a144, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a144 handle=234fd368 mode=N
- call pin=(nil) session pin=0x23466330 hpc=0000 hlc=0000
- htl=0x2346a190[0x23464dc0,0x23fea624] htb=0x23fea624 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=234fd368 mutex=0x234fd41c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0012 hlc=0012
- lwt=0x234fd3c4[0x234fd3c4,0x234fd3c4] ltm=0x234fd3cc[0x2346a160,0x2346a160]
- pwt=0x234fd3a8[0x234fd3a8,0x234fd3a8] ptm=0x234fd3b0[0x234fd3b0,0x234fd3b0]
- ref=0x234fd3e4[0x235064fc,0x235064fc] lnd=0x234fd3f0[0x234fd3f0,0x234fd3f0]
- LIBRARY OBJECT: object=23549e08
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236ed48c 23549f58 I/P/A/-/- 0 NONE 00
- 6 235220cc 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x23464d74, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464d74 handle=234fe3b4 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23464dc0[0x23fea624,0x2346a190] htb=0x23fea624 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2412
- LIBRARY OBJECT HANDLE: handle=234fe3b4 mutex=0x234fe468(2)
- 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#
- hash=d751142c3b7971bd655864a445f58a87 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0026 hlc=0026
- lwt=0x234fe410[0x234fe410,0x234fe410] ltm=0x234fe418[0x234fe418,0x234fe418]
- pwt=0x234fe3f4[0x234fe3f4,0x234fe3f4] ptm=0x234fe3fc[0x234fe3fc,0x234fe3fc]
- ref=0x234fe430[0x234fe430,0x234fe430] lnd=0x234fe43c[0x2355590c,0x235226d0]
- LIBRARY OBJECT: object=2350674c
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 235066d8 2350638c 23512484
- 1 235066d8 235064fc 234fd368
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 234fe33c 235067e4 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a41c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a41c handle=23599fe4 mode=N
- call pin=(nil) session pin=0x234661e0 hpc=0000 hlc=0000
- htl=0x2346a468[0x23469d18,0x23fea74c] htb=0x23fea74c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23599fe4 mutex=0x2359a098(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0014 hlc=0014
- lwt=0x2359a040[0x2359a040,0x2359a040] ltm=0x2359a048[0x2346a438,0x2346a438]
- pwt=0x2359a024[0x2359a024,0x2359a024] ptm=0x2359a02c[0x2359a02c,0x2359a02c]
- ref=0x2359a060[0x23557a80,0x23557a80] lnd=0x2359a06c[0x2359a06c,0x2359a06c]
- LIBRARY OBJECT: object=237e3230
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2366809c 237e3380 I/P/A/-/- 0 NONE 00
- 6 235477c4 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x23469ccc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469ccc handle=2355e4b4 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469d18[0x23fea74c,0x2346a468] htb=0x23fea74c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x23ee
- LIBRARY OBJECT HANDLE: handle=2355e4b4 mutex=0x2355e568(2)
- 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
- hash=2c7d8d54a642c499a38f8bd87da474ac timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=002a hlc=002a
- lwt=0x2355e510[0x2355e510,0x2355e510] ltm=0x2355e518[0x2355e518,0x2355e518]
- pwt=0x2355e4f4[0x2355e4f4,0x2355e4f4] ptm=0x2355e4fc[0x2355e4fc,0x2355e4fc]
- ref=0x2355e530[0x2355e530,0x2355e530] lnd=0x2355e53c[0x2359c270,0x2356164c]
- LIBRARY OBJECT: object=2355e03c
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23557c5c 23557910 2355df40
- 1 23557c5c 23557a80 23599fe4
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2355e444 2355e0d4 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346504c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346504c handle=235134c4 mode=N
- call pin=(nil) session pin=0x23465c4c hpc=0000 hlc=0000
- htl=0x23465098[0x23469908,0x23fea9b4] htb=0x23fea9b4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=235134c4 mutex=0x23513578(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0014 hlc=0014
- lwt=0x23513520[0x23513520,0x23513520] ltm=0x23513528[0x23465068,0x23465068]
- pwt=0x23513504[0x23513504,0x23513504] ptm=0x2351350c[0x2351350c,0x2351350c]
- ref=0x23513540[0x23515288,0x23515288] lnd=0x2351354c[0x2351354c,0x2351354c]
- LIBRARY OBJECT: object=234f91c0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2371ec38 234f9310 I/P/A/-/- 0 NONE 00
- 6 237e3650 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x234698bc, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=234698bc handle=2353a6d8 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469908[0x23fea9b4,0x23465098] htb=0x23fea9b4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x23e0
- LIBRARY OBJECT HANDLE: handle=2353a6d8 mutex=0x2353a78c(2)
- name=select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
- hash=12f772e1a2097382e4555ba057bc44f9 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=002c hlc=002c
- lwt=0x2353a734[0x2353a734,0x2353a734] ltm=0x2353a73c[0x2353a73c,0x2353a73c]
- pwt=0x2353a718[0x2353a718,0x2353a718] ptm=0x2353a720[0x2353a720,0x2353a720]
- ref=0x2353a754[0x2353a754,0x2353a754] lnd=0x2353a760[0x235275a0,0x2354df40]
- LIBRARY OBJECT: object=2352787c
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23515464 23515118 2353a5f4
- 1 23515464 23515288 235134c4
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23535538 23527914 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464ca4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464ca4 handle=23560c20 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23464cf0[0x23465030,0x23fea8c4] htb=0x23fea8c4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23560c20 mutex=0x23560cd4(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0004 hlc=0004
- lwt=0x23560c7c[0x23560c7c,0x23560c7c] ltm=0x23560c84[0x23464cc0,0x23464cc0]
- pwt=0x23560c60[0x23560c60,0x23560c60] ptm=0x23560c68[0x23560c68,0x23560c68]
- ref=0x23560c9c[0x23560d8c,0x23560d8c] lnd=0x23560ca8[0x23560ca8,0x23560ca8]
- LIBRARY OBJECT: object=237d2e74
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 235cbe40 237d2fc4 I/P/A/-/- 0 NONE 00
- 6 237d2604 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x23464fe4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464fe4 handle=235615c4 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23465030[0x23fea8c4,0x23464cf0] htb=0x23fea8c4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2345
- LIBRARY OBJECT HANDLE: handle=235615c4 mutex=0x23561678(2)
- 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
- hash=cc0bbf5f14f51baa02e1f0fcac6b9bdb timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0006 hlc=0006
- lwt=0x23561620[0x23561620,0x23561620] ltm=0x23561628[0x23561628,0x23561628]
- pwt=0x23561604[0x23561604,0x23561604] ptm=0x2356160c[0x2356160c,0x2356160c]
- ref=0x23561640[0x23561640,0x23561640] lnd=0x2356164c[0x2355e53c,0x23586a48]
- LIBRARY OBJECT: object=2356114c
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 235610d8 23560d8c 23560c20
- 1 235610d8 23560efc 230e4ac8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23561554 235611e4 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a3b4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a3b4 handle=2358c158 mode=N
- call pin=(nil) session pin=0x234664d4 hpc=0000 hlc=0000
- htl=0x2346a400[0x2346a2c8,0x23fea5dc] htb=0x23fea5dc ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=2358c158 mutex=0x2358c20c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=000c hlc=000c
- lwt=0x2358c1b4[0x2358c1b4,0x2358c1b4] ltm=0x2358c1bc[0x2346a3d0,0x2346a3d0]
- pwt=0x2358c198[0x2358c198,0x2358c198] ptm=0x2358c1a0[0x2358c1a0,0x2358c1a0]
- ref=0x2358c1d4[0x2357fd98,0x2357fd98] lnd=0x2358c1e0[0x2358c1e0,0x2358c1e0]
- LIBRARY OBJECT: object=2358bd40
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 237e1f40 2358be90 I/P/A/-/- 0 NONE 00
- 6 234eefa8 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346a27c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a27c handle=235869c0 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a2c8[0x23fea5dc,0x2346a400] htb=0x23fea5dc ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2322
- LIBRARY OBJECT HANDLE: handle=235869c0 mutex=0x23586a74(2)
- 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
- hash=ae93e4a5100360375a3ff87632f4667e timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0014 hlc=0014
- lwt=0x23586a1c[0x23586a1c,0x23586a1c] ltm=0x23586a24[0x23586a24,0x23586a24]
- pwt=0x23586a00[0x23586a00,0x23586a00] ptm=0x23586a08[0x23586a08,0x23586a08]
- ref=0x23586a3c[0x23586a3c,0x23586a3c] lnd=0x23586a48[0x2356164c,0x2356ade0]
- LIBRARY OBJECT: object=2357ffe8
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 2357ff74 2357fc28 235868dc
- 1 2357ff74 2357fd98 2358c158
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2359926c 23580080 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346998c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346998c handle=235135a8 mode=N
- call pin=(nil) session pin=0x23466624 hpc=0000 hlc=0000
- htl=0x234699d8[0x2346a0c0,0x234653d8] htb=0x23fea5f4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=235135a8 mutex=0x2351365c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0010 hlc=0010
- lwt=0x23513604[0x23513604,0x23513604] ltm=0x2351360c[0x23469940,0x23474fd0]
- pwt=0x235135e8[0x235135e8,0x235135e8] ptm=0x235135f0[0x235135f0,0x235135f0]
- ref=0x23513624[0x23587694,0x23587694] lnd=0x23513630[0x23513630,0x23513630]
- LIBRARY OBJECT: object=2377e0f0
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236258bc 2377e240 I/P/A/-/- 0 NONE 00
- 6 23593dd4 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x2346a074, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a074 handle=2356ad58 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x2346a0c0[0x23fea5f4,0x234699d8] htb=0x23fea5f4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x22fd
- LIBRARY OBJECT HANDLE: handle=2356ad58 mutex=0x2356ae0c(2)
- name=
- 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#
- hash=16030b5c728b234081e54a3c95c2a581 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0022 hlc=0022
- lwt=0x2356adb4[0x2356adb4,0x2356adb4] ltm=0x2356adbc[0x2356adbc,0x2356adbc]
- pwt=0x2356ad98[0x2356ad98,0x2356ad98] ptm=0x2356ada0[0x2356ada0,0x2356ada0]
- ref=0x2356add4[0x2356add4,0x2356add4] lnd=0x2356ade0[0x23586a48,0x2357d910]
- LIBRARY OBJECT: object=2356a8e0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 23587870 23587524 2356a7d8
- 1 23587870 23587694 235135a8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 2356ace8 2356a978 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a484, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a484 handle=2351368c mode=N
- call pin=(nil) session pin=0x234663d8 hpc=0000 hlc=0000
- htl=0x2346a4d0[0x23469cb0,0x23fea85c] htb=0x23fea85c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=2351368c mutex=0x23513740(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=000a hlc=000a
- lwt=0x235136e8[0x235136e8,0x235136e8] ltm=0x235136f0[0x2346a4a0,0x2346a4a0]
- pwt=0x235136cc[0x235136cc,0x235136cc] ptm=0x235136d4[0x235136d4,0x235136d4]
- ref=0x23513708[0x2356c170,0x2356c170] lnd=0x23513714[0x23513714,0x23513714]
- LIBRARY OBJECT: object=23528820
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236bc0b0 23528970 I/P/A/-/- 0 NONE 00
- 6 2377e510 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x23469c64, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469c64 handle=2357d888 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469cb0[0x23fea85c,0x2346a4d0] htb=0x23fea85c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x22de
- LIBRARY OBJECT HANDLE: handle=2357d888 mutex=0x2357d93c(2)
- name=select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
- hash=f8e43e747a17f71f63993cf787e718ce timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=001a hlc=001a
- lwt=0x2357d8e4[0x2357d8e4,0x2357d8e4] ltm=0x2357d8ec[0x2357d8ec,0x2357d8ec]
- pwt=0x2357d8c8[0x2357d8c8,0x2357d8c8] ptm=0x2357d8d0[0x2357d8d0,0x2357d8d0]
- ref=0x2357d904[0x2357d904,0x2357d904] lnd=0x2357d910[0x2356ade0,0x23771e08]
- LIBRARY OBJECT: object=2356c3c0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 2356c34c 2356c000 2356be94
- 1 2356c34c 2356c170 2351368c
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23598178 2356c458 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23464d0c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23464d0c handle=235595c8 mode=N
- call pin=(nil) session pin=0x23465f94 hpc=0000 hlc=0000
- htl=0x23464d58[0x23469de8,0x2346a1f8] htb=0x23fea79c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=235595c8 mutex=0x2355967c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0010 hlc=0010
- lwt=0x23559624[0x23559624,0x23559624] ltm=0x2355962c[0x23465618,0x23474f00]
- pwt=0x23559608[0x23559608,0x23559608] ptm=0x23559610[0x23559610,0x23559610]
- ref=0x23559644[0x2352da94,0x2352da94] lnd=0x23559650[0x23559650,0x23559650]
- LIBRARY OBJECT: object=2355f7a8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 236fdc90 2355f8f8 I/P/A/-/- 0 NONE 00
- 6 2355ef38 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x23469d9c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469d9c handle=235244f4 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23469de8[0x23fea79c,0x23464d58] htb=0x23fea79c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x22b1
- LIBRARY OBJECT HANDLE: handle=235244f4 mutex=0x235245a8(2)
- name=
- 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$
- hash=1d4a51a2c89ab6b07a3c64bebc5573b6 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=0024 hlc=0024
- lwt=0x23524550[0x23524550,0x23524550] ltm=0x23524558[0x23524558,0x23524558]
- pwt=0x23524534[0x23524534,0x23524534] ptm=0x2352453c[0x2352453c,0x2352453c]
- ref=0x23524570[0x23524570,0x23524570] lnd=0x2352457c[0x235226d0,0x2359d488]
- LIBRARY OBJECT: object=2352dce0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 2352dc6c 2352d920 2352d7b4
- 1 2352dc6c 2352da94 235595c8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23531564 2352dd78 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23469b2c, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23469b2c handle=23523564 mode=N
- call pin=(nil) session pin=0x23465e44 hpc=0000 hlc=0000
- htl=0x23469b78[0x23465238,0x2346a608] htb=0x23fea5bc ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=23523564 mutex=0x23523618(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0010 hlc=0010
- lwt=0x235235c0[0x235235c0,0x235235c0] ltm=0x235235c8[0x23469f58,0x23474e30]
- pwt=0x235235a4[0x235235a4,0x235235a4] ptm=0x235235ac[0x235235ac,0x235235ac]
- ref=0x235235e0[0x2354d850,0x2354d850] lnd=0x235235ec[0x235235ec,0x235235ec]
- LIBRARY OBJECT: object=2359a940
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23744e00 2359aa90 I/P/A/-/- 0 NONE 00
- 6 2359a0d0 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x234651ec, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=234651ec handle=2354deb8 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23465238[0x23fea5bc,0x23469b78] htb=0x23fea5bc ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x2284
- LIBRARY OBJECT HANDLE: handle=2354deb8 mutex=0x2354df6c(2)
- name=
- 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# (+)
- hash=436a415b2251827617e919499a05b67a timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/LRG/KST/DBN/MTX/[100100d5]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0024 hlc=0024
- lwt=0x2354df14[0x2354df14,0x2354df14] ltm=0x2354df1c[0x2354df1c,0x2354df1c]
- pwt=0x2354def8[0x2354def8,0x2354def8] ptm=0x2354df00[0x2354df00,0x2354df00]
- ref=0x2354df34[0x2354df34,0x2354df34] lnd=0x2354df40[0x2353a760,0x2358adcc]
- LIBRARY OBJECT: object=2354daa0
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 2354da2c 2354d6e0 23531690
- 1 2354da2c 2354d850 23523564
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23543b78 2354db38 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x23465594, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23465594 handle=2359ea9c mode=N
- call pin=(nil) session pin=0x23466138 hpc=0000 hlc=0000
- htl=0x234655e0[0x234651d0,0x2346a128] htb=0x23fea66c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=2359ea9c mutex=0x2359eb50(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=000e hlc=000e
- lwt=0x2359eaf8[0x2359eaf8,0x2359eaf8] ltm=0x2359eb00[0x23464f98,0x234752a8]
- pwt=0x2359eadc[0x2359eadc,0x2359eadc] ptm=0x2359eae4[0x2359eae4,0x2359eae4]
- ref=0x2359eb18[0x235aa134,0x235aa134] lnd=0x2359eb24[0x2359eb24,0x2359eb24]
- LIBRARY OBJECT: object=235a7b20
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 237742ac 235a7c70 I/P/A/-/- 0 NONE 00
- 6 235ae764 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x23465184, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=23465184 handle=2358ad44 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x234651d0[0x23fea66c,0x234655e0] htb=0x23fea66c ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x226e
- LIBRARY OBJECT HANDLE: handle=2358ad44 mutex=0x2358adf8(2)
- 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
- hash=b26a259f381e87d302773791f5e84a90 timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
- lwt=0x2358ada0[0x2358ada0,0x2358ada0] ltm=0x2358ada8[0x2358ada8,0x2358ada8]
- pwt=0x2358ad84[0x2358ad84,0x2358ad84] ptm=0x2358ad8c[0x2358ad8c,0x2358ad8c]
- ref=0x2358adc0[0x2358adc0,0x2358adc0] lnd=0x2358adcc[0x2354df40,0x23725b5c]
- LIBRARY OBJECT: object=2358a92c
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 235aa2f4 235a9fa8 235a9e3c
- 1 235aa2f4 235aa134 2359ea9c
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 23590794 2358a9c4 I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x2346a4ec, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=2346a4ec handle=235cb2a8 mode=N
- call pin=(nil) session pin=0x23466480 hpc=0000 hlc=0000
- htl=0x2346a538[0x23465510,0x23fea4c4] htb=0x23fea4c4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=BRO/[0100] savepoint=0x0
- LIBRARY OBJECT HANDLE: handle=235cb2a8 mutex=0x235cb35c(0)
- namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]
- kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0002 hlc=0002
- lwt=0x235cb304[0x235cb304,0x235cb304] ltm=0x235cb30c[0x2346a508,0x2346a508]
- pwt=0x235cb2e8[0x235cb2e8,0x235cb2e8] ptm=0x235cb2f0[0x235cb2f0,0x235cb2f0]
- ref=0x235cb324[0x235cb414,0x235cb414] lnd=0x235cb330[0x235cb330,0x235cb330]
- LIBRARY OBJECT: object=235cae30
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 235cb238 235caf80 I/P/A/-/- 0 NONE 00
- 6 235c658c 0 I/-/-/-/- 0 NONE 04
- ----------------------------------------
- SO: 0x234654c4, type: 53, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- LIBRARY OBJECT LOCK: lock=234654c4 handle=235e5398 mode=N
- call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
- htl=0x23465510[0x23fea4c4,0x2346a538] htb=0x23fea4c4 ssga=0x23fea138
- user=2553e1dc session=255326d4 count=1 flags=[0000] savepoint=0x225a
- LIBRARY OBJECT HANDLE: handle=235e5398 mutex=0x235e544c(1)
- name=delete from obj$ where obj# = :1
- hash=f71aa535c97ed95d54ee311937a7a95b timestamp=06-23-2008 08:56:27
- namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/SML/KST/DBN/MTX/[120100d4]
- kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=3 hpc=0002 hlc=0002
- lwt=0x235e53f4[0x235e53f4,0x235e53f4] ltm=0x235e53fc[0x235e53fc,0x235e53fc]
- pwt=0x235e53d8[0x235e53d8,0x235e53d8] ptm=0x235e53e0[0x235e53e0,0x235e53e0]
- ref=0x235e5414[0x235e5414,0x235e5414] lnd=0x235e5420[0x236ba90c,0x2373b280]
- LIBRARY OBJECT: object=235cb7d4
- type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
- CHILDREN: size=16
- child# table reference handle
- ------ -------- --------- --------
- 0 235cb760 235cb414 235cb2a8
- DATA BLOCKS:
- data# heap pointer status pins change whr
- ----- -------- -------- --------- ---- ------ ---
- 0 235e531c 235cb86c I/P/A/-/- 0 NONE 00
- ----------------------------------------
- SO: 0x255c6750, type: 5, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- (enqueue) TS-00000003-00000001 DID: 0001-0008-00000003
- lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x2
- res: 255d255c, mode: SX, prv: 255d2564, own: 2553e1dc, sess: 2553e1dc, proc: 2550ada8
- ----------------------------------------
- SO: 0x253fb760, type: 41, owner: 0x2553e1dc, flag: INIT/-/-/0x00
- (dummy) nxc=2, nlb=1
- ----------------------------------------
- SO: 0x253f8b9c, type: 40, owner: 0x253fb760, flag: INIT/-/-/0x00
- (trans) flg = 0x04, flg2 = 0x00, prx = 0x0, ros = 2147483647 bsn = 0x2512 spn = 0x2512
- efd = 4
- parent xid: 0x0000.000.00000000
- 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)
- cev: (spc = 0 arsp = 0 ubk tsn: 0 rdba: 0x00000000 useg tsn: 0 rdba: 0x00000000
- hwm uba: 0x00000000.0000.00 col uba: 0x00000000.0000.00
- num bl: 0 bk list: 0x0)
- cr opc: 0x0 spc: 0 uba: 0x00000000.0000.00
- (enqueue) <no resource>
- res: 0, prv: 0, own: 0, sess: 0
- xga: 0x0, heap: UGA
- Trans IMU st: 2 Pool index 65535, Redo pool 0x253f8fc8, Undo pool 0x253f9044
- Redo pool range [0x0 0xb7266a90 0xb7269290]
- Undo pool range [0x0 0xb7264290 0xb7266a90]
- ----------------------------------------
- SO: 0x253f90b8, type: 40, owner: 0x253fb760, flag: INIT/-/-/0x00
- (trans) flg = 0x04, flg2 = 0x00, prx = 0x253f8b9c, ros = 2147483647 bsn = 0x250f spn = 0x2510
- efd = 4
- parent xid: 0x0000.000.00000000
- 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)
- cev: (spc = 1524 arsp = 0 ubk tsn: 1 rdba: 0x008039a4 useg tsn: 2147483647 rdba: 0x00000000
- hwm uba: 0x008039a4.0038.35 col uba: 0x00000000.0000.00
- num bl: 0 bk list: 0x0)
- cr opc: 0x0 spc: 1524 uba: 0x008039a4.0038.35
- (enqueue) CU-2304FA78-00000000 DID: 0001-0008-00000003
- lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 flag: 0x0
- res: 255d2b44, prv: 255d2b4c, own: 2553e1dc, sess: 2553e1dc
- xga: 0x0, heap: UGA
- Trans IMU st: 0 Pool index 65535, Redo pool 0x253f94e4, Undo pool 0x253f9560
- Redo pool range [0x0 0xb72ad800 0xb72b0000]
- Undo pool range [0x0 0xb72ab000 0xb72ad800]
- ----------------------------------------
- SO: 0x25789cd8, type: 39, owner: 0x253fb760, flag: -/-/-/0x00
- (List of Blocks) next index = 3
- index itli buffer hint rdba savepoint
- -----------------------------------------------------------
- 0 2 0x2538bf84 0x4011c4 0x242e
- 1 2 0x2538bcb4 0x4011d2 0x2431
- 2 2 0x2538bd68 0x4011da 0x2433
- ----------------------------------------
- SO: 0x2560539c, type: 11, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 0x2550ada8,
- event: 8, last message event: 18,
- last message waited event: 18, messages read: 1
- channel: (0x25605fe0) system events broadcast channel
- scope: 2, event: 21, last mesage event: 18,
- publishers/subscribers: 0/8,
- messages published: 1
- ----------------------------------------
- SO: 0x2554b13c, type: 3, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (call) sess: cur 2553e1dc, rec 0, usr 2553e1dc; depth: 0
- ----------------------------------------
- SO: 0x252cd1e8, type: 16, owner: 0x2550ada8, flag: INIT/-/-/0x00
- (osp req holder)
- ===================================================
- CURRENT SESSION'S INSTANTIATION STATE
- -------------------------------------
- current session=0x2553e1dc
- KGI STATE DUMP for session=0x2553e1dc
- -------------------------------------
- INSTANTIATION OBJECT: object=0xb728cb38
- type="KOKA open cursor"[1] lock=(nil) handle=(nil) body=(nil) level=0
- flags=[40] executions=0
- REST OF INSTANTIATION OBJECT:
- address=0xb728cba4 size=12
- (nil) 0x000005 0x00000a
- -------------------------------------
- INSTANTIATION OBJECT: object=0xb728cab4
- type="KOKA pseudo cursor"[2] lock=(nil) handle=(nil) body=(nil) level=0
- flags=[40] executions=0
- REST OF INSTANTIATION OBJECT:
- address=0xb728cb20 size=12
- (nil) 0x000005 0x00000a
- KGI STATE DUMP DONE for session=0x2553e1dc
- ******************** Session Cursor Dump **********************
- Current cursor: 0, pgadep: 0
- Open cursors(pls, sys, hwm, max): 0(0, 0, 50, 50)
- NULL 0 SYNTAX 0 PARSE 0 BOUND 0 FETCH 0 ROW 0
- Cached frame pages(total, free):
- 4k(6, 6), 8k(1, 1), 16k(0, 0), 32k(0, 0)
- Session cached cursors
- -----------------------------------------------------------
- -------------- Generic Session Cached Cursors Dump --------
- -----------------------------------------------------------
- hash table=0xb7281970 cnt=20 LRU=0xb72778d0 cnt=20 hit=449 max=20 NumberOfTypes=3
- type#0 name=KQD count=15
- type#1 name=KQD BUN count=0
- type#2 name=KKS count=5
- Bucket#003 seg=0xb72819c4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b9094 0 flg=0 typ=2 idx=3 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b90a4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b90b4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b90c4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#007 seg=0xb7281a44 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b912c 0 flg=0 typ=2 idx=7 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b913c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b914c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b915c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#014 seg=0xb7281b24 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7293504 0 flg=0 typ=2 idx=e cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7293514 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7293524 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7293534 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#015 seg=0xb7281b44 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7287ec8 0 flg=0 typ=2 idx=f cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7287ed8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7287ee8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7287ef8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#020 seg=0xb7281be4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b1408 0 flg=0 typ=0 idx=14 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b1418 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b1428 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b1438 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#028 seg=0xb7281ce4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b0494 0 flg=0 typ=0 idx=1c cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b04a4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b04b4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b04c4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#029 seg=0xb7281d04 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7293550 0 flg=0 typ=2 idx=1d cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7293560 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7293570 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7293580 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#039 seg=0xb7281e44 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb729ba94 0 flg=0 typ=2 idx=27 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb729baa4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729bab4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729bac4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#046 seg=0xb7281f24 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b947c 0 flg=0 typ=2 idx=2e cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b948c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b949c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b94ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#049 seg=0xb7281f84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b237c 0 flg=0 typ=0 idx=31 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b238c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b239c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b23ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#056 seg=0xb7282064 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=4
- 0 cob=0xb729cbac 38 flg=0 typ=0 idx=38 cur=0xb72bf8b8 lru=1 flg=1 hdl=0x230f80e0
- 1 cob=0xb729cbbc 10038 flg=0 typ=0 idx=10038 cur=0xb72cf534 lru=1 flg=1 hdl=0x230f80e0
- 2 cob=0xb729cbcc 20038 flg=0 typ=0 idx=20038 cur=0xb72b24d8 lru=1 flg=1 hdl=0x230f80e0
- 3 cob=0xb729cbdc 30038 flg=0 typ=0 idx=30038 cur=0xb72ba43c lru=1 flg=1 hdl=0x230f80e0
- Bucket#065 seg=0xb7282184 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b36fc 0 flg=0 typ=0 idx=41 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b370c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b371c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b372c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#073 seg=0xb7282284 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b0264 0 flg=0 typ=2 idx=49 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b0274 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b0284 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b0294 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#079 seg=0xb7282344 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72cf468 0 flg=0 typ=2 idx=4f cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72cf478 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72cf488 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72cf498 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#087 seg=0xb7282444 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72cf41c 0 flg=0 typ=2 idx=57 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72cf42c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72cf43c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72cf44c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#092 seg=0xb72824e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb7296544 5c flg=0 typ=2 idx=5c cur=0xb72cfe28 lru=1 flg=1 hdl=0x235e5398
- 1 cob=0xb7296554 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7296564 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7296574 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#105 seg=0xb7282684 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72920fc 0 flg=0 typ=0 idx=69 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb729210c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729211c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729212c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#106 seg=0xb72826a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b9430 0 flg=0 typ=2 idx=6a cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b9440 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b9450 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b9460 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#111 seg=0xb7282744 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb729a398 0 flg=0 typ=2 idx=6f cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb729a3a8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729a3b8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729a3c8 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#115 seg=0xb72827c4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7287e7c 0 flg=0 typ=2 idx=73 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7287e8c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7287e9c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7287eac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#116 seg=0xb72827e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7292184 0 flg=0 typ=2 idx=74 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7292194 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72921a4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72921b4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#122 seg=0xb72828a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72bf3e0 0 flg=0 typ=2 idx=7a cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72bf3f0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72bf400 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72bf410 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#123 seg=0xb72828c4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
- 0 cob=0xb7287df4 7b flg=0 typ=0 idx=7b cur=0xb72b1574 lru=1 flg=5 hdl=0x2354deb8
- 1 cob=0xb7287e04 1007b flg=0 typ=0 idx=1007b cur=0xb72bfa9c lru=1 flg=5 hdl=0x2354deb8
- 2 cob=0xb7287e14 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7287e24 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#124 seg=0xb72828e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7287f14 0 flg=0 typ=0 idx=7c cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7287f24 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7287f34 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7287f44 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#127 seg=0xb7282944 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb729347c 7f flg=0 typ=0 idx=7f cur=0xb729fd54 lru=1 flg=5 hdl=0x235869c0
- 1 cob=0xb729348c 0 flg=0 typ=2 idx=1007f cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729349c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72934ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#130 seg=0xb72829a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
- 0 cob=0xb729ba0c 82 flg=0 typ=0 idx=82 cur=0xb72bf64c lru=1 flg=5 hdl=0x2356ad58
- 1 cob=0xb729ba1c 10082 flg=0 typ=0 idx=10082 cur=0xb7298d78 lru=1 flg=5 hdl=0x2356ad58
- 2 cob=0xb729ba2c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729ba3c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#132 seg=0xb72829e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72ba31c 0 flg=0 typ=0 idx=84 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72ba32c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72ba33c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72ba34c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#136 seg=0xb7282a64 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb72b935c 88 flg=0 typ=0 idx=88 cur=0xb72bfe28 lru=1 flg=5 hdl=0x234fe3b4
- 1 cob=0xb72b936c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b937c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b938c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#137 seg=0xb7282a84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb72b900c 89 flg=0 typ=0 idx=89 cur=0xb72b9178 lru=1 flg=5 hdl=0x235042c8
- 1 cob=0xb72b901c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b902c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b903c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#145 seg=0xb7282b84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
- 0 cob=0xb728b1a4 91 flg=0 typ=0 idx=91 cur=0xb72cfb70 lru=1 flg=5 hdl=0x2358ad44
- 1 cob=0xb728b1b4 10091 flg=0 typ=0 idx=10091 cur=0xb728637c lru=1 flg=5 hdl=0x2358ad44
- 2 cob=0xb728b1c4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb728b1d4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#160 seg=0xb7282d64 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72921d0 0 flg=0 typ=2 idx=a0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72921e0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72921f0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7292200 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#161 seg=0xb7282d84 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b93e4 0 flg=0 typ=2 idx=a1 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b93f4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b9404 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b9414 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#162 seg=0xb7282da4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb729a3e4 0 flg=0 typ=2 idx=a2 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb729a3f4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729a404 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729a414 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#172 seg=0xb7282ee4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7296360 0 flg=0 typ=2 idx=ac cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7296370 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7296380 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7296390 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#173 seg=0xb7282f04 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb72bb650 0 flg=0 typ=0 idx=ad cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72bb660 100ad flg=0 typ=0 idx=100ad cur=0xb72bf468 lru=1 flg=5 hdl=0x2355e4b4
- 2 cob=0xb72bb670 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72bb680 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#183 seg=0xb7283044 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=2
- 0 cob=0xb729ea7c b7 flg=0 typ=0 idx=b7 cur=0xb72b0600 lru=1 flg=5 hdl=0x235244f4
- 1 cob=0xb729ea8c 100b7 flg=0 typ=0 idx=100b7 cur=0xb729cc44 lru=1 flg=5 hdl=0x235244f4
- 2 cob=0xb729ea9c 0 flg=0 typ=0 idx=200b7 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729eaac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#185 seg=0xb7283084 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb729bae0 0 flg=0 typ=2 idx=b9 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb729baf0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729bb00 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729bb10 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#192 seg=0xb7283164 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb729bb2c 0 flg=0 typ=2 idx=c0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb729bb3c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb729bb4c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729bb5c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#202 seg=0xb72832a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb7296314 0 flg=0 typ=2 idx=ca cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb7296324 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7296334 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb7296344 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#207 seg=0xb7283344 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb7296590 cf flg=0 typ=0 idx=cf cur=0xb7289fb4 lru=1 flg=5 hdl=0x2357d888
- 1 cob=0xb72965a0 0 flg=0 typ=2 idx=100cf cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72965b0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72965c0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#220 seg=0xb72834e4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb7291fdc dc flg=0 typ=0 idx=dc cur=0xb728a39c lru=1 flg=5 hdl=0x235615c4
- 1 cob=0xb7291fec 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb7291ffc 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb729200c 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#240 seg=0xb7283764 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72b90e0 0 flg=0 typ=2 idx=f0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72b90f0 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72b9100 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72b9110 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#247 seg=0xb7283844 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb72bf830 0 flg=0 typ=2 idx=f7 cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72bf840 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72bf850 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72bf860 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#250 seg=0xb72838a4 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=1
- 0 cob=0xb72bc5c4 0 flg=0 typ=0 idx=fa cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72bc5d4 100fa flg=0 typ=0 idx=100fa cur=0xb728a1b8 lru=1 flg=5 hdl=0x2353a6d8
- 2 cob=0xb72bc5e4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72bc5f4 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- Bucket#255 seg=0xb7283944 nit=4 nal=4 ips=4 sz=16 flg=3 ucnt=0
- 0 cob=0xb729359c 0 flg=0 typ=2 idx=ff cur=(nil) lru=0 flg=0 hdl=(nil)
- 1 cob=0xb72935ac 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 2 cob=0xb72935bc 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- 3 cob=0xb72935cc 0 flg=0 typ=0 idx=0 cur=(nil) lru=0 flg=0 hdl=(nil)
- -----------------------------------------------------------
- ------Finished Dumping Generic Session Cached Cursors------
- -----------------------------------------------------------
- ----------------------------------------
- sqltxt(0x235e5398)=delete from obj$ where obj# = :1
- hash=f71aa535c97ed95d54ee311937a7a95b
- parent=0x235cb86c maxchild=01 plk=0x234654c4 ppn=n
- cursor instantiation=0xb72cfe28
- child#0(0x235cb2a8) pcs=0x235cba70
- clk=0x2346a4ec ci=0x235caf80 pn=(nil) ctx=(nil)
- kgsccflg=1 llk[0xb72b1578,0xb72778d0] idx=5c
- xscflg=100400 fl2=1000400 fl3=22180 fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Frames pfr (nil) siz=3976 efr (nil) siz=3964
- Cursor frame dump
- ----------------------------------------
- sqltxt(0x2354deb8)=
- 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# (+)
- hash=436a415b2251827617e919499a05b67a
- parent=0x2354db38 maxchild=02 plk=0x234651ec ppn=n
- cursor instantiation=0xb72b1574
- child#1(0x23523564) pcs=0x2354d708
- clk=0x23469b2c ci=0x2359aa90 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72cfb74,0xb72cfe2c] idx=7b
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b7295ee4 bln=22 avl=03 flg=05
- value=575
- Frames pfr 0xb72962c0 siz=8400 efr 0xb7294d4c siz=8384
- Cursor frame dump
- kxscphp 0xb72901f0 siz=5204 inu=4484 nps=4452
- kxscdfhp 0xb7290e50 siz=1000 inu=56 nps=0
- kxscehp 0xb7291714 siz=1000 inu=108 nps=36
- kxscefhp 0xb72900e8 siz=3048 inu=2240 nps=2208
- ----------------------------------------
- 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
- hash=b26a259f381e87d302773791f5e84a90
- parent=0x2358a9c4 maxchild=02 plk=0x23465184 ppn=n
- cursor instantiation=0xb72cfb70
- child#1(0x2359ea9c) pcs=0x235a9fec
- clk=0x23465594 ci=0x235a7c70 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb728a3a0,0xb72b1578] idx=91
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72b2358 bln=22 avl=01 flg=05
- value=0
- Bind#1
- oacdty=01 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
- oacflg=18 fl2=0001 frm=01 csi=01 siz=32 off=0
- kxsbbbfp=b72b232c bln=32 avl=16 flg=05
- value="SMON_SCN_TO_TIME"
- Bind#2
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72b2308 bln=24 avl=02 flg=05
- value=5
- Frames pfr 0xb72b1cf8 siz=3740 efr 0xb72b0b90 siz=3728
- Cursor frame dump
- kxscphp 0xb7285ba8 siz=2016 inu=1556 nps=1492
- kxscdfhp 0xb7290ed4 siz=1000 inu=56 nps=0
- kxscehp 0xb72902f8 siz=1000 inu=228 nps=116
- kxscefhp 0xb72908a4 siz=1000 inu=108 nps=36
- ----------------------------------------
- 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
- hash=cc0bbf5f14f51baa02e1f0fcac6b9bdb
- parent=0x235611e4 maxchild=02 plk=0x23464fe4 ppn=n
- cursor instantiation=0xb728a39c
- child#0(0x23560c20) pcs=0x235613e8
- clk=0x23464ca4 ci=0x237d2fc4 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb7289fb8,0xb72cfb74] idx=dc
- xscflg=a0141436 fl2=45000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72b2ec0 bln=22 avl=03 flg=05
- value=573
- Frames pfr 0xb72cfb1c siz=3464 efr 0xb729a2c8 siz=3452
- Cursor frame dump
- kxscphp 0xb72900e8 siz=3048 inu=2240 nps=2208
- kxscdfhp 0xb7290610 siz=1000 inu=56 nps=0
- kxscehp 0xb7290ab4 siz=1000 inu=108 nps=36
- kxscefhp 0xb72908a4 siz=1000 inu=108 nps=36
- ----------------------------------------
- sqltxt(0x2357d888)=select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
- hash=f8e43e747a17f71f63993cf787e718ce
- parent=0x2356c458 maxchild=02 plk=0x23469c64 ppn=n
- cursor instantiation=0xb7289fb4
- child#1(0x2351368c) pcs=0x2356c028
- clk=0x2346a484 ci=0x23528970 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72b0604,0xb728a3a0] idx=cf
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72baa08 bln=22 avl=03 flg=05
- value=574
- Frames pfr 0xb72baa70 siz=2176 efr 0xb72baac0 siz=2164
- Cursor frame dump
- kxscphp 0xb7290c40 siz=1000 inu=952 nps=920
- kxscdfhp 0xb7290a30 siz=1000 inu=56 nps=0
- kxscehp 0xb7290484 siz=1000 inu=108 nps=36
- kxscefhp 0xb7290928 siz=2016 inu=1880 nps=1848
- ----------------------------------------
- sqltxt(0x235244f4)=
- 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#
- hash=1d4a51a2c89ab6b07a3c64bebc5573b6
- parent=0x2352dd78 maxchild=02 plk=0x23469d9c ppn=n
- cursor instantiation=0xb72b0600
- child#1(0x235595c8) pcs=0x2352d94c
- clk=0x23464d0c ci=0x2355f8f8 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72bf650,0xb7289fb8] idx=b7
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b729b5dc bln=22 avl=03 flg=05
- value=573
- Bind#1
- No oacdef for this bind.
- Frames pfr 0xb72bb4f0 siz=12136 efr 0xb729b994 siz=12112
- Cursor frame dump
- kxscphp 0xb7291588 siz=5264 inu=4600 nps=4552
- kxscdfhp 0xb7290b38 siz=1000 inu=212 nps=0
- kxscehp 0xb7291270 siz=1000 inu=128 nps=36
- kxscefhp 0xb729079c siz=1000 inu=712 nps=680
- ----------------------------------------
- sqltxt(0x2356ad58)=
- 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#
- hash=16030b5c728b234081e54a3c95c2a581
- parent=0x2356a978 maxchild=02 plk=0x2346a074 ppn=n
- cursor instantiation=0xb72bf64c
- child#1(0x235135a8) pcs=0x2358754c
- clk=0x2346998c ci=0x2377e240 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb728a1bc,0xb72b0604] idx=82
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b729304c bln=22 avl=03 flg=05
- value=573
- Frames pfr 0xb7293428 siz=4308 efr 0xb7292690 siz=4296
- Cursor frame dump
- kxscphp 0xb7290f58 siz=3168 inu=2472 nps=2440
- kxscdfhp 0xb7290cc4 siz=1000 inu=204 nps=0
- kxscehp 0xb729058c siz=1000 inu=108 nps=36
- kxscefhp 0xb72908a4 siz=1000 inu=108 nps=36
- ----------------------------------------
- sqltxt(0x2353a6d8)=select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
- hash=12f772e1a2097382e4555ba057bc44f9
- parent=0x23527914 maxchild=02 plk=0x234698bc ppn=n
- cursor instantiation=0xb728a1b8
- child#1(0x235134c4) pcs=0x23515140
- clk=0x2346504c ci=0x234f9310 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72bf46c,0xb72bf650] idx=100fa
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b7299344 bln=22 avl=03 flg=05
- value=575
- Frames pfr 0xb7299428 siz=2132 efr 0xb7299470 siz=2120
- Cursor frame dump
- kxscphp 0xb7290274 siz=1000 inu=828 nps=796
- kxscdfhp 0xb7290400 siz=1000 inu=56 nps=0
- kxscehp 0xb72908a4 siz=1000 inu=108 nps=36
- kxscefhp 0xb729079c siz=1000 inu=712 nps=680
- ----------------------------------------
- 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
- hash=2c7d8d54a642c499a38f8bd87da474ac
- parent=0x2355e0d4 maxchild=02 plk=0x23469ccc ppn=n
- cursor instantiation=0xb72bf468
- child#1(0x23599fe4) pcs=0x23557938
- clk=0x2346a41c ci=0x237e3380 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb729fd58,0xb728a1bc] idx=100ad
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72875b8 bln=22 avl=03 flg=05
- value=575
- Frames pfr 0xb7287644 siz=3036 efr 0xb728768c siz=3024
- Cursor frame dump
- kxscphp 0xb7290928 siz=2016 inu=1880 nps=1848
- kxscdfhp 0xb7290d48 siz=1000 inu=204 nps=0
- kxscehp 0xb7290508 siz=1000 inu=108 nps=36
- kxscefhp 0xb729079c siz=1000 inu=712 nps=680
- ----------------------------------------
- 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
- hash=ae93e4a5100360375a3ff87632f4667e
- parent=0x23580080 maxchild=02 plk=0x2346a27c ppn=n
- cursor instantiation=0xb729fd54
- child#1(0x2358c158) pcs=0x2357fc50
- clk=0x2346a3b4 ci=0x2358be90 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72bfe2c,0xb72bf46c] idx=7f
- xscflg=a1141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b728a968 bln=22 avl=03 flg=05
- value=575
- Frames pfr 0xb72b3304 siz=2496 efr 0xb728ad38 siz=2484
- Cursor frame dump
- kxscphp 0xb7290694 siz=2016 inu=1180 nps=1148
- kxscdfhp 0xb72909ac siz=1000 inu=56 nps=0
- kxscehp 0xb7290dcc siz=1000 inu=108 nps=36
- ----------------------------------------
- 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#
- hash=d751142c3b7971bd655864a445f58a87
- parent=0x235067e4 maxchild=02 plk=0x23464d74 ppn=n
- cursor instantiation=0xb72bfe28
- child#1(0x234fd368) pcs=0x235063b4
- clk=0x2346a144 ci=0x23549f58 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72b917c,0xb729fd58] idx=88
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b729ea58 bln=22 avl=03 flg=05
- value=575
- Frames pfr 0xb72866e0 siz=2704 efr 0xb7286728 siz=2692
- Cursor frame dump
- kxscphp 0xb729079c siz=1000 inu=712 nps=680
- kxscdfhp 0xb728625c siz=1000 inu=56 nps=0
- kxscehp 0xb7285c2c siz=1000 inu=108 nps=36
- ----------------------------------------
- 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#
- hash=26947ac91d45c1242b247fc5f6b6f088
- parent=0x23503ee8 maxchild=02 plk=0x2346a554 ppn=n
- cursor instantiation=0xb72b9178
- child#1(0x23517b58) pcs=0x23503ab8
- clk=0x23464eac ci=0x23520dfc pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb7286380,0xb72bfe2c] idx=89
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b729de34 bln=22 avl=03 flg=05
- value=575
- Frames pfr 0xb729df8c siz=2736 efr 0xb729dfd4 siz=2724
- Cursor frame dump
- kxscphp 0xb7291dc8 siz=1000 inu=712 nps=680
- kxscdfhp 0xb7291ab0 siz=1000 inu=56 nps=0
- kxscehp 0xb7291d44 siz=1000 inu=108 nps=36
- ----------------------------------------
- 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
- hash=b26a259f381e87d302773791f5e84a90
- parent=0x2358a9c4 maxchild=02 plk=0x2346a0dc ppn=n
- cursor instantiation=0xb728637c
- child#1(0x2359ea9c) pcs=0x235a9fec
- clk=0x23464f7c ci=0x235a7c70 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72bfaa0,0xb72b917c] idx=10091
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b729d61c bln=22 avl=01 flg=05
- value=0
- Bind#1
- oacdty=01 mxl=32(11) mxlc=00 mal=00 scl=00 pre=00
- oacflg=18 fl2=0001 frm=01 csi=01 siz=32 off=0
- kxsbbbfp=b729d5f0 bln=32 avl=11 flg=05
- value="IND_ONLINE$"
- Bind#2
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b729d5cc bln=24 avl=02 flg=05
- value=1
- Frames pfr 0xb729cfbc siz=3740 efr 0xb7299b20 siz=3728
- Cursor frame dump
- kxscphp 0xb7291e4c siz=2016 inu=1556 nps=1492
- kxscdfhp 0xb7291924 siz=1000 inu=56 nps=0
- kxscehp 0xb7291cc0 siz=1000 inu=228 nps=116
- ----------------------------------------
- sqltxt(0x2354deb8)=
- 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# (+)
- hash=436a415b2251827617e919499a05b67a
- parent=0x2354db38 maxchild=02 plk=0x2346a5bc ppn=n
- cursor instantiation=0xb72bfa9c
- child#1(0x23523564) pcs=0x2354d708
- clk=0x23469f3c ci=0x2359aa90 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb729cc48,0xb7286380] idx=1007b
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b7297f2c bln=22 avl=03 flg=05
- value=731
- Frames pfr 0xb7298308 siz=8400 efr 0xb7296d94 siz=8384
- Cursor frame dump
- kxscphp 0xb7291bb8 siz=5204 inu=4484 nps=4452
- kxscdfhp 0xb7291798 siz=1000 inu=56 nps=0
- kxscehp 0xb7291a2c siz=1000 inu=108 nps=36
- ----------------------------------------
- sqltxt(0x235244f4)=
- 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#
- hash=1d4a51a2c89ab6b07a3c64bebc5573b6
- parent=0x2352dd78 maxchild=02 plk=0x2346a1ac ppn=n
- cursor instantiation=0xb729cc44
- child#1(0x235595c8) pcs=0x2352d94c
- clk=0x234655fc ci=0x2355f8f8 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb7298d7c,0xb72bfaa0] idx=100b7
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72befb0 bln=22 avl=03 flg=05
- value=731
- Bind#1
- No oacdef for this bind.
- Frames pfr 0xb72bdd90 siz=12136 efr 0xb72bf368 siz=12112
- Cursor frame dump
- kxscphp 0xb7291b34 siz=5264 inu=4600 nps=4552
- kxscdfhp 0xb72918a0 siz=1000 inu=212 nps=0
- kxscehp 0xb7291480 siz=1000 inu=128 nps=36
- ----------------------------------------
- sqltxt(0x2356ad58)=
- 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#
- hash=16030b5c728b234081e54a3c95c2a581
- parent=0x2356a978 maxchild=02 plk=0x2346538c ppn=n
- cursor instantiation=0xb7298d78
- child#1(0x235135a8) pcs=0x2358754c
- clk=0x23469924 ci=0x2377e240 pn=(nil) ctx=(nil)
- kgsccflg=5 llk[0xb72bf8bc,0xb729cc48] idx=10082
- xscflg=a0141436 fl2=5000401 fl3=2210c fl4=0
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- kxsbbbfp=b72bd2a8 bln=22 avl=03 flg=05
- value=731
- Frames pfr 0xb72bd684 siz=4308 efr 0xb72bc8ec siz=4296
- Cursor frame dump
- kxscphp 0xb72919a8 siz=3184 inu=2472 nps=2440
- kxscdfhp 0xb7291060 siz=1000 inu=204 nps=0
- kxscehp 0xb729037c siz=1000 inu=108 nps=36
- ----------------------------------------
- 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
- hash=6d11d7de2049577d933d2385337fc737
- parent=0x230f7d00 maxchild=02 plk=0x2346a214 ppn=n
- cursor instantiation=0xb72bf8b8
- child#1(0x23558d44) pcs=0x23111a84
- clk=0x23464a9c ci=0x22ef6510 pn=(nil) ctx=0x23521f04
- kgsccflg=1 llk[0xb72cf538,0xb7298d7c] idx=38
- xscflg=100410 fl2=1000401 fl3=22100 fl4=0
- Bind bytecodes
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 0
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 20
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Bind#1
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Frames pfr (nil) siz=3160 efr (nil) siz=3148
- Cursor frame dump
- enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
- pnxt: 2.0x00000004 pnxt: 1.0x00000008
- ----------------------------------------
- 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
- hash=6d11d7de2049577d933d2385337fc737
- parent=0x230f7d00 maxchild=02 plk=0x23464b04 ppn=n
- cursor instantiation=0xb72cf534
- child#1(0x23558d44) pcs=0x23111a84
- clk=0x23469b94 ci=0x22ef6510 pn=(nil) ctx=0x23521f04
- kgsccflg=1 llk[0xb72b24dc,0xb72bf8bc] idx=10038
- xscflg=100410 fl2=1000401 fl3=22100 fl4=0
- Bind bytecodes
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 0
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 20
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Bind#1
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Frames pfr (nil) siz=3160 efr (nil) siz=3148
- Cursor frame dump
- enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
- pnxt: 2.0x00000004 pnxt: 1.0x00000008
- ----------------------------------------
- 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
- hash=6d11d7de2049577d933d2385337fc737
- parent=0x230f7d00 maxchild=02 plk=0x23464964 ppn=n
- cursor instantiation=0xb72b24d8
- child#1(0x23558d44) pcs=0x23111a84
- clk=0x23464bd4 ci=0x22ef6510 pn=(nil) ctx=0x23521f04
- kgsccflg=1 llk[0xb72ba440,0xb72cf538] idx=20038
- xscflg=100410 fl2=1000401 fl3=22100 fl4=0
- Bind bytecodes
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 0
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 20
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Bind#1
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Frames pfr (nil) siz=3160 efr (nil) siz=3148
- Cursor frame dump
- enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
- pnxt: 2.0x00000004 pnxt: 1.0x00000008
- ----------------------------------------
- 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
- hash=6d11d7de2049577d933d2385337fc737
- parent=0x230f7d00 maxchild=02 plk=0x23469ac4 ppn=n
- cursor instantiation=0xb72ba43c
- child#1(0x23558d44) pcs=0x23111a84
- clk=0x2346482c ci=0x22ef6510 pn=(nil) ctx=0x23521f04
- kgsccflg=1 llk[0xb72778d0,0xb72b24dc] idx=30038
- xscflg=100410 fl2=1000401 fl3=22100 fl4=0
- Bind bytecodes
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 0
- Opcode = 1 Unoptimized
- Offsi = 36, Offsi = 20
- kkscoacd
- Bind#0
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Bind#1
- oacdty=02 mxl=22(00) mxlc=00 mal=00 scl=00 pre=00
- oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
- No bind buffers allocated
- Frames pfr (nil) siz=3160 efr (nil) siz=3148
- Cursor frame dump
- enxt: 3.0x000002d0 enxt: 2.0x00000028 enxt: 1.0x00000954
- pnxt: 2.0x00000004 pnxt: 1.0x00000008
- Memory dump of process state object:
- Dump of memory from 0x2550ADA8 to 0x2550B35C
- 2550ADA0 00000102 00000000 [........]
- 2550ADB0 00000000 00000000 00000000 234546D8 [.............FE#]
- 2550ADC0 252CD1F4 2554B13C 252CC47C 00000000 [..,%<.T%|.,%....]
- 2550ADD0 252CC4E0 252CC4E0 252CD1E8 00001601 [..,%..,%..,%....]
- 2550ADE0 2553E1DC 2554B13C 00000008 2554C00C [..S%<.T%......T%]
- 2550ADF0 2554C184 00000000 256053C0 234546F0 [..T%.....S`%.FE#]
- 2550AE00 00000000 00000000 00000000 00000000 [................]
- Repeat 3 times
- 2550AE40 00000000 00170000 00000000 00040000 [................]
- 2550AE50 00000000 00060000 00000000 000A0000 [................]
- 2550AE60 00000000 000A0000 00000000 00040000 [................]
- 2550AE70 00000000 00070000 00000000 000A0000 [................]
- 2550AE80 00000000 00040000 00000000 00050000 [................]
- 2550AE90 00000000 00110000 00000000 00000000 [................]
- 2550AEA0 00000000 00000000 00000000 00000000 [................]
- Repeat 1 times
- 2550AEC0 485EF4BA 00000000 00000000 00000000 [..^H............]
- 2550AED0 00000000 00000000 00000000 2550AEDC [..............P%]
- 2550AEE0 2550AEDC 00000000 00000000 FFFFFFFF [..P%............]
- 2550AEF0 2550AEF0 2550AEF0 00000000 00000000 [..P%..P%........]
- 2550AF00 00000000 00000000 00000000 00000245 [............E...]
- 2550AF10 00000000 00005645 00000090 00000004 [....EV..........]
- 2550AF20 0000000F 00000011 2550C478 2550C478 [........x.P%x.P%]
- 2550AF30 00010000 00000000 00000000 00000000 [................]
- 2550AF40 00000000 00000000 00000000 00000000 [................]
- Repeat 1 times
- 2550AF60 000019C2 00000000 00000000 00000000 [................]
- 2550AF70 00000000 00000000 00000000 00000000 [................]
- Repeat 2 times
- 2550AFA0 2550ADA8 00000000 00000000 00000000 [..P%............]
- 2550AFB0 00000000 00000000 00000000 00000000 [................]
- Repeat 5 times
- 2550B010 00000000 00000000 485EF4BA 2550B01C [..........^H..P%]
- 2550B020 2550B01C 00000000 00000000 00000001 [..P%............]
- 2550B030 00000000 00000000 000C8001 0000000C [................]
- 2550B040 000019C2 0216DA4E B74478D0 00000000 [....N....xD.....]
- 2550B050 00000000 00000000 00000000 00000000 [................]
- Repeat 1 times
- 2550B070 00000004 FFFFFFFF 00000000 00000000 [................]
- 2550B080 00000000 00000000 00000000 00000000 [................]
- Repeat 7 times
- 2550B100 6361726F 0000656C 00000000 00000000 [oracle..........]
- 2550B110 00000000 00000000 00000000 00000000 [................]
- 2550B120 00000006 746E6578 72656769 00000000 [....xentiger....]
- 2550B130 00000000 00000000 00000000 00000000 [................]
- Repeat 2 times
- 2550B160 00000000 00000008 4E4B4E55 004E574F [........UNKNOWN.]
- 2550B170 00000000 00000000 00000000 00000000 [................]
- 2550B180 00000000 00000000 00000008 34393536 [............6594]
- 2550B190 00000000 00000000 00000000 00000000 [................]
- 2550B1A0 00000000 00000004 6361726F 7840656C [........oracle@x]
- 2550B1B0 69746E65 20726567 4F4D5328 0000294E [entiger (SMON)..]
- 2550B1C0 00000000 00000000 00000000 00000000 [................]
- 2550B1D0 00000000 00000000 00000016 00000002 [................]
- 2550B1E0 00000000 00000000 00000000 00000000 [................]
- Repeat 9 times
- 2550B280 00000000 00000200 00000000 00000000 [................]
- 2550B290 00000000 00000000 25513CE4 2550B850 [.........<Q%P.P%]
- 2550B2A0 2550ACE8 00000000 255DC7C0 00000000 [..P%......]%....]
- 2550B2B0 00000000 00000000 00000000 00000000 [................]
- 2550B2C0 00000000 2550B2C4 2550B2C4 00080000 [......P%..P%....]
- 2550B2D0 00000000 0003949D 00071F11 000B949D [................]
- 2550B2E0 00011CE8 00000000 000081B8 00000000 [................]
- 2550B2F0 00024704 00000000 00000814 00000000 [.G..............]
- 2550B300 00000088 00000000 00000814 00000000 [................]
- 2550B310 00000000 00000000 00000000 00000000 [................]
- Repeat 3 times
- 2550B350 00000000 00000000 00000003 [............]
- Symbolic dump of process state object:
- KSUPRFLG = 22
- KSUPRSER = 1
- KSUPRIOC = 0
- KSLLALAQ = 0X00000000
- KSLLAWAT = 0X00000000
- KSLLAWHY = 0
- KSLLAWER = 0
- KSLLALOW = 0
- KSLLAPSC = 15
- KSLLAPRC = 17
- KSLLAPRV = 144
- KSLLAPSN = 4
- KSLLID1R = 0
- KSLLID2R = 0
- KSLLRTYP = ''
- KSLLRMTY = 0
- KSUPRPID = ''
- KSUPRUNM = 'oracle'
- KSUPRMNM = ''
- KSUPRPNM = 'oracle@xentiger (SMON)'
- KSUPRTID = ''
- KSSRCOBJ = 0X00000000
- KSSRCFRE = 0X00000000
- KSSRCSRC = 0X00000000
- KSSRCDST = 0X00000000
- KSASTQNX = 0X2550B01C
- KSASTQPR = 0X2550B01C
- KSASTRPL = 0
- KSUPRPUM = 466705
- KSUPRPNAM = 234653
- KSUPRPRAM = 524288
- KSUPRPFM = 0
- KSUPRPMM = 758941
- KSFD PGA DUMPS
- Number of completed I/O requests=0 flags=0
- END OF PROCESS STATE
- *** 2008-06-23 09:01:49.429
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:01:59.433
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:02:09.435
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:02:19.438
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:02:29.442
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:02:39.445
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:02:49.449
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:02:59.451
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:03:09.455
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:03:19.458
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:03:29.462
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:03:39.465
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:03:49.468
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:03:59.470
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:04:09.472
- Serial Transaction recovery caught exception 376
- *** 2008-06-23 09:04:09.472
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:04:19.475
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:04:29.479
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:04:39.481
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:04:49.484
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:04:59.488
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:05:09.491
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:05:19.494
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:05:29.498
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:05:39.501
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:05:49.505
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:05:59.508
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:06:09.511
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:06:19.515
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:06:29.517
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:06:39.520
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:06:49.522
- Serial Transaction recovery caught exception 376
- *** 2008-06-23 09:06:49.522
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:06:59.525
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:07:09.529
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:07:19.531
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:07:29.534
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:07:39.537
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:07:49.541
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:07:59.543
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- ORA-01110: data file 1: '/u01/app/oracle/oradata/BABYDB/datafile/o1_mf_system_45xrz1n7_.dbf'
- *** 2008-06-23 09:08:09.547
- SMON: following errors trapped and ignored:
- ORA-00376: file 1 cannot be read at this time
- 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