The Size and Extends in Database | Optimize | Rebuild Multiple Objects when selecting Tables or Indexes cannot be seen.
These values are equalled to zero and this should not be the case.
Ensure that the database statistics have been gathered .
These are the selects that Toad runs to calculate the Extends and Size values. If those selects returns 0 for those values, then the problem is with the database:
select s.owner, s.segment_name, s.partition_name, s.segment_type, s.bytes, s.extents
from dba_segments s
where s.segment_type like 'INDEX%'
and s.owner in ('YOUR USER')
and s.segment_name not like 'SYS_IOT_TOP_%'
and s.segment_name not like 'SYS_IL%$$'
select owner, index_name, table_owner, table_name, null partition_name, null subpartition_name, tablespace_name, pct_increase, initial_extent, next_extent, max_extents, logging, degree, instances, status
from dba_indexes
where owner in ('YOUR USER')
and tablespace_name is not null
and index_name not like 'SYS_IOT_TOP_%'
and index_name not like 'SYS_IL%$$'
union all
select p.index_owner, p.index_name, i.table_owner, i.table_name, p.partition_name, null subpartition_name, p.tablespace_name, p.pct_increase, p.initial_extent, p.next_extent, p.max_extent, p.logging, 'n/a' degree, 'n/a' instances, p.status
from dba_ind_partitions p, dba_indexes i
where p.index_owner = i.owner
and p.index_name = i.index_name
and i.partitioned = 'YES'
and p.index_owner in ('YOUR USER')
and i.index_name not like 'SYS_IOT_TOP_%'
and i.index_name not like 'SYS_IL%$$'
and p.subpartition_count = 0
union all
select p.index_owner, p.index_name, i.table_owner, i.table_name, p.partition_name, p.subpartition_name, p.tablespace_name, p.pct_increase, p.initial_extent, p.next_extent, p.max_extent, p.logging, 'n/a' degree, 'n/a' instances, p.status
from dba_ind_subpartitions p, dba_indexes i
where p.index_owner = i.owner
and p.index_name = i.index_name
and i.partitioned = 'YES'
and p.index_owner in ('YOUR USER')
and i.index_name not like 'SYS_IOT_TOP_%'
and i.index_name not like 'SYS_IL%$$'
order by 1,2
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center