PAM V2 - PIPER-Rx Application Monitor Content
   Home | Services | PAM | Tips | Papers | Reports | Links | About Us | Contact Us | Disclaimer | Privacy   

PIPER-Rx - Home of the Oracle E-Business Suite Resource Centre
Australasia

PAM - PIPER- Rx Application Monitor - PAM Tutorials
PAM - "Blurring the line between software product and training"


   Home
   Tutorial 1 | Tutorial 2 | Tutorial 3 | Tutorial 4 | Tutorial 5 | Tutorial 6 | Tutorial 7 | Tutorial 8 | Tutorial 9 | Tutorial 10 | Tutorial 11 | Tutorial 12 | Tutorial 13 | Tutorial 14 | Tutorial 15 | Disclaimer   

TUTORIAL PRECIS
Tutorial 1:

Your OEBS Application - an introspective

Monitored items:

Basic application usage profiling

The best OEBS system administrators intimately know and understand what is going on in their application on a daily basis and throughout the business cycle. For all the key factors that have the potential to impact performance and system health they know the answers. Eg:

  • How many concurrent requests do you run per day how does this change with business peaks?
  • Has the overall activity been increasing or decreasing over time
  • What are the max concurrent users connected and when
  • How hard are the web servers being hit
  • All these questions and more will be answered in this tutorial; we will also show you how to use this information, including how to produce a monthly report on your OEBS application's monthly activity (A pro forma and example monthly report with guidelines are included in the pack)

    Note: The PAM collector will populate up to 31 days prior activity so you will have useful information straight away

    Tutorial 2:

    Surviving performance pressure (business peaks survival tips)

    Monitored items:

    Performance profiling, managing workflow background processes

    The skilled applications administrator understands the OEBS application’s performance profile and then develops strategies to manage it. In this tutorial you will learn…

  • What is your application performance profile and how does it vary over time
  • How is your application performance profile affected by cyclical business peaks
  • How to know immediately if a performance issue is application related.
  • Workflow background processes can tie your system in knots if you let them - Do you have too many running?
  • How to get data for response time SLAs that means something to the business
  • Tutorial 3:

    Entropy antidotes (maintenance must haves for the more technically inclined)

    Monitored items:

    Index rebuild alert, New invalid objects

    PAM is not database monitor (there are too many good Oracle database monitoring tools in the market already) but there are a couple of database related issues that are of interest to the systems administrator

    In this tutorial PAM alerts are installed to notify you about:

  • Matters that may affect the normal running of your application
  • Normal database maintenance tasks that are often forgotten
  • Tutorial 4:

    What to do when the sh#! hits the fan...

    Unless you did something you’re not supposed to, it’s actually not your fault if there is an issue. This tutorial provides tools to use when things do go wrong so you can understand the scale of impact and proactively manage the fallout. You can answer questions such as:

  • Who was doing what?
  • Who was affected by the issue
  • Were any on line external customers impacted?
  • Tutorial 5:

    Cunningly clairvoyant
    (Am I having a bad day?)

    Monitored items:

    Concurrent request activity, Maintenance mode alert

    The alerts in this tutorial help you get ahead of those business complaints by letting you know about those typical things that go wrong as and when they occur. This will enable you to get ahead on any related issues enabling you to proactively manage your OEBS application and its user community. Items covered include:

  • Error requests
  • Total requests
  • Warning requests
  • Maintenance mode
  • ICM down
  • Tutorial 6:

    What lurks beneath...

    Monitored items:

    Workflow activity

    Workflow is typically the most poorly managed aspect of the OEBS application resulting in significant wasted resources both human and machine. This tutorial gives you the vital information you need to help improve workflow management and performance.

    Tutorial 7:

    Tools to manage user behaviour through fear and guilt (I know what you did and when you did it)

    Monitored items:

    Queue management, duplicate and long running requests

    Every systems administrator knows this story…. after many conversations your users know what buggers up the system but they continue to do it anyway, and usually at the busiest times like month end. This tutorial shows you how to seek out the guilty…

    Tutorial 8:

    Basic Security Salvos

    Monitored items:

    Aged User Accounts, Unsuccessful logins, Monitored Accounts

    Good systems administrators keep on top of matters that may be security issues. This tutorial has some basic timely reminders:

  • Have you been removing old employees access?
  • Are there any signs that someone may be maliciously trying to get access to the OEBS application
  • Tutorial 9:

    Basic User Activity

    Monitored items:

    Full Service sesions, Self service sessions, Self service Page requests

    Each application user connection require application resources, often organisations are in a position where resources including web services (in the case of self service session) are limited and we know that once we exceed the certain number of connected users the overall application slows down and all users experience degradation in performance. This tutorial also delves into user activity profiling

    Tutorial 10:

    Monitoring Database Session Statistics

    Monitored items:

    One or more of the 240+ database session statistics

    There can be a high correlation between some sessions stat levels and performance slow downs so these are the session stats the expert administrator likes to keep an eye on. In this tutorial we will show how PAM:

  • Monitors and records databases session statistics information
  • Alerts when database session statistics exceed threshold values
  • Reports on session statistic activity
  • The final part of this tutorial is a PAM alert when patches have been applied to your application.

    Tutorial 11:

    How is your day going (really)?

    Monitored items:

    Detailed intra day Concurrent managers and User activity

    Ever wondered:

  • What is happening in your application when you are not looking?
  • How does your activity profile differ over month end to normal processing times?
  • The information collected with this PAM tutorial / software release will provide invaluable detailed application profiling information.

    Tutorial 12:

    Proficiently psychic (Is bad stuff going on?)

    Monitored items:

    Aged on hold requests, Maintenance program missing

    This tutorial helps you:

  • Ensure your standard maintenance program doesn’t go off the rails
  • Monitor for selected concurrent programs that nave been submitted and or complete with a status of error or warning
  • Identify some of the rubbish you will want to get out of the system
  • Tutorial 13:

    Business bottlenecks busters (or how to make you look good)

    Monitored items:

    Long running workflows , Old active workflows

    We revisit that perennial performance pest Workflow - This tutorial gives you vital information to help manage and clean up workflow

    Tutorial 14:

    On top of the game

    Monitored items:

    Session timeouts, SLA Renegotiation trigger, Setting PAM thresholds

    This tutorial will help you show the business that you are on top of customer related and administrative issues in and about the OEBS application

  • Good systems administrators proactively manage customers. This tutorial gives you plenty of information to help you eg
  • Can you easily discern between your internal and external customers so you can manage the different group properly and professionally?
  • Do you want to know how to tell how who and how many external customers were impacted by a performance problem so you can manage the fall out?
  • Are your customers getting peed off because they are having to continually reconnect to you application?
  • We introduce you to Auto thresholds which continually adjust your PAM alert thresholds as your business changes, these give you great tracking information to tell you what is changing over time and by how much to aid your forward planning.?
  • It is a common misconception that SLAs are predominately about database and system response times when actually this is preferably only a small part and a good SLA should be about so much more. In this tutorial we will look at some trigger points for when you might want to renegotiate your SLAs
  • Tutorial 15:

    Customising PAM

    We show you how to customize PAM so it is even better at meeting your individual needs.

    PAM tutorial content is subject to change without notice.


    Return to Top of page
    Return to Home page


    Use of this site and information available from it is subject to our Legal Notice and Disclaimer and Privacy Statement.

    Oracle®, Oracle Applications® & Oracle E-Business Suite® are registered trademarks of Oracle Corporation
    TOAD® is a registered trademark of Quest Software

    © 2009 - 2011 G Piper
    All Rights Reserved.