Thursday, January 14, 2016

Find number of rows and size by simple query

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

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...