Tuning


Topic

Description

16/11/2008

Leap Year

The fast way of working out a leap year

25/02/2008

Explain Plan

Its a tough business being the explain plan output

15/10/2007

X$ idiosyncracy

A little oddity with the X$ tables

18/04/2007

Cursor sharing

Subtle differences in cursor sharing with dynamic SQL

09/01/2007

Statistics collection

You need to very careful when collecting stats on function-based indexes

09/01/2007

MERGE speed

Is it really better than insert-update ?

05/08/2006

Data types

Data type conversion is not free...even for static literals

19/01/2006

Plan table GTT

Using a global temporary table for your plan table

08/09/2005

Super fast import (updated)

(Updated) How to make your import's scream along

14/06/2005

Cute ROWNUM

A cute trick for arbitrary number of rows

17/04/2005

NVL smarts

NVL seems to have got smarter

21/01/2005

Clustering factor

A newsgroup post claimed rebuilding an index changed the clustering factor - here's how

27/06/2004

Too smart?

The CBO can be too smart for its own good sometimes

27/06/2004

Two characters

The LIKE predicate has a special case for two leading characters

06/04/2004

Best cost?

Think the lowest cost is the one CBO always chooses? Think again

01/01/2003

TKProf Waits

A 9i enhancement to tkprof to allow it see wait information

10/09/2002

SQL Tuning

(Updated) Tune SQL's in pre-delivered applications without changing the code

14/03/2002

Custom Hit Ratio

Got a low hit ratio - this routine can help

04/11/2001

dbms_utility.analyze_database

The world's worst PL/SQL routine

01/10/2001

db_file_multiblock_read_count

Some notes on choosing the best value for this parameter

10/05/2001

Version Counts

A hidden parameter that may assist with high version counts

27/03/2001

Function-based indexes

Careful with your FBI's until 8.1.7.2

04/03/2001

Index compression

A tool to determine to optimal compression for indexes

08/12/2000

Counting records

Count(*) versus count(primary_key_col) vs count(...) - what's the best

22/11/2000

Bind variables

We all know that using literals in SQL is bad...but how do we find them?

14/11/2000

Long rebuilds ?

Trying to avoid the pain of index rebuilds ? The new COALESCE option may be for you

10/11/2000

Statistics bug

A bug with index statistics when the index is compressed

08/11/2000

Index usage

A starting point in knowing which indexes are being used

03/11/2000

NULL's and CBO

An often overlooked area that affects the decisions of the cost optimizer

02/11/2000

Fractions of rows?

Dunno why, dunno how, but this table has part of a row

19/09/2000

PL/SQL Performance

PL/SQL is very fast, but not infinitely fast...

01/09/2000

Partition statistics

An interesting quirk with statistics on partitioned indexes

03/08/2000

SQL Tuning

Tune SQL's in pre-delivered applications without changing the code

24/07/2000

Shared Pool

Some 8i triggers to assist with shared pool management

21/06/2000

Slow DBA_SEGMENTS

DBA_SEGMENTS running like a wet sponge? This script can help

11/06/2000

Trace a user

Using an 8i feature to produce a trace file whenever a specific user connects

20/05/2000

Current rollback segment

What rollback segment is someone using

24/04/2000

Trace files

How to ensure that all developers can see their trace files without DBA access

01/03/2000

Indexes in 8i

A couple of hints to make your indexes faster and smaller

24/02/2000

Super fast import

How to make your import's scream along

10/02/2000

Library cache contention

Reducing contention problems with the library cache (especially on small systems)

09/02/2000

Using NTFS on NT

A couple of registry tweaks to improve NTFS performance

06/02/2000

Predicate order in SQL

Forcing the order of predicates in SQL

(always more to come...)


All content on this page is provided on an "all care, no responsibility or liability" basis
The use of very basic html on this page is designed to increase the speed at which each page is downloaded.
It has nothing to do with my wealth of html knowledge :-)