Monitoring Oracle RDS
From: Michael Wehrle <michaelw436_at_gmail.com>
Date: Thu, 13 Dec 2012 10:55:57 -0500
Message-ID: <CAKAtme-jShQB=N7jKwzZ635FiNnS4WXgOEJENFz4Gxrf7XvftA_at_mail.gmail.com>
All, I am working on migrating some oracle databases into Amazon RDS. Is there a good monitoring solution out there for these instances? The provided cloudwatch is minimal, and not useful at all in terms of performance metrics, wait events, top sql, top activity. OEM seems out of the question, since its an agent-based tool, and with RDS you give up access to the server where the db resides. Cloudwatch monitors the following for RDS:
Date: Thu, 13 Dec 2012 10:55:57 -0500
Message-ID: <CAKAtme-jShQB=N7jKwzZ635FiNnS4WXgOEJENFz4Gxrf7XvftA_at_mail.gmail.com>
All, I am working on migrating some oracle databases into Amazon RDS. Is there a good monitoring solution out there for these instances? The provided cloudwatch is minimal, and not useful at all in terms of performance metrics, wait events, top sql, top activity. OEM seems out of the question, since its an agent-based tool, and with RDS you give up access to the server where the db resides. Cloudwatch monitors the following for RDS:
CPU,Storage,Memory,Swap,Connection Count,I/O,Replag
I need to be able to see some more useful stuff. At this point, I only see that I may have to use statspack or something similar to it, but thats all manual work. A GUI for my db customers would be ideal.
Suggestions?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 13 2012 - 16:55:57 CET