Home » RDBMS Server » Server Administration » oracle 9i low performance on hp9000 server
oracle 9i low performance on hp9000 server [message #59678] Mon, 15 December 2003 20:26 Go to next message
Ahmed
Messages: 36
Registered: November 2000
Member
I have a performance problem when we use a HP 9000 server, and install oracle server database 9i for HP-UX the system is very slow.
We have the same database on Sun Sparc, Solaris OS, and it works well

Report message to a moderator

Re: oracle 9i low performance on hp9000 server [message #59682 is a reply to message #59678] Tue, 16 December 2003 02:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
mainly depends on the UNIX semaphore settings and Unix tuning, hardware and disk layouts

Report message to a moderator

Re: oracle 9i low performance on hp9000 server [message #59687 is a reply to message #59678] Tue, 16 December 2003 04:03 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Ahmed,
the information you provided is not sufficient enough to diagnose. When you copied the database( through exp/imp ) from Sun->HP, was the block size changed ? Filesystem/Kernel page cache/Raw devices changed ? Number of disk spindles/RAID level/stripe changed ?
Init.ora parameters changed ?
Semaphores/Shared memory/max_io size changed ?
CPU (number,speed)/Virtual memory changed ?
Network architecture/interface capabilities changed ?
etc etc.. there are so many variables.

-Thiru

Report message to a moderator

Previous Topic: Re: Query regarding Tuning
Next Topic: restore database in different file system
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:30:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.