SQL> create table ORACLE as select * from all_objects;
Table created.
SQL> exec dbms_stats.gather_table_stats('SCOTT','ORACLE');
PL/SQL procedure successfully completed.
SQL> column segment_name format a25
SQL> column table_name format a25
SQL> select segment_name,round((bytes/1024),2) ||'kb' "SIZE"
2 from user_segments
3 where segment_name = 'ORACLE';
SEGMENT_NAME SIZE
------------------------- ------------------------------------------
ORACLE 5120kb
SQL> --Table Size
SQL> select table_name, round((blocks*8),2)||'kb' "SIZE"
2 from user_tables
3 where table_name = 'ORACLE';
TABLE_NAME SIZE
------------------------- ------------------------------------------
ORACLE 4504kb
SQL> --Actual Data Size in Table
SQL> select table_name,round((num_rows*avg_row_len/1024),2)||'kb' "SIZE"
2 from user_tables
3 where table_name = 'ORACLE';
TABLE_NAME SIZE
------------------------- ------------------------------------------
ORACLE 3575.67kb
SQL>
Note :
SQL> show parameter db_block_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192
No comments:
Post a Comment