size of table

[quester]

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

---

Quick Navigation Oracle Database Administration Top

• Site Areas
• Settings
• Private Messages
• Subscriptions
• Who's Online
• Search Forums
• Forums Home
• Forums
• Oracle Forums
  1. Oracle Database Administration
  2. Oracle Applications DBA
  3. Oracle Development
  4. Oracle Certification
  5. Oracle : How To
• Oracle Careers
  1. Oracle Positions Available
  2. Oracle Job Wanted
• Archives
  1. Forum Archives
• Other
  1. Feedback and Questions regarding the forums
  2. 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

• Contact Us
• DBAsupport.com Home Page
• Top

Click Here to Expand Forum to Full Width