Home » RDBMS Server » Server Administration » Capacity Planning! (Oracle  () 1 Vote
icon4.gif  Capacity Planning! [message #381861] Tue, 20 January 2009 02:40 Go to next message
Messages: 12
Registered: March 2008
Location: India
Junior Member


We are planning to add a number of interfaces in our system. So, going forward, our oracle database will be exchange data with many systems (15 in number).
Hence, we would have to do capacity planning under which we will have to calculate how much more disk space & processing capacity we would require.

IS ther any particular standard which needs to be followed or the calculations need to be done on the basis of experience?
OR we also need to consider the approximate number of records which would be stored & exchanged with different systems.

It would be highly appreciated if some oracle expert imparts his/her valuable knowledge on the capacity planning front.

Re: Capacity Planning! [message #383854 is a reply to message #381861] Fri, 30 January 2009 13:17 Go to previous messageGo to next message
Messages: 62
Registered: April 2008
Capacity planning is basicaly depends on number of things.

1. how much data you currently have?
2. What is growth rate of your database.How much database size increase per week or month.
3.What is your company's retention policy.How much data you want to keep.Like 1 year (OLTP) or 10 year(DW).
4.What are yur expectation of data growth.Will the data growth will be uniform or it will increase.

Based on all things you can do capacity planning and think of primary and secondary storages.

Re: Capacity Planning! [message #383946 is a reply to message #383854] Sat, 31 January 2009 23:40 Go to previous messageGo to next message
Messages: 11
Registered: January 2009
Junior Member
It is excellent.and could you give us more details?
for example if I can make clear how many records I will keep,then how can I convert to migabytes or gigabytes?
Re: Capacity Planning! [message #384356 is a reply to message #383946] Tue, 03 February 2009 08:50 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a look in the DBA_TABLES view.
assuming you've analysed your tables, the column AVG_ROW_LEN will tell you the average number of bytes taken up by a row in your table.
Previous Topic: Shutdown Oracle the Instance
Next Topic: Problem while exporting database
Goto Forum:

Current Time: Thu Mar 30 19:23:18 CDT 2017

Total time taken to generate the page: 0.10613 seconds