Home » RDBMS Server » Server Administration » Oracle Sizing (11g)
Oracle Sizing [message #637358] Fri, 15 May 2015 09:33 Go to next message
rohit_shinez
Messages: 138
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 Go to previous messageGo to next message
BlackSwan
Messages: 25795
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?
Re: Oracle Sizing [message #637360 is a reply to message #637359] Fri, 15 May 2015 09:40 Go to previous messageGo to next message
rohit_shinez
Messages: 138
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 Go to previous messageGo to next message
BlackSwan
Messages: 25795
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.
Re: Oracle Sizing [message #637362 is a reply to message #637361] Fri, 15 May 2015 09:45 Go to previous messageGo to next message
rohit_shinez
Messages: 138
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
Re: Oracle Sizing [message #637363 is a reply to message #637362] Fri, 15 May 2015 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 25795
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.
Re: Oracle Sizing [message #637370 is a reply to message #637358] Fri, 15 May 2015 13:16 Go to previous messageGo to next message
EdStevens
Messages: 887
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?



Re: Oracle Sizing [message #637372 is a reply to message #637358] Fri, 15 May 2015 13:46 Go to previous messageGo to next message
John Watson
Messages: 7216
Registered: January 2010
Location: Global Village
Senior Member
You do this with dbms_space.create_table_cost procedures.
Re: Oracle Sizing [message #637464 is a reply to message #637372] Mon, 18 May 2015 10:15 Go to previous message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
Cool procedure never knew it existed. Thanks for sharing.
Previous Topic: Wait Class - DB CPU
Next Topic: _serial_direct_read
Goto Forum:
  


Current Time: Thu Jan 18 17:02:29 CST 2018

Total time taken to generate the page: 0.01953 seconds