JL Computer Consultancy

Index of articles on Monitoring and Tuning


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.

Back to Home Page.


Title

Content

Last update

Enqueue Snapshot

A SQL script to create little package to take snapshots of ‘lock’ activity.

8th Jan 2005

 

 

 

Snapshots

An example of a package that takes snapshots of dynamic performance views.

24th Mar 2004

Parameter list

Yet another simple (Oracle 8) dump of the current parameter list

23-Nov-2001

Sort Usage

A correction to v$sort_usage in Oracle 8.1.5

24-Nov-2000

Intro to Explain Plan

An introduction to the basic features of EXPLAIN PLAN

30-Jun-2000

Explain Plan 2

Explain plan with parallel queries, partitioned table, and some funnies.

30-Jun-2000

Performance Now

A package to take performance snapshots or dump stats since startup

18-May-1999

Sort Usage

An Oracle 7 utility to identify who is doing sorting

07-Apr-1999

Memory Hogs

Spotting memory hungry Oracle processes without connecting

01-Apr-1999

Logs of performance

Using utl_file to log a series of performance snapshots.

24-Mar-1999

Old V$

What's been around but ignored in V$ for Oracle 7

26-Feb-1999

PQ Costs

How effective was your last Parallel Query

17-Feb-1999

Tuning

3 scripts for (almost) total performance monitoring

17-Feb-1999

Wrong Plans

A class of queries that makes Explain Plan go wrong

10-Feb-1999

Deltas

A sample of awk, cut,and paste for low-impact monitoring (UNIX)

10-Feb-1999

New V$s

What's new in the V$ area for Oracle 8 (and a symmetric difference)

03-Feb-1999

Strip SQL

A small C program to tidy up the listing from v$sql_text

27-Jan-1999

Waiting for files

An undocumented (X$) object to see where v$waitstat is happening

21-Jan-1999

Trace Pack

An idea for switching sql_trace on selectively in production systems

21-Jan-1999

Guilty Party

Who's the sinner and what's (s)he doing right now (Unix only)

14-Jan-1999

V$ Views

V$ Views - a health warning

14-Jan-1999

PQ Slaves

A better view definition for v$pq_slave

08-Jan-1999

Buffer content

What is in the db_block_buffer now (Oracle 8.0)

08-Jan-1999

Explain Plan

The oldest bug in Oracle ?

07-Jan-1999

Explain8

A convenient framework for running explain plan against Oracle 8

07-Jan-1999

Explain7

A convenient framework for running explain plan against Oracle 7.3

07-Jan-1999


Other Index Pages

Monitoring and Tuning

Database Administration

The Physical Database

FAQ

Oracle Features

The Parallel Query Option

The Parallel Server Option

Developer Tricks

Internals

PL/SQL

Miscellaneous

Things to come