OraFAQ Forum: Server Administration » Capacity planning and perfomance issue

Home » RDBMS Server » Server Administration » Capacity planning and perfomance issue

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

Capacity planning and perfomance issue [message #205375]

Fri, 24 November 2006 06:50

jaydba
Messages: 86
Registered: September 2006
Location: UK

Member

Hi guys,

Can you please provide your comments/suggestion/recommendation on the following issue?

We are expecting the size of the daily data 1GB (per day) in one of our table in the database through ftp from another server. Gradually, it would grow upto 30 GB over a period of few months.

This data would be transferred through UNIX script.

The table structure is enclosed here for your reference

Column Name Column Type
col1 Number(15)
col2 Varchar2(255)
col3 Varchar2(255)
col4 Varchar2(255)
col5 Varchar2(255)
col6 Number(4,2)
col7 Number(10)
col8 Date
col9 Number(8,2)
col10 Number(8,2)
col11 Date
col12 Varchar2(3)

What storage parameter can I recommend to accommodate this high growth of data at table or tablespace level?

How can I check the performance of database perspective in advance. i.e. CPU, Memory, I/O etc.( may be using iostat, vmstat, mpstat, sar)?

In another way, what would be the impact on CPU , I/O, Memory?

What would be the impact on the overall database?

What precautionary actions are required to running database efficiently?

What other things should be taken into consideration before downloading or transferring data from another server.

Report message to a moderator

Re: Capacity planning and perfomance issue [message #205431 is a reply to message #205375]

Fri, 24 November 2006 13:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Oracle Version?
Nature of application?
>> How can I check the performance of database perspective in advance. i.e. CPU, Memory, I/O etc.( may be using iostat, vmstat, mpstat, sar)
AWR?
http://www.oracle-base.com/articles/10g/AutomaticWorkloadRepository10g.php
It is hard to answer most of your questions as they very generic.
>> What storage parameter can I recommend to accommodate this high growth of data at table or tablespace level?
LMT with uniform extent size or look into ASSM.
>> What precautionary actions are required to running database efficiently?
Probably a zillion of them are available. Smile

There is no rule-of-thumb.
Post your specific problems. Someone might be able to address it.

Report message to a moderator

Re: Capacity planning and perfomance issue [message #205767 is a reply to message #205431]

Mon, 27 November 2006 08:16

jaydba
Messages: 86
Registered: September 2006
Location: UK

Member

Thanks for your comments.

It is Old version of Oracle 8.1.7.

It is reporting server with huge amount of database in GB.

I think partitioning of table would be more advisable.

Can you please recommend how to eastimate the isze of this object with appropriate storage parameter. i.e PCTFREE/PCTUSED.

thanks in advance.

Report message to a moderator

Previous Topic:	Listener do not work
Next Topic:	ORACLE Management Server problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:47:17 CDT 2024