Home » RDBMS Server » Server Administration » calculation
calculation [message #50732] Wed, 03 April 2002 17:50 Go to next message
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

Report message to a moderator

Re: calculation [message #50741 is a reply to message #50732] Thu, 04 April 2002 03:52 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Easiest way is to get the free copy of TOAD from

http://www.toadsoft.com

Go to 'tuning/estimate table size' and use enter the no of records you are expecting.

Good luck.

Report message to a moderator

Re: calculation [message #50743 is a reply to message #50732] Thu, 04 April 2002 04:05 Go to previous message
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.

Report message to a moderator

Previous Topic: Re: certification guide -8/8i/9i
Next Topic: Help! Trouble tracking down the process to a computer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:35:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.