LMT ASSM & next extent 2004-02-11 - By DENNIS WILLIAMS
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@(protected)
-- --Original Message-- --
From: Niall Litchfield [mailto:n-litchfield@(protected)]
Sent: Wednesday, February 11, 2004 10:27 AM
To: Rich.Jesse@(protected); oracle-l@(protected)
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.
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.
cheers
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
> -- --Original Message-- --
> From: Rich.Jesse@(protected)
> Sent: 11 February 2004 14:50
> To: oracle-l@(protected); Rich.Jesse@(protected)
> Subject: RE: RE: LMT ASSM & next extent
>
>
> "df -k " on most Unixes
> "bdf " on HP/UX (although "df -k " will still work)
> "show dev d " on VMS.
> double click "My Computer " on Winders.
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse@(protected) QuadTech, Sussex, WI USA
>
>
> -- --Original Message-- --
> From: Niall Litchfield [mailto:n-litchfield@(protected)]
> Sent: Wednesday, February 11, 2004 8:31 AM
> To: oracle-l@(protected)
> Subject: RE: RE: LMT ASSM & next extent
>
>
> How do you tell how full the file system is?
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> 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
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
>
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
