RE: 10g on unix. Partitions... Tablespaces... and best practices
Date: Mon, 19 Jan 2009 21:30:35 -0600
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E3605BC7C1B_at_CWYMSX04.Corp.Acxiom.net>
Sorry for the late reply, April, but I'm just getting up-to-speed after a little vacation.
If you alter "older" tablespaces to read-only, wouldn't you be able to ignore growth since, well, they're read-only and shouldn't be growing? That'd leave you with just a few tablespaces to worry about and with all the available space monitoring tools this should be pretty light.
Also, be careful with read-only tablespaces and backups. You'll obviously want a backup that includes each read-only tablespace, right after you altered it to read- only, and then pull those tapes out of the regular rotation. Otherwise, if you have a 4 week tape rotation, for example, after 4 weeks you wouldn't have an available backup of the read-only tablespace, assuming you skip read-only tablespaces as you suggested.
Dave
Dave Herring, DBA | A c x i o m M I C S / C S O 630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of April Wells Sent: Wednesday, January 14, 2009 1:28 PM To: Jared Still; JEREMY.SHEEHAN_at_fpl.com Cc: oracle-l_at_freelists.org
Subject: RE: 10g on unix. Partitions... Tablespaces... and best practices
Oh... you know (at least in my case)... keeping up with all of those tablespaces that aren't actually changing and are only holding queried data (because they are read only now) are so hard to maintain (they don't need expanded... they don't need backed up in an incremental...
Will probably add two or three minutes to my 11g upgrade
When I have to move this off of solaris and onto Linux (don't ask) it will probably take a little longer to do that conversion...
In general, I guess the idea is that the more tablespaces you have to pay attention to growth of the more you have to pay attention so it is more work.
I know that a lot of the "hey lets toss her under the bus" that went with this was more like diverting attention from what the left hand was doing ("Hey... look... it's a shiny chicken!!! Pay no attention to the man behind the curtain"). But then, right now, I'm a bit jaded...
April Wells
SR Oracle DBA
Netspend Corporation
office 512-531-8628
cell 512-461-0168
awells_at_netspend.com
http://www.netspend.com
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Wednesday, January 14, 2009 1:11 PM To: JEREMY.SHEEHAN_at_fpl.com
Cc: April Wells; oracle-l_at_freelists.org Subject: Re: 10g on unix. Partitions... Tablespaces... and best practices
On Tue, Jan 13, 2009 at 7:53 AM, SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com> wrote: E-biz has moved to a new tablespace method now. It only has 7 or 8 tablespaces needed by E-biz + any custom. I have no recommendations for you, but managing 50+ tablespaces (like in earlier E-biz models) is a pain.
I am curious as to what difficulties are encountered in administration that may be caused by the number of tablespaces.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 19 2009 - 21:30:35 CST