LMT ASSM & next extent 2004-02-11 - By Niall Litchfield
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
