Re: Table Spaces

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 14 Aug 1998 02:52:21 GMT
Message-ID: <35d52dd8.13610888@netnews.worldnet.att.net>

On Thu, 13 Aug 1998 11:03:27 GMT, brun_at_msx.upmc.edu (John) wrote:

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

Hmmm... It's tough to generalize. There are probably many reasons for using different tablespaces. One use is to spread tables and indexes accross different disks. If you have 13 disks available, then 13 tablespaces may make sense. Otherwise perhaps not. Tablespaces can also be setup with different default storage parameters. I don't know if that's the case with your script or not. Read only data can be placed in read-only tablespaces, and then I believe you will gain in performance.

Your DBA may be right, or your DBA may be wrong. I don't have enough info to say. I would start by finding out why the application creates 13 tablespaces. Is this something you could ask the vendor? Then you could ask your DBA why he feels it neccessary to cut out 11 of them.

regards,

Jonathan Received on Thu Aug 13 1998 - 21:52:21 CDT