Re: Monitoring Oracle RDS
- From: Michael Wehrle <michaelw436@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 14 Dec 2012 10:58:56 -0500
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@xxxxxxxxx>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?
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
