-
LOW DATABASE PERFORMANCE! Help required
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.
RegardsSabalesh Mahajan
-
-
Concurrency? how many users on UAT?... how many users on PROD?
Compare top ten wait events on both UAT vs. PROD, that might point you in the right direction.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
well user sessions are equal on UAT and PROD server while i have executed my processing.
we donot release servers when night activities are on.
RegardsSabalesh Mahajan
-
and what does statspack / awr say?
-
Database spill rate is high...
how to decrease that????
RegardsSabalesh Mahajan
-
spill rate - what the hell is that
Last edited by davey23uk; 06-01-2008 at 11:58 AM.
-
my production database performance is exact the half but hardware config is high SMT is enabled on production and is disabled on TESTING UAT.
Are you the first guy using the SMT ?
-
Ok, My prod system is streams detonated system. and spills are related to streams (AQ).
RegardsSabalesh Mahajan
-
streams detonated system ?
Did the database explode ?
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|