Re: Table Spaces

John,

It is hard to tell if it has any effect on performance. Normally you split applications over diverent tablespaces to split I/O going on to tables or indexes in that tablespaces. But if all tablespaces thus there datafiles are on the same disk it doesn't help for I/O. But , if you have only one disk it is still good to seperate tables and indexes because you are better organized.

So it is hard to tell if you DBA does the right thing. But if you have complains about performance then maybe you should get a second opinion.

Regards,
Alfons Riesebeek

John <brun_at_msx.upmc.edu> schreef in artikel <35d2c589.29373506_at_usenet.pitt.edu>...
> Maybe I should not be here as I am not an Oracle DBA but I do have a
> general question I would like to ask in regards to Table Spaces.
>
> We have an application that, at installation, runs a script that
> creates approx 13 different table spaces. The DBA then goes back and
> removes all but two of them saying that they really have no effect
> upon performance.
>
> As I said, as I am not an Oracle DBA, I am hesitant to ask him about
> this but somehow it does not sound right?
>
>
>
Received on Thu Aug 13 1998 - 09:08:38 CDT