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