RE: RE: LMT ASSM & next extent

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 11 Feb 2004 16:27:29 -0000
Message-ID: <CFECD6EA683C524BB5FD22C0F1F34ACB06B110@bristol43.audit-commission.gov.uk>

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


> "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.

>=20

> Rich

>=20


> Rich Jesse                        System/Database Administrator

> rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

>=20
>=20

> -----Original Message-----
> From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]
> Sent: Wednesday, February 11, 2004 8:31 AM
> To: oracle-l_at_freelists.org
> Subject: RE: RE: LMT ASSM & next extent

>=20
>=20

> 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_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
> -----------------------------------------------------------------
>=20
>=20

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_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 - 10:27:29 CST