OraFAQ Forum: Server Administration » Calculation of initial extent size of table

Home » RDBMS Server » Server Administration » Calculation of initial extent size of table (Oracle Database 10g Release 10.2.0.4.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calculation of initial extent size of table [message #452326]

Wed, 21 April 2010 06:12

Gangaprasad
Messages: 7
Registered: April 2010
Location: India

Junior Member

Hi all,

I need to create table A.
which will going have more than 8L records.
Daily this table A will truncate and reinsert all 8L records.
Also number of records(8L) will we increase 50K per month.
Please suggest what should be storage clause parameters
mainly initial and next extent.

Report message to a moderator

Re: Calculation of initial extent size of table [message #452327 is a reply to message #452326]

Wed, 21 April 2010 06:14

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Calculate the average size of your 8L(!) rows and use it at initial extent size.

Also use LMT with autoallocate management.

Regards
Michel

Report message to a moderator

Re: Calculation of initial extent size of table [message #452328 is a reply to message #452327]

Wed, 21 April 2010 06:18

Gangaprasad
Messages: 7
Registered: April 2010
Location: India

Junior Member

Thanks Michel,

can you provide me the formula or procedure to calculate average size of 8L rows.

Report message to a moderator

Re: Calculation of initial extent size of table [message #452329 is a reply to message #452328]

Wed, 21 April 2010 06:25

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Analyze the table and query user_tables.AVG_ROW_LEN column.

Regards
Michel

Report message to a moderator

Previous Topic:	Refreshing the Stale Statistics in Oracle Database
Next Topic:	ORA-01940 Cannot drop user that is currently connected after STARTUP RESTRICT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:29:27 CDT 2024