Home » RDBMS Server » Performance Tuning » Slow Import on x64 (10g, 10.2.0.3, Windows 2003 x64 Std)
Slow Import on x64 [message #384962] Thu, 05 February 2009 22:53 Go to next message
dedythea
Messages: 4
Registered: January 2009
Location: Tokyo
Junior Member

I have two identical servers.
ML370G3, XEON 3.0Ghz 2Cores, 4GB RAM, 146GB SCSI x 6 (in RAID 1+0).
Server1 loaded with Windows 2003 STD x86.
Server2 loaded with Windows 2003 STD x64.
The Oracle on Server2 also on x64 version.
All Oracle instance have same patch, (10.2.0.3 p28).
Oracle binaries were installed using same source.
Using a same source of dump file (also same import script) to import into both servers above, it gave me very significant time different.
On Server1, it tokes like 1H, while on Server to over 2H.
INIT.ORA are the same on both servers.
So everything exactly the same. the only different is OS/DB type, one is 32bit (x86) and another one is 64bit (x64).
Please advice.
Thank you.
Dedy
Re: Slow Import on x64 [message #385059 is a reply to message #384962] Fri, 06 February 2009 05:39 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Was the load on the two servers the same when the imports were being run?
How many other people were using the databases at the time?
Re: Slow Import on x64 [message #385216 is a reply to message #385059] Sat, 07 February 2009 19:25 Go to previous message
dedythea
Messages: 4
Registered: January 2009
Location: Tokyo
Junior Member

Yes, the load almost the same.
Nobody connecting to database.
Previous Topic: update query tuning
Next Topic: Perfomence Tuning
Goto Forum:
  


Current Time: Thu Dec 08 12:50:31 CST 2016

Total time taken to generate the page: 0.10217 seconds