ETPM Environment Health Monitoring Tools

This post is to provide some useful information about the tools typically used by Oracle ETPM implementations for performance tuning and analysis.   This includes tools to monitor and gather performance information and statistics on the Database, Application Server, and Client (browser). 

Enterprise Monitoring Tools

  1. Oracle Enterprise Manager - OEM Grid Control comes with a comprehensive set of performance and health metrics that allow monitoring of key components in your environment such as applications, application servers, databases, as well as the back-end components on which they rely, such as hosts, operating systems and storage.

Tools for the Database

  1. Oracle Diagnostics Pack
    • Automatic Workload Repository (AWR)  - this tool gets statistics from memory abut the Time Model or DB Time, Wait Events, Active Session History and High Load SWL queries
    • Automatic Database Diagnostic Monitor (ADDM) - This self-diagnostic software is built into the database.  It examines and analyzes data captured in AWR to dertermine possible performance issues.  It locates the root cause of the issue, provides recommendations for correcting the issues and qualifies the expected benefit.
  2. Oracle Database Tuning Pack
    • SQL Tuning Advisor - This enables you to submit one or more SQL statements as input and receive output in the form of specific advice or recommendations on how to tune statements.  The recommendation relates to collection of statistics on objects, creation on new indexes and restructuring of SQL statements.
    • SQL Access Advisor - This enables you to optimize data access paths of SQL queries by recommending a proper set of materialized views, indexes and partitions for a given SQL workload.

Tools for the Application Server

  1. Weblogic Console - is a web-based, user interface used to configure and control a set of WebLogic servers or clusters (i.e. a "domain").  In any logical group of WebLogic servers there must exist one admin server, which hosts the WebLogic Admin console application and manages the associated configuratoin files.
    • WebLogic Administrators will use the Administration Console for a number of tasks, including:

      • Starting and stopping WebLogic servers or entire clusters.

      • Configuring server parameters, security, database connections and deployed applications.

      • Viewing server status, health and metrics.

  2. Yourkit for Profiling - helps analyze synchronization issues, including:
    • Which threads were calling wait(), and for how long
    • Which threads were blocked on attempt to acquire a monitor held by another thread (synchronized methods/blocks), and for how long

Tools for the Client

  1. Fiddler - allows you to inspect traffic logs, debug and set breakpoints.
  2. Firebug – allows you to inspect and edit HTML, monitor network activity and debug JavaScript
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

This blog is for our Oracle Public Sector Revenue Management customers, delivery partners, and even our fellow Oracle professionals, and is dedicated to all things Oracle Tax and Revenue Management. We will focus on support and implementation tips, announcements, and FAQs (frequently asked questions) for all of our Oracle Public Sector Revenue Management products. This include Oracle Public Sector Revenue Management (PSRM), Oracle Tax Analytics, and our Oracle PSRM Self Service and integration products.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
3
4
5
6
7
9
11
12
13
14
15
16
17
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today