Home » RDBMS Server » Server Administration » Capacity planning and perfomance issue
Capacity planning and perfomance issue [message #205375] Fri, 24 November 2006 06:50 Go to next message
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.
Re: Capacity planning and perfomance issue [message #205431 is a reply to message #205375] Fri, 24 November 2006 13:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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.
Re: Capacity planning and perfomance issue [message #205767 is a reply to message #205431] Mon, 27 November 2006 08:16 Go to previous message
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.
Previous Topic: Listener do not work
Next Topic: ORACLE Management Server problem
Goto Forum:
  


Current Time: Tue Dec 03 09:14:51 CST 2024