OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Capacity Planning! (Oracle 10.1.0.4) (

) 1 Vote

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

Capacity Planning! [message #381861]

Tue, 20 January 2009 02:40

JasjotS
Messages: 12
Registered: March 2008
Location: India

Junior Member

Hi,

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.

Regards,
Jasjot

Report message to a moderator

Re: Capacity Planning! [message #383854 is a reply to message #381861]

Fri, 30 January 2009 13:17

sonumalhi
Messages: 62
Registered: April 2008

Member

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.

thanks
Mehtab

Report message to a moderator

Re: Capacity Planning! [message #383946 is a reply to message #383854]

Sat, 31 January 2009 23:40

pardxa
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?

Report message to a moderator

Re: Capacity Planning! [message #384356 is a reply to message #383946]

Tue, 03 February 2009 08:50

JRowbottom
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.

Report message to a moderator

Previous Topic:	Shutdown Oracle the Instance
Next Topic:	Problem while exporting database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:44:59 CST 2024