Re: Monitoring Oracle RDS
Date: Fri, 14 Dec 2012 10:58:56 -0500
Message-ID: <CAKAtme-TRLHYLxxB87GyHv+YViSXJ+9ca1CqBs5KZXBY0B8Z3A_at_mail.gmail.com>
So, it looks like OEM is available, either inside of RDS, or outside using a plugin, but it requires the diagnostics pack to be of any use, which requires at least SE for AWR functionality. I need to clarify that this RDS instance is a "License Included" SE1 instance, so AWR isn't even turned on. At this point, I am looking for a solution that doesn't require AWR, and possibly mimics it. So are there any agent-less monitoring tools out there that does this? I know of Tanel's Session Snapper script, but I would have to build some mechanism around it to make my own AWR of sorts, since its an ad-hoc tool.
On Thu, Dec 13, 2012 at 10:55 AM, Michael Wehrle <michaelw436_at_gmail.com>wrote:
> 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 Fri Dec 14 2012 - 16:58:56 CET