This article has been rewritten and is now part of a 4-part series about cursor sharing.
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
The PeopleSoft DBA Blog is moving. It has been merged into the Go-Faster blog.
This site will remain for now, but no new posts will appear here.
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
-
In previous postings, I have proposed locking statistics on temporary working storage tables and changing the DDL model for %UpdateStats t...
-
In a previous blog entry , I discussed how to detect whether an Application Engine process had run out of non-shared Temporary Table instanc...
-
I was told about a PeopleSoft customer experiencing an Oracle error when collecting statistics during an Application Engine. ORA-06533: Sub...
PeopleSoft Administrator Podcasts
Tags
%CurrentDateIn
(
1
)
%SQLHint
(
1
)
%Table
(
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
(
19
)
Application Server
(
5
)
ASSM
(
1
)
AWR
(
1
)
Batch Timings
(
2
)
Bloom filters
(
2
)
Cache
(
2
)
Cartesian
(
1
)
clob
(
1
)
clone database
(
1
)
COBOL
(
3
)
column default values
(
1
)
Component Processor
(
1
)
compression
(
4
)
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
(
1
)
Descending Key
(
2
)
Dirty Reads
(
1
)
DUAL
(
1
)
Dynamic Code
(
2
)
Effective-date
(
1
)
enq: RO - fast object reuse
(
2
)
Environment Variables
(
1
)
Exadata
(
2
)
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
(
4
)
Instrumentation
(
3
)
Interval Partitioning
(
2
)
Invisible Indexes
(
1
)
Isolation Level
(
1
)
Journal Line
(
5
)
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
(
22
)
nVision Performance Options
(
2
)
OpenXML
(
2
)
Optimizer Dynamic Sampling
(
3
)
Oracle 12c
(
3
)
Oracle Enterprise Manager
(
1
)
Parse
(
2
)
Partitioning
(
6
)
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
(
5
)
Performance Metrics
(
5
)
Performance Monitor
(
10
)
Plan Stability
(
1
)
Podcast
(
1
)
posting
(
1
)
Priority
(
3
)
Privileges
(
1
)
Process Scheduler
(
9
)
PS_JRNL_LN
(
5
)
PS/Query
(
11
)
ps360
(
2
)
psadmin.io
(
5
)
PSAESRV
(
1
)
PSPMSESSIONS_VW
(
1
)
PSQUERY
(
2
)
PTRef
(
2
)
Quarantined SQL Plan
(
3
)
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
(
8
)
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
(
5
)
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
)
System Statistics
(
1
)
Temporary Records
(
11
)
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
)
varchar2
(
1
)
Version Numbers
(
2
)
Views
(
3
)
XML Reporting
(
1
)
Posts
Other PeopleSoft Blogs
Other Oracle Blogs
OakTable Network
No comments :
Post a Comment