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 5691
"RAK" <ra****@NOSPAMa ttglobal.net> wrote in message
news:1b******** *************** *******@news.te ranews.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 Application_OnStart will restore theses variables
from the file)
It worked fine on local w98/PWS and on ISP NT4-Server/IIS4
To initiate Application_OnEnd and Application_OnStart for test purposes it
was sufficient to re-upload global.asa
|
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 database successfully. The
problem is that I want to install this application on several Windows 2000
client machines that do not have Oracle client installed (hence missing all
the ODBC connectivity support files/drivers). What is the minimum...
|
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
|
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 Ford
Fairlane. I need this info to complete a school project. Thanks.
|
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 in Windows Forms returns
true, so I guess it has something to do with the
permissions. I set all rights to the IUSR_machinename.
This is enough to make it work locally on C: but not on G:
| |
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. Using the exact same code (copy
and paste) into a Web app I get the following error "Error while trying to
retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
|
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 Management System which wil
manage our very large inventory.
Anyway comments suggestions welcome
Thanks
Paul
|
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 to the DB, I get the following runtime error:
“R6034 an application has made an attempt to load the C Runtime library incorrectly.
Please contact the applications’ support team for more information.”
I suspect that I mixed the versions of VC...
|
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 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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |