1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
SQL> SELECT value FROM v$parameter WHERE name='db_block_size';
VALUE
--------------------------------------------------------------------------------
8192
SQL> SELECT d.bytes/1024/1024,segment_name FROM dba_segments d WHERE segment_name like 'MA_TABLE';
D.BYTES/1024/1024
-----------------
SEGMENT_NAME
--------------------------------------------------------------------------------
,9375
MA_TABLE
SQL>
SQL> SELECT (blocks*8192)/1024/1024 AS "Taille en Mo" FROM all_tables WHERE table_name='MA_TABLE';
Taille en Mo
------------
,40625
SQL>
SQL> ANALYZE TABLE MA_TABLE COMPUTE STATISTICS;
Table analysée.
SQL>
SQL> SELECT d.bytes/1024/1024,segment_name FROM dba_segments d WHERE segment_name like 'MA_TABLE';
D.BYTES/1024/1024
-----------------
SEGMENT_NAME
--------------------------------------------------------------------------------
,9375
MA_TABLE
SQL>
SQL> SELECT (blocks*8192)/1024/1024 AS "Taille en Mo" FROM all_tables WHERE table_name='MA_TABLE';
Taille en Mo
------------
,40625 |
Partager