Re: Maxsize for Set of Tablespaces in 10g and 11i?

From: onedbguru <onedbguru_at_yahoo.com>
Date: Mon, 13 Dec 2010 18:57:45 -0800 (PST)
Message-ID: <12bff97a-7276-4310-bafb-8ad50905084e_at_l17g2000yqe.googlegroups.com>



On Dec 13, 7:35 pm, HoneyMonster <some..._at_someplace.invalid> wrote:
> On Mon, 13 Dec 2010 07:40:01 -0800, if_inves..._at_yahoo.com wrote:
> > Hi,
>
> > Is there a way, on 10g and 11i, to create a set of 4 tablespaces, each
> > of which is
> > set to autoextend, so that the entire set of tablespaces has a specific
> > maxsize
> > value?
>
> > I am not interested in setting a specific maxsize value for any specific
> > tablespace,
> > rather, for the set as a whole.
>
> Not directly within Oracle.
>
> Far better IMHO to avoid autoextend altogether; simply set sensible sizes
> for your tablespaces and monitor, unless the requirements are highly
> unusual.

IMHO, ditch file systems direct-attached SCSI and use ASM with SAN to automatically manage all of those pesky space issues - just make sure you have enough disk space for your system. Disks are cheap compared to constant monitoring and the on-call personnel having to get called in for such stupid things as space. If companies and people would stop skimping on their hardware more of us DBA's would get a lot more sleep. How much space does your db need? -- All of it!! Received on Mon Dec 13 2010 - 20:57:45 CST

Original text of this message