Oracle-L: RE: OS Level Defrag

From: Sujatha Madan <Sujatha.Madan_at_optus.net.au>
Date: Sun, 30 Nov 2003 13:49:25 -0800
Message-ID: <F001.005D83F8.20031130134925@fatcity.com>

Thanks to all that replied.

Fortunately, I have a good backup of the corrupted partition. Unfortunately, estimated recovery time will be 4 days.

-----Original Message-----
DENNIS WILLIAMS
Sent: Saturday, 29 November 2003 7:54 AM To: Multiple recipients of list ORACLE-L

Sujatha - If it helps, we have Tru64 and 8.1.6 here. My sys admin has defragged the disk quite a few times with no apparent ill effects.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, November 27, 2003 7:59 PM To: Multiple recipients of list 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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sujatha Madan
INET: Sujatha.Madan_at_optus.net.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------