Friday, March 25, 2016
Subscribe to:
Post Comments
(
Atom
)
skip to main
|
skip to sidebar
Oracle: All Things Database
Oracle: Insights into Statistics, Query Optimization and the Oracle Optimizer
Christian Antognini: Striving for Optimal Performance
Neil Chandler's DB Blog
Kevin Closson’s Oracle Blog: Platform, Storage, and Clustering Topics related to Oracle Databases
Pete Finningan's Oracle Security Weblog
Richard Foote's Oracle Blog
Randolf Geist's Oracle Related Stuff
Jonathan Lewis: Oracle Scratchpad
Connor McDonald: Learning is not a Spectator Sport
Cary Millsap
Tanel Poder: Core IT for geeks and pros
Carlos Sierra Oracle SQLTuning Notepad
This blog contains things about PeopleSoft, mostly performance related, that DBAs might find interesting.
Or then again they might not! The non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk.
Announcements
My Book
Oracle ACE Director
BlueSky/Twitter
@go-faster.co.uk on BlueSkyFeatured post
nVision Performance Tuning: Table of Contents
This post is an index for a series of blog posts that discuss how to get good performance from nVision as used in General Ledger reporting. ...
Blog Archive
Popular Posts
-
A little while ago I was asked whether Business Units need to be 5 characters for good performance. PeopleSoft used to recommend that SETIDs...
-
I recently worked on a PeopleTools 8.50 system in production for the first time and was able to make use of the new Oracle specific instrume...
-
I was recently asked a question about PeopleSoft version numbers, but before I address that directly, I think it would be useful to explain ...
PeopleSoft Administrator Podcasts
Tags
%CurrentDateIn
(
1
)
%SQLHint
(
1
)
%UpdateStats
(
5
)
Active Data Guard
(
2
)
Active Session History
(
5
)
Adaptive Optimization
(
2
)
Adaptive Plans
(
1
)
Adaptive Statistics
(
1
)
After Logon
(
1
)
Analytic Function
(
1
)
Analyze
(
2
)
Append
(
1
)
Application Engine
(
17
)
Application Server
(
5
)
ASSM
(
1
)
AWR
(
1
)
Batch Timings
(
2
)
Bloom filters
(
2
)
Cache
(
2
)
clob
(
1
)
clone database
(
1
)
COBOL
(
3
)
column default values
(
1
)
Component Processor
(
1
)
compression
(
2
)
Conference
(
2
)
CURRENT_SCHEMA
(
2
)
cursor sharing
(
7
)
Database Links
(
1
)
DataGuard
(
1
)
DBMS_APPLICATION_INFO
(
5
)
DBMS_METADATA
(
1
)
DBMS_MONITOR
(
3
)
DBMS_STATS
(
8
)
DDL
(
2
)
DDL Model
(
4
)
DDL overrides
(
1
)
DDL trigger
(
5
)
Dead Connect Detection
(
1
)
Deferred Segment Creation
(
2
)
Descending Key
(
2
)
Dirty Reads
(
1
)
DUAL
(
1
)
Dynamic Code
(
2
)
Effective-date
(
1
)
enq: RO - fast object reuse
(
2
)
Environment Variables
(
1
)
Extended Statistics
(
1
)
Fine-Grained Auditing
(
2
)
Flashback Database
(
1
)
Flashback Query
(
1
)
Freelist
(
1
)
GetNextNumberWithGapsCommit
(
1
)
Global Payroll
(
1
)
global temporary tables
(
4
)
Global Unique Identifier
(
1
)
Grid Control
(
1
)
Healthcheck
(
1
)
Hints
(
6
)
Indexes
(
3
)
Instrumentation
(
3
)
Interval Partitioning
(
1
)
Invisible Indexes
(
1
)
Isolation Level
(
1
)
Load Balancing
(
1
)
local write wait
(
3
)
Locking
(
1
)
long
(
2
)
Lookup Exclusion
(
2
)
Materialized Views
(
3
)
message log
(
1
)
MetaSQL
(
3
)
multi-tenant
(
1
)
Multi-versioning
(
1
)
Multitenant; SGA
(
1
)
Network Latency
(
1
)
Null
(
1
)
nvision
(
21
)
nVision Performance Options
(
2
)
OpenXML
(
2
)
Optimizer Dynamic Sampling
(
3
)
ORA-01652 unable to extend temporay segment
(
1
)
Oracle 12c
(
3
)
Oracle Enterprise Manager
(
1
)
Oracle Resource Manager
(
1
)
Parse
(
2
)
Partitioning
(
5
)
PeopeTools Tables
(
2
)
PeopleTools 8.1x
(
1
)
PeopleTools 8.48
(
4
)
PeopleTools 8.49
(
1
)
PeopleTools 8.50
(
1
)
PeopleTools 8.52
(
2
)
PeopleTools 8.53
(
1
)
PeopleTools 8.54
(
11
)
PeopleTools Tables
(
1
)
performance
(
4
)
Performance Metrics
(
5
)
Performance Monitor
(
10
)
Plan Stability
(
1
)
Podcast
(
1
)
posting
(
1
)
Priority
(
3
)
Privileges
(
1
)
Process Scheduler
(
9
)
PS/Query
(
3
)
ps360
(
2
)
psadmin.io
(
5
)
PSAESRV
(
1
)
PSPMSESSIONS_VW
(
1
)
PTRef
(
2
)
Query Security Records
(
1
)
re-posting
(
1
)
Read Consistency
(
1
)
Record Locator Dialogue
(
1
)
Recyclebin
(
1
)
Redo
(
1
)
redo logging
(
1
)
Redundant Indexes
(
2
)
Report Reposiory
(
1
)
Resource Manager
(
2
)
Restartability
(
1
)
ReUse Statement
(
3
)
row cache lock
(
1
)
row source alias
(
1
)
Run Control
(
1
)
scalability
(
1
)
scalar queries
(
1
)
Scheduled Queries
(
1
)
Script
(
3
)
Search Record
(
1
)
sequences
(
2
)
serialisation
(
1
)
session parameters
(
1
)
Shell Script
(
2
)
sparse index
(
1
)
SQL Profiles
(
4
)
SQL Server 2005
(
1
)
SQL Trace
(
4
)
SQL Tuning
(
3
)
SQL*Net
(
1
)
SQL*Plus login prompt
(
1
)
SQR
(
1
)
Standby Database
(
1
)
Statistics
(
7
)
Statistics Retention
(
1
)
Stored Outlines
(
1
)
Stored Statements
(
2
)
Temporary Records
(
10
)
Temporary Tablespace
(
1
)
Terminated Connection Timeout
(
1
)
trace "external table" directory
(
1
)
Tree Selectors
(
5
)
Trees
(
3
)
Trigger
(
4
)
Truncate
(
5
)
Tuxedo
(
6
)
Tuxedo Queuing
(
1
)
unicode
(
1
)
Unix Process Limits Memory Application Engine
(
1
)
v$session_longops
(
1
)
varchar
(
1
)
Version Numbers
(
2
)
Views
(
3
)
XML Reporting
(
1
)
Posts
Other PeopleSoft Blogs
Other Oracle Blogs
OakTable Network
No comments :
Post a Comment