Bigfile tablespaces and ASSM.....

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 3 Oct 2006 15:12:37 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2709CE5E22@AABO-EXCHANGE02.bos.il.pqe>

Just a comment....I just noticed that for bigfile tablespaces, ASSM is required.....hmm....I guess that answers the question of ASSM vs. MSSM.

I'm setting up my test environement w/ 10gR2, three node Opteron RAC running 64-bit RHEL4, w/ ASM. With ASM, it makes a lot of sense to have one datafile per tablespace, that autoextends, and use bigfiles. That way, you never have to add a datafile. You just monitor the free space in the disk group, and add space at the diskgroup level, when necessary. But, bigfiles require ASSM....though I'm not sure why...it doesn't strike me that those two features would be related....but apparently, they are.

-Mark

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 03 2006 - 14:12:37 CDT