Sorry can't help with the "when did it happened" question.
But in defense of the SysAdmin, I have seen the benefits of defraging on
both Unix and NT.
In the NT case the defraging was caused by lots of small fragments caused
by the datafile being auto extended in short increments, and that being
mixed on the same file system with other file updates/additions/deletes.
In the Unix case, I was doing a lot of restores to a testing system. When
I did the restores I had 5 or 6 uncompress commands outputting to the same
/u mount point. After doing this my wio times when through the roof. On
the next restore I restricted my restore to one uncompress at a time to
each of my /u mount points ... the wio problem went away.
The last point I'd like to make is "trust no one" with your data. Always
sum and/or cksum files before and after moving them around (there are gnu
versions of these commands for non Unix systems). And 3 last words -
backup backup backup.
"Sujatha Madan"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
tus.net.au> cc:
Sent by: Subject: OS Level Defrag
[EMAIL PROTECTED]
.com
11/27/2003 06:59
PM
Please respond to
ORACLE-L
Hi,
Does anyone here do an O/S level defrag of their Oracle filesystems???
Background: (Tru64/8.1.7.4)
Sysadmin here were adamant that the Oracle domains were running out of
extents and were highly fragmented (O/S level). DBA was adamant that the
Oracle filesystems should not be defragmented. I lost the battle and the
sysadmins are defragging the domains.
I now have a corruption on a table partition with 100 million plus rows on
a 50G datafile. I am wondering if the defrag has caused this corruption.
The only way I can think of finding out is:
Finding the approx date of the corruption using the query
SELECT ROWID, <LAST_COLUMN_OF_TABLE> from <TABLE_NAME(PARTITION)>;
(which will do the full tablescan row by row).
And then finding when the defrag utility was hitting the particular
datafile that is corrupted.
But this reasoning is flawed ....
Does anyone have another method of trying to pinpoint if the O/S defrag
caused the corruption????
Regards,
Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
