OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Sizing (11g)

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

Oracle Sizing [message #637358]

Fri, 15 May 2015 09:33

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

Hi,

I would like to know how we can calculate size of the table which will occupy in DB using number of records for eg. my Table_1 will have 1000 records daily how to achive the size which will occupy daily, monthly and yearly

[Updated on: Fri, 15 May 2015 09:34]

Report message to a moderator

Re: Oracle Sizing [message #637359 is a reply to message #637358]

Fri, 15 May 2015 09:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

rohit_shinez wrote on Fri, 15 May 2015 07:33

Hi,

I would like to know how we can calculate size of the table which will occupy in DB using number of records for eg. my Table_1 will have 1000 records daily how to achive the size which will occupy daily, monthly and yearly

Tables don't have records.
Tables have rows.
Rows have LENGTH
LENGTH*number_of_rows approximates size of table.
What about any index on table?

Report message to a moderator

Re: Oracle Sizing [message #637360 is a reply to message #637359]

Fri, 15 May 2015 09:40

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

Index not yet decided so will add 10% contention for index spacing.
How i would be able calculate if there 100 rows

[Updated on: Fri, 15 May 2015 09:42]

Report message to a moderator

Re: Oracle Sizing [message #637361 is a reply to message #637360]

Fri, 15 May 2015 09:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

rohit_shinez wrote on Fri, 15 May 2015 07:40

Index not yet decided so will add 10% contention for index spacing.
How i would be able calculate if there 100 rows

I have seen cases where INDEX size is greater than TABLE size. It depends.

Report message to a moderator

Re: Oracle Sizing [message #637362 is a reply to message #637361]

Fri, 15 May 2015 09:45

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

Thats why i am adding 10% contention so how can i calculate will it be 1000*number of columns in table/1025

Report message to a moderator

Re: Oracle Sizing [message #637363 is a reply to message #637362]

Fri, 15 May 2015 09:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You are free to use any formula you deem appropriate because it depends upon the specifics for situation.
The reality is that Oracle will consume the necessary space or just throw error when it can not acquire the space it needs; regardless of what you calculate.

Report message to a moderator

Re: Oracle Sizing [message #637370 is a reply to message #637358]

Fri, 15 May 2015 13:16

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

rohit_shinez wrote on Fri, 15 May 2015 09:33

Hi,

I would like to know how we can calculate size of the table which will occupy in DB using number of records for eg. my Table_1 will have 1000 records daily how to achive the size which will occupy daily, monthly and yearly

Do you know the average size of your rows?
Do you know your db block size?
If you know the above two, then you know how many rows can go into a block -- after factoring in the block header overhead and the effect of pct_free.

Do you know how many blocks will be created in an extent?
Do you realize that disk space will be allocated in chunks of an extent?

Report message to a moderator