ТЕМА:

select 

 segment_name, sum(bytes) sum_byte, count(bytes) cnt_seg

 from 

 dba_segments 

 where 

   owner = 'SYS' and 

  segment_name = 'DUAL'

 group by   segment_name;



SQLWKS> select 

     2>  segment_name, sum(bytes) sum_byte, count(bytes) cnt_seg

     3>  from 

     4>  dba_segments 

     5>  where 

     6>    owner = 'SYS' and 

     7>   segment_name = 'DUAL'

     8>  group by   segment_name;

SEGMENT_NAME                                                                     SUM_BYTE   CNT_SEG   

-------------------------------------------------------------------------------- ---------- ----------


DUAL                                                                                  16384          1

Выбрана 1 строка.

SQLWKS> analyze index test.emp_pk validate structure;

Предложение обработано.

SQLWKS> select * from index_stats

     2> 

HEIGHT     BLOCKS     NAME                           PARTITION_NAME                 LF_ROWS    LF_BLKS    LF_ROWS_LE LF_BLK_LEN BR_ROWS    BR_BLKS    BR_ROWS_LE BR_BLK_LEN DEL_LF_ROW DEL_LF_ROW DISTINCT_K MOST_REPEA BTREE_SPAC USED_SPACE PCT_USED   ROWS_PER_K BLKS_GETS_ PRE_ROWS   PRE_ROWS_L

---------- ---------- ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------


         1        128 EMP_PK                                                                14          1        195       7996          0          0          0          0          0          0         14          1       7996        195          3          1          2          0          0

Выбрана 1 строка.