This page covers items about the general need for tuning and performance monitoring - what to look for, how to look for it, and how (sometimes) to pre-empt it.
|
Title |
Content |
Last update |
|
A SQL script to create little package to take snapshots of ‘lock’ activity. |
8th Jan 2005
|
|
|
|
|
|
|
An example of a package that takes snapshots of dynamic performance views. |
24th Mar 2004 |
|
|
Yet another simple (Oracle 8) dump of the current parameter list |
23-Nov-2001 |
|
|
A correction to v$sort_usage in Oracle 8.1.5 |
24-Nov-2000 |
|
|
An introduction to the basic features of EXPLAIN PLAN |
30-Jun-2000 |
|
|
Explain plan with parallel queries, partitioned table, and some funnies. |
30-Jun-2000 |
|
|
A package to take performance snapshots or dump stats since startup |
18-May-1999 |
|
|
An Oracle 7 utility to identify who is doing sorting |
07-Apr-1999 |
|
|
Spotting memory hungry Oracle processes without connecting |
01-Apr-1999 |
|
|
Using utl_file to log a series of performance snapshots. |
24-Mar-1999 |
|
|
What's been around but ignored in V$ for Oracle 7 |
26-Feb-1999 |
|
|
How effective was your last Parallel Query |
17-Feb-1999 |
|
|
3 scripts for (almost) total performance monitoring |
17-Feb-1999 |
|
|
A class of queries that makes Explain Plan go wrong |
10-Feb-1999 |
|
|
A sample of awk, cut,and paste for low-impact monitoring (UNIX) |
10-Feb-1999 |
|
|
What's new in the V$ area for Oracle 8 (and a symmetric difference) |
03-Feb-1999 |
|
|
A small C program to tidy up the listing from v$sql_text |
27-Jan-1999 |
|
|
An undocumented (X$) object to see where v$waitstat is happening |
21-Jan-1999 |
|
|
An idea for switching sql_trace on selectively in production systems |
21-Jan-1999 |
|
|
Who's the sinner and what's (s)he doing right now (Unix only) |
14-Jan-1999 |
|
|
V$ Views - a health warning |
14-Jan-1999 |
|
|
A better view definition for v$pq_slave |
08-Jan-1999 |
|
|
What is in the db_block_buffer now (Oracle 8.0) |
08-Jan-1999 |
|
|
The oldest bug in Oracle ? |
07-Jan-1999 |
|
|
A convenient framework for running explain plan against Oracle 8 |
07-Jan-1999 |
|
|
A convenient framework for running explain plan against Oracle 7.3 |
07-Jan-1999 |