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 Go-Faster Blog is mostly about performance measurement and optimisation.
It now also contains the posts from the PeopleSoft DBA Blog.
Announcements
My Book
Oracle ACE Director
BlueSky / Twitter
@go-faster.co.uk on BlueSkyBlog Archive
Posts
Tags
%CurrentDateIn
(
1
)
%SQLHint
(
1
)
%Table
(
1
)
%UpdateStats
(
5
)
10053
(
1
)
12.2
(
3
)
19c
(
7
)
21c
(
1
)
26ai
(
6
)
ACL
(
1
)
Active Data Guard
(
2
)
Active Session History
(
5
)
Active Session History (ASH)
(
6
)
Adaptive Execution Plans
(
2
)
Adaptive Optimization
(
2
)
Adaptive Plans
(
1
)
Adaptive Statistics
(
1
)
After Logon
(
1
)
Analytic Function
(
1
)
ANALYZE
(
3
)
Append
(
1
)
Application Engine
(
19
)
Application Server
(
5
)
ASSM
(
1
)
Attribute Clustering
(
2
)
Audit
(
1
)
Automatic Indexing
(
3
)
Autonomous
(
15
)
AWR
(
5
)
Batch Timings
(
2
)
bitand()
(
1
)
Bitmap Indexes
(
1
)
Bloom Filter
(
1
)
Bloom filters
(
2
)
Cache
(
2
)
Cartesian
(
1
)
Character Set Conversion
(
1
)
ChatGPT
(
1
)
clob
(
1
)
clone database
(
1
)
Cloud
(
2
)
COBOL
(
3
)
column default values
(
1
)
Column Usage
(
1
)
Component Processor
(
1
)
Compression
(
7
)
Conference
(
2
)
Constraints
(
1
)
CURRENT_SCHEMA
(
2
)
cursor sharing
(
7
)
Data Warehouse
(
8
)
Database Links
(
2
)
DataGuard
(
1
)
datapump
(
5
)
DBMS_APPLICATION_INFO
(
6
)
DBMS_CLOUD
(
2
)
DBMS_LOCK
(
1
)
DBMS_METADATA
(
1
)
DBMS_MONITOR
(
3
)
DBMS_PARALLEL_EXECUTE
(
2
)
DBMS_SCHEDULER
(
5
)
DBMS_STATS
(
8
)
DDL
(
2
)
DDL Model
(
4
)
DDL overrides
(
1
)
DDL trigger
(
5
)
Dead Connect Detection
(
1
)
Deadlock
(
1
)
Deferred Segment Creation
(
2
)
Descending Key
(
2
)
Dirty Reads
(
1
)
DUAL
(
1
)
Dynamic Code
(
2
)
eDB360
(
4
)
Effective-date
(
1
)
Engineered Systems
(
6
)
enq: RO - fast object reuse
(
2
)
enq: TM - contention
(
1
)
Environment Variables
(
1
)
Errorstack
(
1
)
Exadata
(
2
)
excel
(
1
)
Extended Statistics
(
5
)
external tables
(
4
)
Fine-Grained Auditing
(
2
)
Flashback Database
(
1
)
Flashback Query
(
1
)
foreign keys
(
4
)
Freelist
(
1
)
GeoJSON
(
1
)
GetNextNumberWithGapsCommit
(
1
)
Global Payroll
(
1
)
Global Temporary Tables
(
5
)
Global Unique Identifier
(
1
)
Grid Control
(
1
)
Healthcheck
(
1
)
Heterogeneous Services
(
1
)
Hints
(
9
)
Histograms
(
4
)
HTTP
(
1
)
Hybrid Columnar Compression (HCC)
(
4
)
In-Memory
(
3
)
Indexes
(
4
)
Instrumentation
(
5
)
Interval Partitioning
(
2
)
Invisible Indexes
(
2
)
Isolation Level
(
1
)
Job Chains
(
1
)
Job Classes
(
4
)
Journal Line
(
5
)
JSON
(
1
)
Kerberos
(
1
)
Latch: Cache Buffers Chains
(
1
)
Load Balancing
(
1
)
local write wait
(
3
)
Locking
(
1
)
long
(
2
)
Lookup Exclusion
(
2
)
Maintenance Window
(
1
)
Materialized Views
(
6
)
MERGE
(
1
)
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
)
OCI
(
6
)
OpenXML
(
2
)
Optimizer Dynamic Sampling
(
3
)
Optimizer Trace
(
1
)
Oracle 12c
(
3
)
Oracle Enterprise Manager
(
1
)
Oracle Transparent Gateway
(
1
)
Parallel PL/SQL
(
1
)
parallel query
(
1
)
Parse
(
2
)
Partial Indexing
(
1
)
Partitioning
(
21
)
PCTFREE
(
2
)
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
)
PL/SQL Profiler
(
1
)
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 Rewrite
(
1
)
Query Security Records
(
1
)
re-posting
(
1
)
Read Consistency
(
1
)
Record Locator Dialogue
(
1
)
Recyclebin
(
1
)
Redo
(
1
)
redo logging
(
1
)
Redundant Indexes
(
5
)
Referential Integrity
(
3
)
Regular Expression
(
1
)
Report Reposiory
(
1
)
Resource Manager
(
11
)
REST
(
1
)
Restartability
(
1
)
ReUse Statement
(
3
)
row cache lock
(
1
)
Row Migration
(
2
)
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
)
SGA; Multi-tenant;
(
1
)
Shell Script
(
2
)
sparse index
(
1
)
Sparse Indexes
(
1
)
Spatial Data
(
9
)
SQL Developer
(
2
)
SQL Profile
(
7
)
SQL Profiles
(
5
)
SQL Quarantine
(
2
)
SQL Query Transformation
(
1
)
SQL Server 2005
(
1
)
SQL Trace
(
4
)
SQL Tuning
(
3
)
SQL*Net
(
1
)
SQL*Plus login prompt
(
1
)
SQR
(
1
)
Standby Database
(
1
)
Statistics
(
16
)
Statistics Retention
(
1
)
Stored Outlines
(
1
)
Stored Statements
(
2
)
System Statistics
(
1
)
table cluster
(
6
)
Temporary Records
(
11
)
Temporary Tablespace
(
1
)
Terminated Connection Timeout
(
1
)
Text Comparison
(
1
)
Text indexing
(
1
)
trace "external table" directory
(
1
)
Trace files
(
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
)
wait events
(
1
)
XML
(
2
)
XML Reporting
(
1
)
XMLTABLE
(
1
)
Other Oracle Blogs
Other PeopleSoft Blogs
OakTable Network
Oracle ACE Director
No comments :
Post a Comment