Re: How to tune tables for inserts and Updates?

[rjamya <rjamya@xxxxxxxxx>]

for imaginary problems, there are imaginary solutions. 

Let's say you spread your 'few' tables across 'few' tablespaces, and
how exactly will that reduce your imaginary performance problem? Do
you anticipate disk I/O issues? If so, spreading data out on more
tablespaces with exactly same number of disk controllers wil resolve
the issue? how so?

10000 per day is nothing, wait till it goes in production, monitor it.
find out what the 'actual' problems are and then do something to
implement the solution.

Raj


On Fri, 1 Oct 2004 11:40:26 +0530, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
> Hi friends,
> 
> I have a Database in which few tables are for Transaction.
> 
> As the number of transactions will be more than 10000 per day, I need
> to decide the tuning strategy for the tables having more hits.
> 
> I m planning to put them ina different tablespace.
> 
> Any other idea how I can do that.
> 
>  - Chirag Majmundar
> Chirag@xxxxxx
--
http://www.freelists.org/webpage/oracle-l

• References:
  • How to tune tables for inserts and Updates?
    • From: Chirag DBA

Other related posts:

How to tune tables for inserts and Updates?

Re: How to tune tables for inserts and Updates?

Re: How to tune tables for inserts and Updates?