Oracle Financials Administration / Edition 1

Oracle Financials Administration / Edition 1

by Shankaran Iyer
     
 

ISBN-10: 0072130989

ISBN-13: 9780072130980

Pub. Date: 12/01/2001

Publisher: McGraw-Hill Companies, The

Maximize the capabilities of Oracle Financials Release 11i -- an integral component of the Oracle E-Business Suite. Officially authorized by Oracle Corporation, this essential resource explains how to install and upgrade Oracle Financials, apply patches, trace and tune critical application modules, and manage customizations. You'll also get details on day-to-day tasks

Overview

Maximize the capabilities of Oracle Financials Release 11i -- an integral component of the Oracle E-Business Suite. Officially authorized by Oracle Corporation, this essential resource explains how to install and upgrade Oracle Financials, apply patches, trace and tune critical application modules, and manage customizations. You'll also get details on day-to-day tasks, such as managing concurrent requests, adding users, handling backup and recovery, troubleshooting, capacity planning, and much more. This is a must-have resource for any Oracle DBA or Financials Administrator.

Product Details

ISBN-13:
9780072130980
Publisher:
McGraw-Hill Companies, The
Publication date:
12/01/2001
Series:
Oracle Press Series
Pages:
556
Product dimensions:
7.50(w) x 9.25(h) x 1.13(d)

Table of Contents

Acknowledgmentsxv
Introductionxvii
Part IIntroduction
1Introduction to the Oracle Application Suite3
What's in the Oracle Application Suite4
Summary22
2Roles and Responsibilities of a Financials Administrator23
Who Is a Financials Administrator?24
Financials Administrator's Responsibilities26
Skill Sets of a Financial Administrator32
Finding Success as a Financials Administrator34
Types of Financials Administrators35
Summary36
Part IISetting Up the Financials Environment
3Installing and Configuring the Technology Stack39
Improvements in Oracle Financials 11i40
Summary54
4Upgrading to Oracle Application Suite 11i57
Upgrade Objectives59
Pre-Upgrade Considerations62
Preparation, AutoUpgrade, and Post-Installation Process Categories66
AutoUpgrade79
Upgrade Case Study96
Handling Customizations97
Summary100
5Managing the Financials Environment101
AD Utilities102
Analyzing the Database119
Changing the Oracle Applications Password119
Migrating the Oracle Applications Database120
Managing Oracle Workflow120
Summary132
6Managing the Concurrent Manager133
What Is Concurrent Manager?134
Summary146
Part IIIDatabase Administration and Maintenance
7Managing Database Growth149
Components of Database Growth150
Advantages of Managing Database Growth150
Using Database Statistics to Monitor Growth151
Techniques for Managing Growth157
Tips for Administrators169
Summary175
8Change Control and Patch Management177
Introducing Patches and Upgrades178
Optimizing Strategic Business Processes190
Summary199
9Managing CBO in an Oraclel li Environment201
Rule-Based Optimization vs. Cost-Based Optimization202
Why Is CBO Required for Oraclel li?203
Setting the Optimizer Mode203
CBO Architecture204
Methods of Collecting Statistics205
Initialization Parameters for Implementing CBO in Oraclel li210
Understanding Plan Stability211
Summary219
10Open Interfaces221
What Are Open Interfaces?222
Building Your Own Open Interface224
Overview of Programming Techniques225
Tuning the Interface Programs234
Summary235
11Troubleshooting237
Setting Up the Printer238
Troubleshooting the Cost-Based Optimizer241
Troubleshooting Workflow242
Performance Tuning244
Miscellaneous Troubleshooting249
When Upgrade Fails250
Summary252
Part IVTuning Your Environment
12Application Performance Tuning255
Getting Ready to Tune Performance256
Tuning Applications258
Tuning the Server280
Tuning Memory280
Tuning I/O295
Tuning the CPU296
Tuning SQL296
Tuning the Network306
Oracle Performance Diagnostic Tools309
Summary322
13Collecting Statistics Using Statspack323
What Is Statspack?324
Benefits of Using Statspack vs. utlbstat/utlestat325
Using Snapshots in Statspack326
Statspack Installation and Setup330
Purging and Archiving Statspack Tables336
Analyzing Statspack Tables337
Summary343
14Capacity Planning and Sizing345
Benefits of Capacity Planning346
Methodology for Capacity Planning348
Summary360
Part VDBA Tools and Processes
15Financials Administrator's Toolkit365
Financials Administrator's Toolkit: A Closer Look366
Oracle Enterprise Manager: An Introduction to the Management Pack Features370
Summary390
16Backup and Recovery393
Backup Requirements of an E-Business Site394
Backup and Recovery Processes and the Application Administrator395
Application Availability396
Standby Recovery Database403
Oracle8i Backup Features to Leverage with Applications407
Introduction to Oracle Recovery Manager409
Summary417
17Security419
Securing the Oracle E-Business Environment420
Managing Security in Oracle Applications423
Implementing Security in Custom Modules424
Implementing a Virtual Private Network Using Fine Grained Access Control426
Oracle Advanced Security429
Summary437
18Using Oracle8i Features439
Fine Grained Access Control440
Partitioning449
Locally Managed Tablespaces455
Database Resource Manager460
Oracle Management Pack for Oracle Applications470
Other Oracle8i Features475
Summary479
Part VIMiscellaneous Topics
19The Oracle Portal Technology483
What Is Oracle Portal?484
Using Oracle Portal for Application Customization486
Installation and Configuration Issues488
Examples492
Summary495
20Oracle Financial Analyzer497
Introduction to Oracle Financial Analyzer498
Installation and Configuration of OFA504
Implementation Tips and Recommendations507
Summary510
Index511

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >