Location: The Official Oracle Wiki

Discussion: Low database performanceReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 1 post

sabalesh
Low database performance
May 30 2008, 5:17 PM EDT | Post edited: 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.)
Free webinar on Oracle BI, hosted by Sierra Atlantic and Oracle Complimentary webinar on AIA, hosted by Sierra Atlantic and Oracle Sierra Atlantic, Inc.
NamedAssemblies Oracle Tweeters Lista Blogów o ORACLE
Getting or Creating queryid for current statement SQLPro start isql plus
Eventos MK Tecnología siebel gadget API Can i send a meeting request in MSN Outlook from Oracle