| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Next Extent Failure Notification for Locally Managed Tablespa ces
Stephen - To quote Monty Python "And now for something completely different
. . .
Consider switching to autoextend. It is scary I know. Won't work in every environment. But it can achieve your goals with less effort. Today if a tablespace is nearly full, what do you do? Go tell the users to delete some data? Nah, you probably just increase the size of the tablespace and go back to sleep. If there are 10 tablespaces on a device, you have 10 failure points. Autoextend can reduce that to a single failure point. It is easier and more reliable to monitor a single point of failure. Only autoextend data and index tablespaces, not undo or temp tablespaces.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wales, Stephen (RTSI)
Sent: Tuesday, June 22, 2004 11:34 AM
To: oracle-l_at_freelists.org
Subject: RE: Next Extent Failure Notification for Locally Managed
Tablespaces
That's not overly helpful, no ;)
I don't suppose there's any way to modify a tablespace to use uniform = extents after creation is there? It doesn't look like it, but if there = is, I figured I'd ask.
I really don't have the luxury of recreating this database.
Steve
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Niall Litchfield
Sent: Tuesday, June 22, 2004 2:17 AM
To: oracle-l_at_freelists.org
Subject: Re: Next Extent Failure Notification for Locally Managed
Tablespaces
It probably doesn't help to point out that you can avoid this effort entirely with uniform extents does it?
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |