(Ebook) PeopleSoft for the Oracle DBA 2nd Edition by David Kurtz ISBN 9781430237082 1430237082

(Ebook) PeopleSoft for the Oracle DBA 2nd Edition by David Kurtz ISBN 9781430237082 1430237082

(Ebook) PeopleSoft for the Oracle DBA 2nd Edition by David Kurtz - Ebook PDF Instant Download/Delivery: 9781430237082 ,1430237082
Full download (Ebook) PeopleSoft for the Oracle DBA 2nd Edition after payment

Product details:
ISBN 10: 1430237082
ISBN 13: 9781430237082
Author: David Kurtz

(Ebook) PeopleSoft for the Oracle DBA 2nd Edition Table of contents:

CHAPTER 1 An Overview

What Is PeopleSoft?

Components of a PeopleSoft System

The Database

Tuxedo Application Server

PeopleTools

Evolution of the PeopleSoft Architecture

Single-Tier Monolithic Mainframe Architecture

Two-Tier Client/Server Architecture

Three-Tier Application Server Architecture

Four-Tier Internet Architecture

Release History

Component Connectivity

Developing and Administering PeopleSoft Systems

The Developer

The DBA

Relationship Between the Developer and DBA

Summary

CHAPTER 2 BEA Tuxedo: PeopleSoft’s Application Server Technology

What Is Tuxedo?

The Simple Application Server

The Simple Client

The Simple Server

The Simple Tuxedo Domain

Anatomy of the Application Server

Processes, Memory, and Messages

IPC Resources

tmadmin and ipcs

PIA Servlets

Integration Broker

Summary

CHAPTER 3 Database Connectivity

PeopleSoft Database versus Oracle Database

Oracle Database Users

Owner ID (SYSADM)

Connect ID (PEOPLE)

PS Schema

Oracle Database Roles

PSUSER Role

PSADMIN Role

Signing On to a PeopleSoft 8 Database

Making the Initial Connection

Using Direct Shared Memory Connections (UseLocalOracleDB)

Determining the PeopleSoft Schema

Checking the PeopleTools Release

Checking the Operator Password

Obtaining the Access Password

Reconnecting as Access ID

Using PeopleSoft Access Profiles and Oracle Resource Profiles

PeopleSoft Support for Oracle Active Data Guard

Connecting Third-Party Applications

Crystal Reports

SQR Reports

Changing Database Passwords

Connect ID Password

Owner ID Password

Summary

CHAPTER 4 PeopleSoft Database Structure: A Tale of Two Data Dictionaries

Application and PeopleTools Tables

Two Data Dictionaries

PSRECDEFN: Record Definition

The USEEDIT Field

PSRECFIELD: Record Field Definition

PSDBFIELD: Field Definition

Field Types and Lenghts

Unicode in PeopleSoft

Unicode from PeopleTools 8.48 and Application Version 9

Unicode in Application Version 8.x

PSSQLDEFN: Definition of SQL Objects

PSSQLTEXTDEFN

PSINDEXDEFN: Index Definition

PSKEYDEFN: Index definition

Recursive PeopleTools SQL

Version Numbers and Caching

Component Definition

Search Record

Case-Insensitive Searching

Component Pages

Component PeopleCode

Page Definition

Page Fields

Record Definition

Field Definitions

Subrecords

Field Labels

Record DDL

Subrecord Definition

Application SQL

Data Dictionary Synchronization

DDL Changes

Column Difference Audit Script

Summary

CHAPTER 5 Keys and Indexing

What Is the Purpose of an Index?

What Is a Constraint?

What Is the Purpose of a Unique Constraint?

Record Field Key Attributes

Field Attributes and Application Behavior

Record Locator Dialog

Component Queries

Field Attributes and System Index Definitions

No Keys

Key

Descending Key

Duplicate Order Key

Alternate Search Key

Uniqueness of Alternate Search Key Indexes

Alternate Search Key Indexes in PeopleTools 7.x

List

Custom Key Order

User-Defined Indexes

Other Index Issues

Views, Keys, and Indexing

Suppressing Index Creation

Discrepancy Between Platform Radio Button and Platform Flags

Indexes and Histograms

Null Columns in PeopleSoft

Index Organized Tables in PeopleSoft

Summary

CHAPTER 6 PeopleSoft DDL

PeopleSoft DDL and the DBA

DDL Models

Create Table

Table Definition

Column Definitions

Create Index

Create Tablespace

Maintaining Cost-Based Optimizer Statistics in Application Engine with %UpdateStats

%UpdateStats Limitations

Optimizer Dynamic Sampling

Controlling How Application Engine Programs Collect Statistics

Controlling How PeopleSoft COBOL Programs Collect Statistics

Statistics Retention

Statistics Collection Strategy in PeopleSoft

Sizing Sets

Overriding DDL Model Defaults

Application Designer

Data Mover

PeopleTools Tables

PSDDLMODEL (or PS_DDLMODEL_VW): DDL Model Statement

PSDDLDEFPARMS (or PS_DDLDEFPARMS_VW): DDL Model Parameter

PSRECDDLPARM: Record DDL Parameter

PSTBLSPCCAT: Tablespace Catalogue

PSRECTBLSPC: Record Tablespace Allocation

PSIDXDDLPARM: Index DDL Parameters

DDL Model Enhancements

Additional DDL Parameters

Deferred Segment Creation

Fewer DDL Parameters

Global Temporary Tables

Creating Global Temporary Tables

Issues with Global Temporary Tables

Extra Parameters with the Default DDL Model

Index Compression

Limitations of PeopleSoft DDL Models

Grants

Partitioned Tables

Preserving Partitioning in Application Designer from PeopleTools 8.51

Constraints

Function-Based Indexes

Index Organized Tables

Other DDL

Alter Table in Place

Alter Table by Re-creation

Views

PeopleSoft Temporary Tables

Triggers

Protecting Database Objects Not Managed by Application Designer

Application Designer and the Oracle Recycle Bin

Synchronizing PeopleSoft with the Oracle Data Dictionary

What Tools Are Available?

What Should Be Fed Back Into PeopleTools?

Segment Attributes

Physical Attributes

Storage Clause Attributes

Summary

CHAPTER 7 Tablespaces

Database Creation

Supplied Database Creation Scripts

Create Database

Temporary Tablespace

Undo Segments

Default Tablespace

Oracle Database Configuration Assistant

PeopleSoft Database Configuration Wizard

Managing Tablespaces for PeopleSoft

A Single Index Tablespace: PSINDEX

Creating Multiple Index Tablespaces

Manual Adjustment

One Index Tablespace per Table Tablespace

Storage Options

Summary

CHAPTER 8 Locking, Transactions, and Concurrency

Locking

PIA Transactions

Sequence Numbers and Concurrency

Autonomous Transactions

Summary

CHAPTER 9 Performance Metrics

Online Monitoring and Metrics

Application Server

EnableDBMonitoring

tmadmin

Tuxedo Service Trace (-r Option)

Application Server Log

WebLogic Server Access Log

Weblogic Configuration

Defining the Access Log Format

Query Metrics

SQL Tracing Queries

Wed Server Access Log

Batch Metrics

Process Scheduler

Request Table

Purging the Process Scheduler Tables

Delivered Purge Process

Archiving Trigger

Purging Application Engine Batch Timings

Message Log

Process Scheduler Configuration

COBOL Statement Timings

Application Engine Batch Timings

Enhanced Application Engine Batch Timings

PeopleSoft Trace Files

Application Designer and Client

Application Server

PIA Trace

Analyzing PeopleSoft Trace Files

Aggregating SQL Statements with Different Literal Values

Summary

CHAPTER 10 PeopleTools Performance Utilities

Query Metrics in PeopleTools 8.4

Query Statistics

Query Logging

Scheduled Queries

PeopleSoft Ping

What Does Ping Measure?

Database Time

Application Server Time

Web Server Time

Browser Time

PeopleSoft Ping Case Study 1: Desktop/Browser Performance

PeopleSoft Ping Case Study 2: Application Server CPU Speed

Conclusion

Performance Monitor

Architectural Overview

Metrics

Transactions

Events

Sampling Rates

Agent Filter Levels

Performance Trace

Analytic Components

Transaction and Event Types

Transaction ID 115: JOLT Request

Transaction ID 116: Redirect on Login

Event ID 150: JVM Status

Event ID 152: Wed Site Status

Event ID 153: Wed Servlet Status

Event ID 200: Resources per Process

Event ID 300: Host Resource Status

Event ID 301: Tuxedo qp Row

Event ID 302: Tuxedo psr Row

Event ID 350: Master Scheduler Status

Event ID 351: Master Scheduler Detail

Event ID 600: PSPING

Event ID 601: Override

Instrumentation

Performance Tuning the Performance Monitor

Indexes

System Monitor Component

Archive Process

Performance Monitor Case Study: Diagnosing a SQL Performance Problem

Summary

CHAPTER 11 SQL Optimization Techniques in PeopleSoft

Active Session History

Module and Action in PeopleSoft

Setting Module and Action for Batch Processes

ASH vs. Extended SQL Trace

Statpack

Statspack Trigger

Extracting Execution Plans from Statspack

System and Session Statistics Trigger

Using Oracle Extended SQL Trace with PeopleSoft

Oracle Initialization Parameters and SQL Trace

Analyzing SQL Trace Files with TKPROF

Enabling SQL Trace by Module, Action, or Client ID

SQL Trace on PeopleTools Windows Clients

SQL Trace on Application Server Processes

Enabling Trace Another Session

Using an AFTER LOGON Trigger

Enabling SQL Trace on the Process Scheduler

Enabling SQL Trace for Batch Processes with a Trigger

Application Engine Database Optimizer Trace

Enabling SQL Trace Programmatically

Application Engine

SQR

PeopleCode

Remote Call

Where Does This SQL Come From?

Component Processor

Component Search Dialog

Prompt Buttons

Type Ahead

PeopleCode

Query

COBOL

Identifying Stored Statements

SQR

Application Engine

Techniques for SQL Optimization

Hints

Indexes

Disabling Indexes Without Using Hints

Explicitly Coding Implicit Joins

Query Block Naming

Plan Stability (or Stored Outlines)

Cursor Sharing

Implementing SQL Optimization Techniques

Views

Component Processor

Case-Insensitive Search Dialogs and Function-Based Indexes

Search Dialog PeopleCode

PeopleCode

Query

Hints in Expressions

Hints in Views

Outer Joins

Effective Date and Sequence Processing

Application Engine

Stored Statements in COBOL

SQR

Upgrade Considerations

Summary

CHAPTER 12 Configuring the Application Server

Overview of Configuration Files

psappsrv.ubx

Features, Settings, and Ports Sections

PS_DEFINES Section

Environment Variables

Configuration Variables

Special Variables

Prompted Variables

Main Tuxedo Section

Tuxedo RESOURCES Section

Tuxedo MACHINES Section

Tuxedo GROUPS Section

Tuxedo SERVERS Section

Tuxedo SERVICES Section

PS_ENVFILE Section

psappsrv.cfg

Startup

Database Options

Security

Workstation and Jolt Listeners

Domain Settings

Trace

Cache Settings

Remote Call

PeopleSoft Server Processes

psappsrv.val

psappsrv.ubb

psappsrv.env

Configuration Template Files

Tuxedo Administration Console

Configuring the Tuxedo Administration Console for PeopleSoft

Tuxedo Console Listener (wlisten)

Tuxedo Web Server (tuxwsvr)

Starting the Console

Configuring PeopleSoft for the Tuxedo Administration Console

Summary

CHAPTER 13 Tuning the Application Server

Sizing

Spawning

Too Few Server Processes?

Concurrency

Application Server Monitoring

Too Many Server Processes?

Database Overload

Running Out of CPU

Analysis based on Tuxedo Service Trace

Analysis based on PeopleSoft Performance Monitor Data

Multiple Queues

Kernel Configuration

IPC Queue Sizing

Jolt Message Size Analysis using Tuxedo Log

Jolt Message Size Analysis Using PeopleSoft Performance Monitor

Recommended IPC Parameter Changes

Other Tuxedo Options

Operating System Priority

Load Balancing

Calculating Service Loads

Service Priority

Other Tips

Unix User Accounts

Multiple Domains on Small Production Systems

Cycling the Application Server Without Shutting It Down

Reconfiguring Tuxedo with the Administration Console

Summary

CHAPTER 14 The Process Scheduler

Process Scheduler Architecture

Master Process Scheduler

Application Engine

Process Monitor

DBA Issues

What Happens When a Process Is Scheduled?

Process Scheduler Activity

Processing Between Sleeps

Processing on Heartbeat

Prioritization of Process Scheduler Requests

Process Scheduler Overhead

Purging the Process Scheduler Tables

Lowering Operating System Priority of Batch Processes

Mutually Exclusive Processing

Application Engine Server Considerations

People also search for (Ebook) PeopleSoft for the Oracle DBA 2nd Edition:

oracle peoplesoft download free
    
peoplesoft oracle database parameters
    
oracle peoplesoft query
    
oracle peoplesoft query training
    
oracle peoplesoft sign-in (qdx.com)

Tags: David Kurtz, PeopleSoft, Oracle DBA