If You Have An Example Table, What Is The Best Way To Get Sizing Data

1.	If You Have An Example Table, What Is The Best Way To Get Sizing Data For The Production Table Implementation?
Answer» The best way is to analyze the table and then USE the data PROVIDED in the DBA_TABLES VIEW to get the average row LENGTH and other pertinent data for the calculation. The quick and dirty way is to look at the number of blocks the table is actually using and ratio the number of rows in the table to its number of blocks against the number of EXPECTED rows. The best way is to analyze the table and then use the data provided in the DBA_TABLES view to get the average row length and other pertinent data for the calculation. The quick and dirty way is to look at the number of blocks the table is actually using and ratio the number of rows in the table to its number of blocks against the number of expected rows.

If You Have An Example Table, What Is The Best Way To Get Sizing Data For The Production Table Implementation?

Answer»

The best way is to analyze the table and then USE the data PROVIDED in the DBA_TABLES VIEW to get the average row LENGTH and other pertinent data for the calculation. The quick and dirty way is to look at the number of blocks the table is actually using and ratio the number of rows in the table to its number of blocks against the number of EXPECTED rows.

The best way is to analyze the table and then use the data provided in the DBA_TABLES view to get the average row length and other pertinent data for the calculation. The quick and dirty way is to look at the number of blocks the table is actually using and ratio the number of rows in the table to its number of blocks against the number of expected rows.

Discussion

No Comment Found

Related InterviewSolutions

Can You Import Objects From Oracle Version 7.3 To 9i?
Suppose A Column Has Many Repeated Values. Which Type Of Index You Should Create On This Column?
If A Table Has Few Rows, Should You Create Indexes On This Table?
How Do You Capture An Exception In Oracle?
What Is Recursive Sql?
What Are Different Types Of Cursors?
Can You Pivot The Results Of A Query?
What Is Null?
What Is Execute Immediate?
What Is A Database Link? What Is The Difference Between A Public And A Private Database Link? What Is A Fixed User Database Link?