| 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: RE: LMT ASSM & next extent
Niall
Here is the equation I work with:
Which is greater:
1) The time spent monitoring and adjusting the storage in each
tablespace per year.
2) Time spent cleaning up from the occasional runaway process that
filled up the device each year.
If 1 is greater, use autoextend. If 2 is greater, don't use autoextend. I started to include time to monitor disk space, but that occurs in both alternatives.
In my situation, I used to spend a day or so each week monitoring and forecasting disk space. Then my workload expanded and that day disappeared. In desperation I tried autoextend. Knock on wood, haven't had any runaway incidents in maybe 3 years.
I don't autoextend system or temp tablespaces. I don't feel there is much advantage to autoextend with a maxsize. Just one more lurking limit to get hammered by.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]
Sent: Wednesday, February 11, 2004 10:27 AM
To: Rich.Jesse_at_quadtechworld.com; oracle-l_at_freelists.org
Subject: RE: RE: LMT ASSM & next extent
Hi Rich
It wasn't so much a serious question of what are the commands - I knew df -k and the windows stuff, it was if you set autoextend on and monitor *database* growth then you (or the sysadmin if separate) also need to consider the free space on the file system. If you have Oracle datafiles growing intermittently and unpredictably (I liked your K/M confusion example (I *think* we can have G from 9.2 as well) AND other stuff going on on the OS it's a recipe for disaster.=20
At least with fixed datafile sizes (either fixed or max) then you *know* what Oracle is doing,a dnyou should be able to do nice trend reporting ahead of time. Always best to fix problems before they happen. There is another advantage of fixed datafile sizes, namely if they are all the same size moving them around to balance IO becomes a lot easier.=20
cheers=20
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20
> -----Original Message-----
> From: Rich.Jesse_at_quadtechworld.com=20
> Sent: 11 February 2004 14:50
> To: oracle-l_at_freelists.org; Rich.Jesse_at_quadtechworld.com
> Subject: RE: RE: LMT ASSM & next extent
>=20 >=20> "bdf" on HP/UX (although "df -k" will still work)
> "df -k" on most Unixes
>=20
>=20
> Rich Jesse System/Database Administrator
> rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
>=20 >=20
>=20 >=20
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Feb 11 2004 - 11:45:17 CST
 |
 |