Re: more 8.1: defrag the drive

On Jan 25, 2: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.

This is miniscule in the Oracle world.

>Coworker has
> a good suggestion that may reduce down time, it sounds good.

Doesn't sound good to me. So, you have a problem with down time? Have you diagnosed *the problem*? Exactly what is causing your down time? While disk fragmentation *may* (or again, may *not*) be a key factor in performance, I've never seen it be a factor in down time -- aside from people deliberately taking the system down to address the "problem."

Exactly what problem are you seeing? (Simply having a lot of fragments is not in itself a problem). Exactly how do you expect defragging to address this problem?

> I'm
> looking for whether or not it's fraught with potential problems.
>

The biggest potential problem I see is that you will have the system down and go through this exercise and not solve your real problem.

> let me know what you think
>

I think you have a tiny database running under an unsupported version of Oracle on an OS that the unsupported version of Oracle was never certified for and you haven't identified (to us, anyway) the problem you are trying to solve.

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

Even if you go through with this exercise, why copy the files back and forth? Do you not trust your defrag utility? If you can't trust it ....

> So, there should not be any problems with the database.
>
> Thanks
Received on Thu Jan 25 2007 - 08:24:56 CST