Re: How to tune tables for inserts and Updates?

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_at_gmail.com> 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_at_HP.Com

--
http://www.freelists.org/webpage/oracle-l