Re: more 8.1: defrag the drive

On Jan 25, 3:27 am, "mmccaws2" <mmcc..._at_comcast.net> wrote:
> The drive where the 8.1 Oracle database files reside is about 70% full,
> about 5GB drive. The disk analysis shows that there is over 40k
> fragments on the drive. One of the tables is about 2Gb. Coworker has
> a good suggestion that may reduce down time, it sounds good. I'm
> looking for whether or not it's fraught with potential problems.
>
> let me know what you think
>
> 1st - shut down app and stop Oracle
> 2nd - copy two largest files(combined about 3Gb) to another drive.
> 3rd - (on Windows 2000 server) defrag drive using windows defrag
> 4th - copy two files back to drive
> and at last restart oracle and app
>
> So, there should not be any problems with the database.
>
> Thanks

If it were me, I would search for the listener log. You will likely find that the listener log is quite a large file, yet started life as a very small file. As the file grew in size, it became severely fragmented. To see if this file is the source of most of the 40,000 fragments on the drive, shut down the listener when few people are using the system (hint: search for LSNRCTL in the documentation), and copy the listener log file to another drive. After the file is copied, delete it from its original location. If you then copy the listener log file back to its original location, the file will be defragmented automatically, assuming that there is a large enough area of adjacent free space on the drive and the drive is formatted with NTFS. After the file is copied back, restart the listener. Note: you do not _need_ to copy the listener log file back to its original location, as a new file will be automatically created.

After fixing the listener log file, you should see the number of file fragments drop considerably. If the number of file fragments still appears to be a problem (and no users are connected to the databases AND you have a good backup), connect to each database using SQLPLUS and execute SHUTDOWN IMMEDIATE; Once each database is down, shut down the listener, and all Oracle related services in the Control Panel Services applet. Copy (do not cut and paste) the Oracle related folders to another drive. Once copied, verify that the files have been moved, then delete the Oracle related folders from their original locations. Then copy the Oracle related folders from the other drive back to their original locations. Once complete, restart the server (easier to explain and accomplish than restarting all Oracle related items).

No defrag is needed in the above approach. The only operation with risk is the copy of the Oracle related files to another drive, followed by a deleted.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Jan 26 2007 - 04:23:33 CST