Enterprise PeopleTools 8.49 PeopleBook: PeopleSoft Performance Monitor

1y ago
3 Views
1 Downloads
2.45 MB
280 Pages
Last View : 1m ago
Last Download : 3m ago
Upload by : Giovanna Wyche
Transcription

Enterprise PeopleTools 8.49PeopleBook: PeopleSoftPerformance MonitorMarch 2007

Enterprise PeopleTools 8.49 PeopleBook: PeopleSoft Performance MonitorSKU PT849PFM-B 0307Copyright 1988-2007, Oracle. All rights reserved.The Programs (which include both the software and documentation) contain proprietary information; they areprovided under a license agreement containing restrictions on use and disclosure and are also protected by copyright,patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of thePrograms, except to the extent required to obtain interoperability with other independently created software or asspecified by law, is prohibited.The information contained in this document is subject to change without notice. If you find any problems in thedocumentation, please report them to us in writing. This document is not warranted to be error-free. Except as maybe expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced ortransmitted in any form or by any means, electronic or mechanical, for any purpose.If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf ofthe United States Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSPrograms, software, databases, and related documentation and technical data delivered to U.S. Governmentcustomers are “commercial computer software” or “commercial technical data” pursuant to the applicable FederalAcquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure,modification, and adaptation of the Programs, including documentation and technical data, shall be subject tothe licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, theadditional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987).Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerousapplications. It shall be the licensee’s responsibility to take all appropriate fail-safe, backup, redundancy and othermeasures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaimliability for any damages caused by such use of the Programs.The Programs may provide links to Web sites and access to content, products, and services from third parties.Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risksassociated with the use of such content. If you choose to purchase any products or services from a third party, therelationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-partyproducts or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery ofproducts or services and warranty obligations related to purchased products or services. Oracle is not responsible forany loss or damage of any sort that you may incur from dealing with any third party.Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates.Other names may be trademarks of their respective owners.Open Source DisclosureOracle takes no responsibility for its use or distribution of any open source or shareware software or documentationand disclaims any and all liability or damages resulting from use of said software or documentation. The followingopen source software may be used in Oracle’s PeopleSoft products and the following disclaimers are provided.Apache Software FoundationThis product includes software developed by the Apache Software Foundation (http://www.apache.org/). Copyright 2000-2003. The Apache Software Foundation. All rights reserved. Licensed under the Apache License, Version2.0 (the “License”); you may not use this file except in compliance with the License. You may obtain a copy of theLicense at http://www.apache.org/licenses/LICENSE-2.0.Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an“AS IS” BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See theLicense for the specific language governing permissions and limitations under the License.OpenSSLCopyright 1998-2005 The OpenSSL Project. All rights reserved.

This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit(http://www.openssl.org/).THIS SOFTWARE IS PROVIDED BY THE OpenSSL PROJECT “AS IS” AND ANY EXPRESSED ORIMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OFMERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENTSHALL THE OpenSSL PROJECT OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOTLIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, ORPROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITYOF SUCH DAMAGE.Loki LibraryCopyright 2001 by Andrei Alexandrescu. This code accompanies the book: Alexandrescu, Andrei. “Modern C Design: Generic Programming and Design Patterns Applied”. Copyright 2001 Addison-Wesley. Permission touse, copy, modify, distribute and sell this software for any purpose is hereby granted without fee, provided that theabove copyright notice appear in all copies and that both that copyright notice and this permission notice appear insupporting documentation.Helma ProjectCopyright 1999-2004 Helma Project. All rights reserved. THIS SOFTWARE IS PROVIDED “AS IS”AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THEIMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE AREDISCLAIMED. IN NO EVENT SHALL THE HELMA PROJECT OR ITS CONTRIBUTORS BE LIABLE FORANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ONANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDINGNEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IFADVISED OF THE POSSIBILITY OF SUCH DAMAGE.Helma includes third party software released under different specific license terms. See the licenses directory in theHelma distribution for a list of these license.SarissaCopyright 2004 Manos Batsis.This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser GeneralPublic License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option)any later version.This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even theimplied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU LesserGeneral Public License for more details.You should have received a copy of the GNU Lesser General Public License along with this library; if not, write tothe Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.ICUICU License - ICU 1.8.1 and later COPYRIGHT AND PERMISSION NOTICE Copyright 1995-2003International Business Machines Corporation and others. All rights reserved.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associateddocumentation files (the “Software”), to deal in the Software without restriction, including without limitation therights to use, copy, modify, merge, publish, distribute, and/or sell copies of the Software, and to permit personsto whom the Software is furnished to do so, provided that the above copyright notice(s) and this permissionnotice appear in all copies of the Software and that both the above copyright notice(s) and this permission noticeappear in supporting documentation. THE SOFTWARE IS PROVIDED “AS IS,” WITHOUT WARRANTYOF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OFMERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRDPARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THISNOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES,OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER INAN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR INCONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. Except as contained in this notice,the name of a copyright holder shall not be used in advertising or otherwise to promote the sale, use or other dealingsin this Software without prior written authorization of the copyright holder.All trademarks and registered trademarks mentioned herein are the property of their respective owners.Sun’s JAXB Implementation – JDSDK 1.5 relaxngDatatype.jar 1.0 LicenseCopyright 2001, Thai Open Source Software Center Ltd, Sun Microsystems. All rights reserved.THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS “ASIS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THEIMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSEARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE FORANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ONANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDINGNEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IFADVISED OF THE POSSIBILITY OF SUCH DAMAGE.W3C IPR SOFTWARE NOTICECopyright 2000 World Wide Web Consortium, (Massachusetts Institute of Technology, Institut National deRecherche en Informatique et en Automatique, Keio University). All Rights Reserved.Note: The original version of the W3C Software Copyright Notice and License could be found tware-19980720.THIS SOFTWARE AND DOCUMENTATION IS PROVIDED “AS IS,” AND COPYRIGHT HOLDERS MAKENO REPRESENTATIONS OR WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO,WARRANTIES OF MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE OR THAT THEUSE OF THE SOFTWARE OR DOCUMENTATION WILL NOT INFRINGE ANY THIRD PARTY PATENTS,COPYRIGHTS, TRADEMARKS OR OTHER RIGHTS. COPYRIGHT HOLDERS WILL NOT BE LIABLE FORANY DIRECT, INDIRECT, SPECIAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF ANY USE OFTHE SOFTWARE OR DOCUMENTATION.

ContentsGeneral PrefaceAbout This PeopleBook . . . . . . . .xiiiPeopleSoft Enterprise Application Prerequisites. . . . . . . . . .xiiiApplication Fundamentals. . . . . . . . .xiiiDocumentation Updates and Printed Documentation. .xivObtaining Documentation Updates.xivDownloading and Ordering Printed Documentation.xivAdditional Resources. . . . . . . . .xvTypographical Conventions and Visual Cues. .xviTypographical Conventions.xviVisual Cues. . . . . . .xviiCountry, Region, and Industry Identifiers. . . . . . .xviiCurrency Codes.xviiiComments and Suggestions. .xviiiCommon Elements Used in PeopleBooks. .xviiiPrefacePerformance Monitor Preface. . . . . . . .xxiPerformance Monitor. .xxiChapter 1Getting Started with Performance Monitor. .1Performance Monitor Overview. .1Performance Monitor Implementation. .1Installation-Level Steps.1Post Installation-Level Steps.2Chapter 2Understanding Performance Monitor. .3Performance Monitor. .3Performance Monitor Architecture. .4The Monitored System.5The Monitoring System.7Copyright 1988-2007, Oracle. All rights reserved.v

ContentsImplementation Options. .9Self-Monitoring Monitoring System.9Production Monitoring System.9Performance Monitor Instrumentation. . . . . . . . .10Understanding PMUs. . . . . . . .10Understanding Events. . . . . . . .10Performance Integration with Third Party Systems. . . . . . . . .11Performance Monitor Data. . . . . . . . .11Scope of the Performance Monitor. . . . . . . . .12Chapter 3Setting Up the Performance Monitor. . . . . . . . .13Configuration of the Performance Monitor. . . . . . . . .13Enabling the Required Elements on the Monitoring System. . . . . . . . .13Setting Up the Performance Monitor Database. . . . . . . .13Setting Up the Application Server. . . . . . . .14Setting Up the Web Server for the Monitoring System. . . . . . . .15Creating a PPMI User ID. . . . . . . .15Specifying the PPMI URL and PPMI User ID. . . . . . . .16Specifying the Integration Gateway URL. . . . . . . .16Setting Up the Process Scheduler Server for the Monitoring System. . . . . . . . .16Enabling the Required Elements on the Monitored System. . . . . . . . .17Setting Up the Database of the Monitored System. . . . . . . .17Specifying the Monitor URL. . . . . . . .17Setting Up the Web Server of the Monitored System. . . . . . . .18Setting Up the Application Server. . . . . . . .18Setting Up the Process Scheduler Server. . . . . . . .18Chapter 4Administering the Performance Monitor. . . . . . . . .19Performance Monitor Administration. . . . . . . . .19Performance Monitor Administration. . . . . . . .19Pages Used for Performance Monitor Administration. . . . . . . .20Setting Global System Options. . . . . . . . .21Setting System Definition Defaults. . . . . . . . .23Modifying System Definitions. . . . . . . . .24Viewing Agent Definitions. . . . . . . . .28Setting Agent Filter Options. . . . . . . . .29viCopyright 1988-2007, Oracle. All rights reserved.

ContentsScheduling the Reaper Program. . . . . . . . . .30Scheduling Performance Data Archiving. . . . . . . . .31Running the Performance Data Archiving Program. . . . . . . .31Working with Aborted Program Runs. . . . . . . .32Populating Performance Monitor Lookup Tables. . . . . . . . .32Working with Performance Monitor Tables. . . . . . . . .32Disabling Performance Monitor Agents. . . . . . . . .34Working with Performance Monitor Web Profile Properties. . . . . . . . .34Tracing Performance Monitor Agents. . . . . . . . .35Enabling Tracing on the Application Server or Process Scheduler Server. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35Enabling Tracing on the Web Server. . . . . . . .35Tracing the Monitor and PPMI Servlets. . . . . . . . .35Configuring Performance Monitoring Sampling Rate. . . . . . . . .35Viewing Monitor Servlet Diagnostics. . . . . . . . .36Monitoring Agents. . . . . . . .36Monitoring PPMI Clients. . . . . . . .37Setting Up Monitor Clusters. . . . . . . . .38Using Performance Monitor Data Mover Scripts. . . . . . . . .39Estimating Your Performance Database Size. . . . . . . . .40Estimating Your Performance Database Size Overview. . . . . . . .40Estimating Space Requirements for Event Data. . . . . . . .41Estimating Space Requirements for PMU Data. . . . . . . .43Calculating Space Requirements. . . . . . . .44Chapter 5Working with the Performance Trace. . . . . . . . .47Understanding the Performance Trace. . . . . . . . .47Enabling a Performance Trace. . . . . . . . . .48Running a Performance Trace. . . . . . . . .48Viewing Performance Trace Information. . . . . . . . .49Chapter 6Monitoring System Performance. . . . . . . . .51System Performance Monitoring. . . . . . . . .51Monitoring System Performance. . . . . . . .51Pages Used to Monitor System Performance. . . . . . . .52Using the System Performance Home Page. . . . . . . . .53Viewing Web Server Performance. . . . . . . . .58Copyright 1988-2007, Oracle. All rights reserved.vii

ContentsViewing Application Server Domain Performance. . . . . . . . .62Viewing Analytic Server Information. . . . . . . .65Viewing Process Scheduler Server Performance. . . . . . . . .65Viewing Master Scheduler Performance. . . . . . . . .68Viewing Open PMUs. . . . . . . . .70Viewing Open PMU Trees. . . . . . . . .73Viewing Current User Sessions. . . . . . . . .74Viewing Recycled Processes Diagnosis. . . . . . . . .75Events That Monitor Resource Usage. . . . . . . . .76Working with Event 150 (JVM Status). . . . . . . .76Working with Event 151 (Network Status). . . . . . . .76Working with Event 200 (Resources Per Process). . . . . . . .76Working with Event 300 (Host Resource Status). . . . . . . .79Working with Event 301 (Tuxedo "pq Rows). . . . . . . .81Working with Event 302 (Tuxedo "psr" Rows). . . . . . . .81Chapter 7Analyzing Historical Performance Data. . . . . . . . .83Historical Performance Data. . . . . . . . .83Historical Performance Data. . . . . . . .83Pages Used to Analyze Historical Performance Data. . . . . . . .83Viewing Completed PMUs. . . . . . . . .84Entering Search Criteria. . . . . . . .84Working with Completed PMUs. . . . . . . .86Completed PMU Status. . . . . . . .89The PMU Details Page. . . . . . . .90Viewing Event History. . . . . . . . .90Entering Search Criteria. . . . . . . .90Working with Event History Information. . . . . . . .91Viewing User Session History. . . . . . . . .93Entering Search Criteria. . . . . . . .93Working with User History Information. . . . . . . .94Chapter 8Working with Performance Monitor Charts and Analytics. . . . . . . . .95Performance Monitor Charts and Analytics. . . . . . . . .95Performance Monitor Charts and Analytics Overview. . . . . . . .95Common Elements Used in This Chapter. . . . . . . .96viiiCopyright 1988-2007, Oracle. All rights reserved.

ContentsPages Used to View Performance Monitor Charts. . . . . . . .96Viewing User Request Analytics. . . . . . . . .97The User Requests Chart. . . . . . . .99The Request Time vs. Think Time Chart. . . . . . . . .99User Request Details.100Viewing Component Trace Information. .103Viewing Component Statistics. .106Viewing Portal Statistics. .109Viewing PIA Statistics. . . . . . . .111Viewing Top Portal Content Requests. . .112Viewing Top PeopleCode Events. .114Viewing Top PeopleCode Executions. .116Viewing Top PeopleCode SQL Statements. .117Viewing Top Components. .119Chapter 9Performance Monitor Security Considerations. .121Setting Up PSPPMSRV Authentication. .121Firewall Considerations. .121Agent Communication with the Monitor Servlet.122PSPPMSRV Communication with the Monitor Servlet.123Monitor Cluster Members.123Setting Up SSL. .123Setting Up SSL Between Agents and Performance Monitor.123Setting Up SSL Between Performance Monitor and PSPPMSRV and Monitor ClusterMembers.123Setting Up SSL Client Authentication. .124Protecting the Performance Monitor Servlets. .126Chapter 10Performance Monitor Meta-Data. .127Performance Monitor Meta-Data Definitions.

PeopleSoft Enterprise PeopleBooks provide you with the information that you need to implement and use PeopleSoft Enterprise applications from Oracle. This preface discusses: PeopleSoft Enterprise application prerequisites. Application fundamentals. Documentation updates and printed documentation. Additional resources.

Related Documents:

PeopleBook: PeopleSoft Performance Monitor February 2005. Enterprise PeopleTools 8.46 PeopleBook: PeopleSoft Performance Monitor SKU PT846PFM-B 0205 . Performance Monitor Preface.xxi PerformanceMonitor .

Before you begin, review the following information to organize your upgrade process: Review the PeopleSoft PeopleTools release. Make sure to download the most recent version of the PeopleSoft PeopleTools upgrade documentation. Go to My Oracle Support and search for the PeopleSoft PeopleTools upgrade documentation for your release.

Oracle's PeopleTools PeopleBook PeopleTools 8.52: PeopleSoft Applications User's Guide October 2011

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or . PeopleTools Process Scheduler is a centralized tool that enables application developers, system .

Starting with the release of PeopleTools 8.58, PeopleTools can now use Excel Spreadsheets as BI Publisher templates. Before this release, if we wanted to create a spreadsheet using BI Publisher, the fastest way was to use an RTF template with a table and force the output to Excel through the report

The following diagram illustrates the concept of BI Publisher. BI Publisher concept Select features of Oracle's BI Publisher product have been integrated into and enhanced for use with PeopleTools. Within PeopleSoft applications, this is referred to as XML Publisher (XMLP). This diagram illustrates PeopleSoft applications integration with BI .

PeopleSoft Portal Solutions product family. PeopleSoft Enterprise Portal feature overview. PeopleSoft Enterprise Portal and PeopleTools. PeopleSoft Portal Solutions Product Family This section discusses the products that are part of the PeopleSoft Portal Solutions product family: PeopleSoft Enterprise Portal.

PeopleSoft Enterprise PeopleBooks provide you with the information that you need to implement and use PeopleSoft Enterprise applications from Oracle. This preface discusses: PeopleSoft Enterprise application prerequisites. Application fundamentals. Documentation updates and printed documentation. Additional resources.