Re: creating tablespaces for performance

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 10 Sep 2002 13:48:20 GMT
Message-ID: <EKmf9.379368$me6.43030_at_sccrnsc01>


That isn't a lot of data. You need to identify where your performance problem lies. What are the queries and what is the explain plan? What is the set up of the machine? (1 ide drive?) Jim

"Anand" <ashrivastava_at_auriga-insys.com> wrote in message news:396cc940.0209100306.161dcc99_at_posting.google.com...
> Hi,
>
> I'm using Oracle 8i on Win2k. I've a large database which comprises of
> two main data tables containing around 400,000 records and 40 master
> tables!
> As expected, now I'm facing performance issues.
> Somebody told me that one way to improve performance is to put the
> large tables and master tables in two different tablespaces but was
> unable to come up with sufficient supporting arguments.
> Can anyone guide me in this direction?
>
> Regards,
> Anand
Received on Tue Sep 10 2002 - 15:48:20 CEST

Original text of this message