Re: Performance problems after moving to new hardware
Date: Tue, 17 Mar 2015 19:45:03 +0100 (CET)
Message-ID: <296405377.30141.1426617903583.JavaMail.open-xchange_at_app01.ox.hosteurope.de>
Hi Sandra,
i remember your issue and my latest reply. This is a bad (Oracle) support situation and even worst that you had to revert to the old hardware.
However did you verify the mentioned service time (= storage wait) and host wait time? And if yes - did you DTrace the issue as suggested? What were the results? I think there is some way to find the issue with DTrace (even without Oracle support) based on your description and AWR data.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: _at_OracleSK
> Sandra Becker <sbecker6925_at_gmail.com> hat am 17. März 2015 um 17:34 geschrieben:
>
> After asking for the same reports 3 times, oracle support came back and asked if we were sure the SQL in the AWR and ADDM were from the
> application. Took a lot of doing, and a call to the escalation manager, but we finally were able to get a Solaris engineer involved to help us
> troubleshoot the hardware. Very annoyed that they agreed to have someone on a conference call yesterday and that person decided not to call in
> because he didn't think it was a hardware issue. No explanations, just he didn't think it was hardware. We switched the primary back to the old
> hardware since the database was basically unusable for the application users.
>
> Sandy
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 17 2015 - 19:45:03 CET