Blog Aggregator - Amardeep Sidhu

Now that we have completed our discussion on the 10G EM Advisors, let’s take an in-depth look at the performance statistics capturing and reporting capabilities provided by 10G EM. Oracle 10G captures performance statistics on a periodic basis and stores the data in the Automatic Workload Repository. The individual statistic capture executions are called AWR Snapshots.

We’ll begin our discussion with a review of the 10G AWR snapshot environment. In a series of upcoming blogs will learn how to use AWR Snapshots to generate performance reports, compare two sets of performance statistics to one another, compare a captured set of statistics to a baseline and finally, how to preserve snapshot sets for future diagnostic use. When we are done with this series, you’ll be saying “Statspack, who needs THAT tired old tool anymore?”

We continue our discussion on the 10G Grid Control advisors. In this blog, I’ll provide you with a brief review of Automatic Undo Management in Oracle 10G. I’ll continue the discussion by showing you how to use the 10G Grid Control Automatic Undo Advisor to determine how much space you will need in your undo tablespace for a specified undo retention time period.

Before we return to our series of blogs on 10G EM features and functionality, I think it is important for us to discuss the 10G Enterprise Manager Standalone Java Console. Previous blogs have contained information on troubleshooting 10G EM management server to agent communications. But what happens if the entire environment goes down and you still want to use a GUI version of the tool? In addition, the management server version of 10G EM currently does not provide the capability of administering some of Oracle’s advanced features such as streams, advanced queuing, etc..

This blog will show you how to install and configure the 10G Enterprise Manager Standalone Java Console. We’ll also compare and contrast the Java Console to its big brother that uses the management server and repository.

Before we return to our regularly scheduled 10G EM topics, I’d like to provide you with my opinions on Tom Kyte’s latest book.

This is the final blog of a three part series on troubleshooting 10G Grid Control agent to management server communication issues. I’ll start the discussion by summarizing a few key points from the previous two blogs.


I’ll also provide a few hints that will help you determine where to start the debugging process (management server or agent). I’ll complete this series by showing you how to activate detailed tracing on the agent and management server components. If you can’t identify the problem by analyzing error messages normally generated by the agents and management server, you’ll have to activate more detailed traces to gather additional diagnostic data.