473,287 Members | 1,582 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Defragmentation of Oracle 91 files on W2000 server

RAK
A client is testing a system on Oracle 9i and Win 2000 (why not 10g and
2003 etc? dont ask, long story).

Performance was poor. Among other issues, we discovered that the Oracle
datafiles are badly fragmented. This is fragmentation in the Windows sense
of the physical file being all over the disk, not the Oracles internal file
fragmentation.
Each Oracle DB file is typically in several thousand fragments (I have no
idea how it got that bad and finding out would take too long). The defrag
program reports 112 files, 260GB total disk space, and an impressive 234,000
file fragments.

The problem: so far they cannot defragment the Oracle data & index files.

They have just tried to defragment the disk which works for other files not
for the Oracle files (*.ora). They tried using Diskeeper and PerfectDisk
with the same result.
They tried the defragment-at-boot-time options with these programs, i.e. to
do the defrag before oracle starts up and perhaps prevents the ora files
being moved. Still no good.

There is plenty of spare space (36%) on the disks which are NTFS RAID5.

Seems a silly problem, there must be an easy answer....?
I am not an Oracle DBA by the way, but a general consultant looking at this
along with some other issues.

Jul 19 '05 #1
1 5629

"RAK" <ra****@NOSPAMattglobal.net> wrote in message
news:1b******************************@news.teranew s.com...
A client is testing a system on Oracle 9i and Win 2000 (why not 10g and
2003 etc? dont ask, long story).

Performance was poor. Among other issues, we discovered that the Oracle
datafiles are badly fragmented. This is fragmentation in the Windows sense
of the physical file being all over the disk, not the Oracles internal file fragmentation.
Each Oracle DB file is typically in several thousand fragments (I have no
idea how it got that bad and finding out would take too long). The defrag
program reports 112 files, 260GB total disk space, and an impressive 234,000 file fragments.

The problem: so far they cannot defragment the Oracle data & index files.

They have just tried to defragment the disk which works for other files not for the Oracle files (*.ora). They tried using Diskeeper and PerfectDisk
with the same result.
They tried the defragment-at-boot-time options with these programs, i.e. to do the defrag before oracle starts up and perhaps prevents the ora files
being moved. Still no good.

There is plenty of spare space (36%) on the disks which are NTFS RAID5.

Seems a silly problem, there must be an easy answer....?
I am not an Oracle DBA by the way, but a general consultant looking at this along with some other issues.

1. Shutdown the database normally.
2. Backup all the files on the disk.
3. format the drive(s).
4. restore the files to the disk.
5. Startup the database.

I had a similar experience and no amount of defrag stuff would help. I
finally had to format the drive and that wiped out hte fragmented master
boot record and I could have a defragged disk.
Jim
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: | last post by:
I still have no clear idea of Application_OnEnd functioning on w2000 both Pro and Server. I have this sub in my global.asa which is supposed to save Application scope variables to a file. (then...
3
by: Alex | last post by:
I have developed a VB application that uses Oracle 8i database for backend. The database server is on the local network. From my development machine, the application connects (via ODBC) to the...
4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
11
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the...
3
by: Miro | last post by:
Hi! How can I access files on intranet. I have mapped a serverfolder to the drive letter G and try to access a file from ASP.NET, but File.Exists("G:\filename.ext") returns false. The same code...
13
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem....
42
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse...
1
by: megaman1 | last post by:
I’m trying to connect with perl DBD::Oracle on Windows to Oracle DB (Linux). I compiled the Oracle.dll using the commands “perl Makefile.pl” “nmake” and “nmake install”, but when I try to connect...
1
by: RAK | last post by:
A client is testing a system on Oracle 9i and Win 2000 (why not 10g and 2003 etc? dont ask, long story). Performance was poor. Among other issues, we discovered that the Oracle datafiles are...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.