Re: Reading/Interpreting 11g Statspack reports
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: janine@xxxxxxxxxx
- Date: Tue, 09 Mar 2010 19:47:35 +0100
Janine,
You can try to upload your statspack report here :
http://www.ondatafine.com/
English is a bit strange at times, but it's a good resource, especially
if you upload snapshots taken at regular intervals.
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
Janine Sisk wrote:
> Thanks to all who have replied so far (and if you have something to add,
> please do!).
>
> My thought was that since the nasty query is the same on both sides, and the
> Amazon "server" is far more powerful, that the first place I should look
> would be the way I have 11g configured. It has been *years* since I last did
> a fresh install of Oracle but I do recall that there were various things one
> could change and that statspack was one of the tools to see where the
> bottlenecks are. Is that not the case anymore now that Oracle claims to be
> self-tuning or whatever the latest marketing hooha is? :)
>
> Is this a reasonable approach, or am I just wasting time? I can tune
> individual queries if I have to, but I have to be *very* careful about not
> stepping on toes...
>
> I had forgotten about 10046 traces - I will definitely try that as well.
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
