RE: 10g on unix. Partitions... Tablespaces... and best practices
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <awells@xxxxxxxxxxxx>
- Date: Mon, 19 Jan 2009 21:30:35 -0600
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of April Wells
Sent: Wednesday, January 14, 2009 1:28 PM
To: Jared Still; JEREMY.SHEEHAN@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx
http://www.netspend.com
________________________________________
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Wednesday, January 14, 2009 1:11 PM
To: JEREMY.SHEEHAN@xxxxxxx
Cc: April Wells; oracle-l@xxxxxxxxxxxxx
Subject: Re: 10g on unix. Partitions... Tablespaces... and best practices
On Tue, Jan 13, 2009 at 7:53 AM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx> 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.
****************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
