Welcome! This is a website that everyone can build together. It's easy!

Location: The Official Oracle Wiki

Discussion: Low database performance


Watch

Anonymous  (Get credit for your thread)


sabalesh

sabalesh
Low database performance
May 30 2008, 5:17 PM EDT
Hi, can any body help me to improve database performance. I am getting high performance on Testing server but on production it degrades to half.

Production Server
OS: AIX 5.1L on IBM Power6 Server, 32GB RAm, 6 Physical Processors
ORACLE: 10G

Testing UAT Server
OS: AIX 5.1L on IBM Power5 Server, 16GB RAM, 4 Physical Processors
ORACLE: 10G


ORACLE database is same. same size, same pfile,same disk sizes.

hdisk(n) are copied on testing server

my production database performance is exact the half but hardware config is high SMT is enabled on production and is disabled on TESTING UAT.
4  out of 5 found this valuable. Do you?    

Sign in to be the first to reply.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)