calculation [message #50732] |
Wed, 03 April 2002 17:50 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
hi
I would like to know how many rows will fit into a data block of size 4k. Given that there are 5 columns in a table. The datatypes are
number
varchar(50)
varchar(500)
date
char(10)
There are initially 20000 rows and increasing at the rete of 20000 rows per day.
Assume that this is the only table in the tablespace.
bye
|
|
|
|
Re: calculation [message #50743 is a reply to message #50732] |
Thu, 04 April 2002 04:05 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
NUMBER, DATE, and CHAR are static but VARCHAR2 isn't. Your best bet is to analyze the table with COMPUTE and look at AVG_ROW_LEN in DBA_TABLES for that table.
|
|
|