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

Location: The Official Oracle Wiki

Discussion: Low database performance

Keyword tags: database performance DBA oracle

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.)
Oracle Tweeters REQUIRE ORACLE PORTAL ADMINISTRATOR FOR DUBAI All India Oracle Users Group
Problem wihtn Pracle PDF driver PDF version1.4 Setting Listener Password Apache xBus to Oracle Connection Error
SQLPro OracleDBconsole<sid_name> does not start Installfest Community
Oracle BIWA SIG at OOW and BIWA Summit 2008 at Oracle HQ Installing Oracle on Debian / Kubuntu / Ubuntu Insert using &