Tuesday, 18 August 2009

Monitoring Streams through Oracle Enterprise Manager Grid Control (Source database)

My previous post showed how to monitor your Streams environment through the command line. However, since some people prefer a more graphical way to do things, Oracle Enterprise Manager Grid Control can also be used for this (and many other things of course).

This post will show some of the screenshots (note, click on each screen shot for a larger image) relating to Streams in the source database for our set up. We have v10.2.0.5.0 of OEM and of the OEM Agent on both machines.

After logging in and going to the database target you'll see the following screen, the screenshot below shows the Data Movement page of the database target.

As you can see, there is a Streams section on this page - Setup will do exactly that, set up a Streams implementation. Here we will click on Manage Replication to get the following Overview page. Note I've set the Show Data For to 1 day to show some actual information on the graph (this configuration is currently in the test environment and not being heavily used).

By changing the Statistics drop down box to show Throughput (Messages/Sec) you see the following.

Now we click on the Streams link to see the following. It shows the names of the Streams processes (STREAMS_CAPTURE and STREAMS_PROPAGATION in our case as this is the "source" database), both of which are links to further related information. Also note the Related Links at the bottom - they will take you to different areas in Grid Control to manage your Streams implementation.

Clicking on the STREAMS_CAPTURE link shows the following information about this process, shown here.

While clicking on the STREAMS_PROPAGATION link shows this.

Finally the Topology link shows a graphical display of the topology of your Streams implementation. Unfortunately this does not work in Firefox as it uses the Adobe SVG plugin.

So there you go. A more graphical display for those who like their graphs instead of their numbers (who said managers?!) ;-)

Cheers,

Ian

No comments:

Post a Comment