Re: Strange Oracle behavior between different environments
Date: Fri, 19 Aug 2011 14:47:13 -0700 (PDT)
Message-ID: <fd053b76-04ca-4765-a2cb-95766385dbf1_at_r12g2000vbe.googlegroups.com>
Alex:
First nothing is better than a real problem to start learning. If you are fairly new to Oracle then a couple of things to point out in terms of resources and knowledge base.
Along with the Oracle ( pretty good and free documentation ) there are a couple of essential books to help in expand your knowledge base.
Probably first in the regard to systematic trouble shooting is Cary Millsap's book "Optimizing Oracle Performance". Along with that book the most recent one by Tom Kyte in the Architecture series and Christian Antognini book "Troubleshooting Oracle Performance". Jonathan Lewis has an excellent book on the Oracle Optimizer also highly recommended.
# I don't believe there is a significant difference in parameters, but
I didn't set them up, and I discovered this morning that the Solaris
system is 10.1.0.5 and the Windows system is 10.2.0.1. So there could
be more differences than I thought.
...
Seriously??? 10.1 was just a really buggy early version of 10g. You don't want to be running 10.1 at all.
10.2.0.1 is the base release of 10.2 not patched up at all.
Both of those versions are seriously behind the curve and I would not do any serious investigation of problems on either of those.
Is there any reason they are not patched up appropriately?
If so then do that prior to spending any more valuable time chasing problems.
# Is it possible the different versions could be responsible for the
different performance?
...
Does a bear poop in the woods?
# Sorry for the lack of specifics, kinda new to Oracle, and I was
mainly looking for directions to go in for troubleshooting and
gathering more specific data.
...
Hey no problems we beat people up until they give us the information we are looking for. Received on Fri Aug 19 2011 - 16:47:13 CDT