Re: Partitions on RAID 5 SAN and Tablespaces
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Tue, 25 Mar 2008 23:11:47 -0500
Message-ID: <L0kGj.5120$qT6.3839@nlpi070.nbdc.sbc.com>
>
> Hi Zip,
>
> It's always relative, but believe it or not 50GB isn't that large. I
> would put it in multiple tablespaces, though, based on experience. We
> did this with a 2TB table last summer that was otherwise completely
> unmanageable. We can now shrink a partition if need be and reclaim
> the physical space, since each partition is in a separate tablespace.
> If you don't do this, and you shrink a partition at the "front" of the
> datafile, you may not be able to shrink the datafile.
>
> You also have to backup the entire table in RMAN at one time if its in
> one tablespace. You can back up different partitions one at a time if
> its in separate tablespaces. That's where we get the most bang for
> our back with partitions.
>
> HTH,
>
> Steve
Date: Tue, 25 Mar 2008 23:11:47 -0500
Message-ID: <L0kGj.5120$qT6.3839@nlpi070.nbdc.sbc.com>
Steve Howard wrote:
> On Mar 25, 3:51 pm, zip <zipRobe..._at_gmail.com> wrote:
>> Does it make any sense to partition an extremly large table by >> tablespace in a SAN RAID 5 environment or just put the partitions in >> one BIGFILE tablespace? I can see using tablespaces to put the files >> on different spindles, but in a SAN is this necessary? >> >> Anyone had any problem putting a very large (50 G) partition table >> into one BIGFILE tablespace? >> >> Zip
>
> Hi Zip,
>
> It's always relative, but believe it or not 50GB isn't that large. I
> would put it in multiple tablespaces, though, based on experience. We
> did this with a 2TB table last summer that was otherwise completely
> unmanageable. We can now shrink a partition if need be and reclaim
> the physical space, since each partition is in a separate tablespace.
> If you don't do this, and you shrink a partition at the "front" of the
> datafile, you may not be able to shrink the datafile.
>
> You also have to backup the entire table in RMAN at one time if its in
> one tablespace. You can back up different partitions one at a time if
> its in separate tablespaces. That's where we get the most bang for
> our back with partitions.
>
> HTH,
>
> Steve
agreed - 50G is small potatoes... Try managing a 250TB or a 1PB database without partitioning... Now that gets interesting... Received on Tue Mar 25 2008 - 23:11:47 CDT