Page tree

This appendix includes the following topics:

Report Manager Report sets

Report Manager is a reporting tool that queries the Performance Management Database and displays the results in reports that are generated on a scheduled basis or on demand.

Report Manager provides pre-defined reports divided as follows:

  • Availability
  • Capacity planning
  • Exceptions
  • Load Balancing
  • Profile

Reports of an Tier-level, for example, provide a performance comparison between the various Tiers of your application.

Reports of an Instance-level provide information about the complete instance, that is the whole system, such as Web Server, an Oracle Instance, or a (J2EE) Java Virtual Machine.

Cross-Tiers Reports

Cross-Tier reports contain data for several Tiers, for example, Cross-Tiers Availability report. Application reports are also available for Cross-Tiers reports only.

The Report Manager Cross-Tiers Reports are as follows:

  • Availability
  • Load Balancing
  • Application

Oracle

The following table lists report sets for Oracle.

Table 1 Report sets for Oracle

Report SetReport Name
AvailabilityInstances
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsActions
ExceptionsApplications (Oracle Apps)
ExceptionsFile Systems
ExceptionsFiles
ExceptionsForms (Oracle Apps)
ExceptionsFunctions (SAP R/3)
ExceptionsHost Users
ExceptionsInstances
ExceptionsLogical Volume
ExceptionsMachines
ExceptionsModules
ExceptionsObjects
ExceptionsPhysical Devices
ExceptionsPrograms
ExceptionsRarely Used and Unused Objects
ExceptionsRequests (Oracle Apps)
ExceptionsScreens (SAP R/3)
ExceptionsStatements
ExceptionsStorage Devices
ExceptionsTransactions (SAP R/3)
ExceptionsUsers
ProfileActions
ProfileApplications (Oracle Apps)
ProfileDatabase Size
ProfileFile Systems
ProfileFiles
ProfileForms (Oracle Apps)
ProfileFunctions
ProfileHost Users
ProfileInstance Statistics
ProfileInstances
ProfileLogical Volume
ProfileMachines
ProfileModules
ProfileObjects
ProfilePhysical Devices
ProfilePrograms
ProfileRAC Databases
ProfileRequests (Oracle Apps)
ProfileSchema Changes
ProfileScreens (SAP R/3)
ProfileStatements
ProfileStorage Devices
ProfileTransactions
ProfileUsers

J2EE

The following table lists report sets for J2EE.

Table 2 Report sets for J2EE

Report SetReport Name
AvailabilityJVMs
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsEntry Points
ExceptionsJVMs
ProfileEntry Points
ProfileJVMs

Web

The following table lists report sets for Web.

Table 3 Report sets for Web

Report SetReport Name
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsInstances
ExceptionsLocations
ExceptionsTransactions
ExceptionsUsers
ProfileInstances
ProfileLocations
ProfileTransactions
ProfileUsers

Microsoft .NET

The following table lists report sets for Microsoft .NET.

Table 4 Report sets for Microsoft .NET

Report SetReport Name
AvailabilityCLRs
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsEntry Points
ExceptionsCLRs
ProfileEntry Points
ProfileCLRs

SQL Server

The following table lists report sets for the SQL Server.

Table 5 Report sets for SQL Server

Report SetReport Name
AvailabilityDatabases
AvailabilityInstances
AvailabilityOverview
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsAd-Hoc Batches
ExceptionsApplications (COM+)
ExceptionsClient Machines (PeopleSoft)
ExceptionsComponents (COM+)
ExceptionsDatabases
ExceptionsDB Files
ExceptionsInstances
ExceptionsLogins
ExceptionsMachines
ExceptionsMethods (COM+)
ExceptionsObjects
ExceptionsPhysical Disks
ExceptionsPrograms
ExceptionsRarely Used and Unused Objects
ExceptionsSiebel Views
ExceptionsStatements
ExceptionsStorage Devices
ExceptionsStored Procedures
ExceptionsTransactions (SAP)
ExceptionsUser IDs (PeopleSoft)
ExceptionsUsers
ExceptionsWork Types
ProfileAd-Hoc Batches
ProfileApplications (COM+)
ProfileClient Machines (PeopleSoft)
ProfileComponents (COM+)
ProfileDatabase Definition Changes
ProfileDatabase Size
ProfileDatabases
ProfileDB Files
ProfileInstance Statistics
ProfileInstances
ProfileLogins
ProfileMachines
ProfileMethods (COM+)
ProfileObjects
ProfilePhysical Disks
ProfilePrograms
ProfileSchema Changes
ProfileSiebel Views
ProfileStatements
ProfileStorage Devices
ProfileStored Procedures
ProfileTransactions (SAP)
ProfileUnnecessary Indexes
ProfileUser IDs (PeopleSoft)
ProfileUsers
ProfileWork Types

SAP

The following table lists report sets for SAP Systems.

Table 6 Report sets for SAP Systems

Report SetReport Name
AvailabilityApplication Servers
AvailabilityLocales
AvailabilityOrganizations
AvailabilityOverview
AvailabilitySystems
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsApplication Servers
ExceptionsApplications
ExceptionsLocales
ExceptionsOrganizations
ExceptionsSystems
ExceptionsTransactions
ExceptionsUsers
ProfileApplication Servers
ProfileApplications
ProfileLocales
ProfileOrganizations
ProfileResponse Time
ProfileSystems
ProfileTransactions
ProfileUsers

Sybase

The following table lists report sets for Sybase.

Table 7 Report sets for Sybase

Report SetReport Name
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsAd Hoc Batches
ExceptionsDatabase Devices
ExceptionsDatabases
ExceptionsInstances
ExceptionsLogins
ExceptionsMachines
ExceptionsPrograms
ExceptionsStatements
ExceptionsStored Procedures
ExceptionsUsers
ProfileAd Hoc Batches
ProfileDatabase Devices
ProfileDatabase Size
ProfileDatabases
ProfileInstances
ProfileLogins
ProfileMachines
ProfilePrograms
ProfileStatements
ProfileStored Procedures
ProfileUsers

Tuxedo

The following table lists report sets for Tuxedo.

Table 8 Report sets for Tuxedo

Report SetReport Name
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsClient IPs
ExceptionsInstances
ExceptionsServer Processes
ExceptionsServices
ExceptionsUsers
ProfileClient IPs
ProfileInstances
ProfileServer Processes
ProfileServices
ProfileUsers

WebSphere MQ

The following table lists report sets for WebSphere MQ

Table 9 Report sets for WebSphere MQ

Report SetReport Name
AvailabilityInstances
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsInstances
ExceptionsQueues
ExceptionsReader Applications
ExceptionsUsers
ExceptionsWriter Applications
ProfileInstances
ProfileQueues
ProfileReader Applications
ProfileUsers
ProfileWriter Applications

Oracle Applications

The following table lists report sets for Oracle Applications.

Table 10 Report sets for Oracle Applications

Report SetReport Name
AvailabilityInstances
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsApplications
ExceptionsClient IPs
ExceptionsForms
ExceptionsInstances
ExceptionsLocations
ExceptionsUsers
ProfileApplications
ProfileClient IPs
ProfileForms
ProfileInstances
ProfileLocations
ProfileUsers

OS

The following table lists report sets for OS (Operating System).

Table 11 Report sets for OS

Report SetReport Name
Load BalancingOS counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsCommands
ExceptionsPrograms
ExceptionsServers
ExceptionsUsers
ProfileCommands
ProfilePrograms
ProfileServers
ProfileUsers

EMC Storage

The following table lists report sets for EMC Storage.

Table 12 Report sets for EMC Storage

Report SetReport Name
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsDevices
ExceptionsFront End Directors
ExceptionsUnits
ProfileDevices
ProfileFront End Directors
ProfileUnits

Citrix

The following table lists report sets for Citrix Servers.

Table 13 Report sets for Citrix Servers

Report SetReport Name
ExceptionsCitrix Locations
ExceptionsCitrix Users
ExceptionsClient IPs
ProfilePublished Applications
ProfileCitrix Locations
ProfileCitrix Users
ProfileClient IPs
ProfilePublished Applications

DB2

The following table lists report sets for DB2 Servers.

Table 14 Report sets for DB2 Servers

Report SetReport Name
ProfileDatabase Partitions
ProfilePrograms
ProfileStatements
ProfileMachines
ProfileModules
ProfileActions
ProfileOS Users
ProfileDB Users
ProfileWork Types
ExceptionDatabase Partitions
ExceptionPrograms
ExceptionStatements
ExceptionMachines
ExceptionModules
ExceptionActions
ExceptionOS Users
ExceptionDB Users
ExceptionWork Types