OBJD MISMATCH - cheeyoung/sqlplus-public GitHub Wiki
WAIT #4575312720: nam='db file scattered read' ela= 13811 file#=345 block#=2531336 blocks=128 obj#=170587 tim=10063502128060
OBJD MISMATCH typ=6, seg.obj=605886, diskobj=678600, dsflg=100001, dsobj=605886, tid=605886, cls=1
| arg |
value |
|
| seg.obj |
605886 |
|
| diskobj |
678600 |
data object number from the disk |
...
28636 WAIT #4575312720: nam='db file scattered read' ela= 13811 file#=345 block#=2531336 blocks=128 obj#=170587 tim=10063502128060
28637
28638 *** SESSION ID:(388.1993) 2017-04-12 14:16:45.601
28639 OBJD MISMATCH typ=6, seg.obj=605886, diskobj=678600, dsflg=100001, dsobj=605886, tid=605886, cls=1
28640 FETCH #4575312720:c=26100000,e=63978182,p=482393,cr=575523,cu=0,mis=0,r=0,dep=0,og=2
,plh=2532066093,tim=10063502129322
28641 STAT #4575312720 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=0 pr=0 pw=0 time=23 us)'
28642 STAT #4575312720 id=2 cnt=103746335 pid=1 pos=1 obj=170587 op='INDEX FAST FULL SCAN
IX_PRD_IMP_QRY_D_01 (cr=575523 pr=482265 pw=0 time=61242598 us cost=6527 size=0 card=9095958
)'
28643 WAIT #4575312720: nam='SQL*Net break/reset to client' ela= 9 driver id=1650815232 break?=1 p3=0 obj#=170587 tim=10063502129699
...