DBA Data[Home] [Help]

VIEW: SYS.KU$_NTABLE_BYTES_ALLOC_VIEW

Source

View Text - Preformatted

select case when bitand(t.property,64)=0
                 then (select value(b1) from ku$_htable_bytes_alloc_view b1
                       where b1.obj_num = t.obj#)
                 else (select value(b2) from ku$_iotable_bytes_alloc_view b2
                       where b2.obj_num = t.obj#)
                 end
  from tab$ t
View Text - HTML Formatted

SELECT CASE WHEN BITAND(T.PROPERTY
, 64)=0 THEN (SELECT VALUE(B1)
FROM KU$_HTABLE_BYTES_ALLOC_VIEW B1
WHERE B1.OBJ_NUM = T.OBJ#) ELSE (SELECT VALUE(B2)
FROM KU$_IOTABLE_BYTES_ALLOC_VIEW B2
WHERE B2.OBJ_NUM = T.OBJ#) END
FROM TAB$ T