1. Preface

1.1 Introduction

This manual is been designed to help you quickly get acquainted with the Performance Diagnostic Plugin of Oracle Banking Payments.

1.2 Audience

This manual is intended for the following User/User Roles:

Role

Function

Database Administrator

To provide the necessary Execute grants for TKPROF & HPROF file generation.

System Technical Analyst

To analyze the Performance lag issue faced by bank user.

Oracle FLEXCUBE user

Any user of Oracle FLEXCUBE facing performance issues in the system

1.3 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

1.4 Organization

This manual is organized as follows:

Chapter

Description

Chapter 1

Preface gives information on the intended audience. It also

lists the various chapters covered in this User Manual.

Chapter 2

Functionality and Maintenance of various parameters for Perfor­mance Diagnostic Plugin - OLTP

Chapter 3

Error Code and Message

Chapter 4

Frequently Asked Question’s (FAQ’s)

Chapter 5

Function ID Glossary

1.5 Abbreviations

Abbreviation

Description

DBA

Database Administrator

HPROF

Hierarchical Profiler

OLTP

Online Transaction Processing

PDP

Performance Diagnostic Plugin

PLSQL

Procedural Language for SQL

SQL

Structured Query Language

TKPROF

Transient Kernel Profiler

1.6 Glossary of Icons

This User Manual refers to the following icons.

Icons

Function

Exit.jpg

 

Exit

OptionList.jpg

 

Option list

AddRow.jpg

 

Add Row

DeleteRow.jpg

 

Delete Row

1.7 Related Documents

For further information on procedures discussed in the manual, refer to the Oracle Database manuals on:

l Enabling SQL Tracing and Using TKPROF

l Using the PL/SQL Hierarchical Profiler