what are the wasys to find the size of table thanks
Sajeev
Estimating the size of a table ----------------------------- ANALYZE table COMPUTE / ESTIMATE statistics Get the AVG_ROW_LEN from DBA_TABLES, ALL_TABLES Table size = AVG_ROW_LEN * Number of Rows * (1 + PCTFREE/100) * 1.15 Reply With Quote 01-27-2003, 11:46 PM #3 agasimani View Profile View Forum Posts Senior Member Join Date Feb 2001 Location UAE Posts 304 1. analyze table tablename compute statitics 2. select blocks,empty_blocks from dba_tables where table_name='tablename'; 3. So the size of the table is (blocks+empty_blocks)*db_block_size 4. You can find the db_block size by select value from v$parameter where name='db_block_size' Agasimani OCP(10g/9i/8i/8) Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is On Forum Rules Click Here to Expand Forum to Full Width
1. analyze table tablename compute statitics 2. select blocks,empty_blocks from dba_tables where table_name='tablename'; 3. So the size of the table is (blocks+empty_blocks)*db_block_size 4. You can find the db_block size by select value from v$parameter where name='db_block_size'
Agasimani OCP(10g/9i/8i/8)
Forum Rules
Reply With Quote
