select table_name, num_rows, blocks/64 "SIZE_MB"
from dba_tables where table_name = 'CAP_TH_CAMPAIGN_VEHICLE';
blocks/64 depends on following parameter in db.. change accordingly.. size is approximate..
db_file_multiblock_read_count integer 64
from dba_tables where table_name = 'CAP_TH_CAMPAIGN_VEHICLE';
blocks/64 depends on following parameter in db.. change accordingly.. size is approximate..
db_file_multiblock_read_count integer 64
No comments:
Post a Comment