Oracle 9i / 10g


Anything I stumble across in recent versions (as at the time I wrote it!) that looks good and is not part of the mega hyped features, I'll post here.

Topic

Description

15/10/2007

V$SQL.PROGRAM_ID

The PROGRAM_ID is useful for tracking PL/SQL

15/08/2007

Constraint handling

Changes in constraint handling in 10g

18/04/2007

10.2.0.3 upgrade

Going from 32bit to 64bit? Take care!!

09/01/2007

Automatic stats

Building indexes gives you statistics for free in 10g

11/01/2006

Auto sync 10g

Some automatic sync facilities in 10g for text indexes

30/09/2004

10g Security

Scheduling in 10g

30/03/2004

10g SQL Plus

SQL Plus 10g - simple things are often the best

08/08/2003

DDL

Obtaining DDL made easy

01/01/2003

TKProf Waits

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

01/01/2003

Standby Logging

Avoiding the pain your standby suffers when someone does a NOLOGGING operation

01/01/2003

Backup Abort

A cure to the "Media Recovery needed" problems of shutdown during hot backup

01/01/2003

Hanging Standby

To do managed standby recovery, you need a SQL Plus session hanging around? Not any more

27/01/2002

Patch 9.0.1.2 for W2K

(Updated) A possible issue with downloading patch 9.0.1.2

16/12/2002

Explain Plan

A better method for EXPLAIN PLAN results

16/12/2002

Sub-queries

Sub-queries made easier to read

16/12/2002

SQL Plus

Even SQL Plus gets a makeover in 9i

16/12/2002

Privileges

Finally SYS has some real privilege power

16/12/2002

Median

A new analytic which makes medians a doddle

16/12/2002

Super Group

You can now include non-group'ed by expressions in the SELECT list

16/12/2002

Compression

A bug to what out for when using compressed primary key indexes

02/12/2002

ORA-1555

A simple enhancement to make recording the occurrence of ORA-1555

21/10/2002

Magic Column

The magic varchar2 column in 9i

16/07/2002

Extents

Maybe the number of extents does matter (but its better in 9i)

16/06/2002

INDEX BY ...

New associative arrays in PL/SQL

13/05/2002

Compatibile

A warning about the 'compatible' parameter when upgrading

24/04/2002

Unbreakable

A well-publicised security hole in 9i

06/04/2002

TO_LOB

TO_LOB looks great, but watch out for the space it consumes

11/02/2002

SPFILE's

An SPFILE 'gotcha' that can catch you if you're upgrading from 8i

02/02/2002

Event 10520

A new event that comes in handy when re-deploying code

27/01/2002

Patch 9.0.1.2 for W2K

A possible issue with downloading patch 9.0.1.2

14/01/2002

Force Parallel

Simpler way of issuing bulk DDL in parallel

14/12/2001

DBMS_STATS

A new feature (and a warning about it) in DBMS_STATS

14/11/2001

Hint FIRST_ROWS

Some important notes on the FIRST_ROWS optimizer mode

11/11/2001

Redo switching

A nice addition for more control over redo log switching

17/10/2001

Java pool

Be careful when altering the 'java_pool_size' parameter in 9i

01/10/2001

SQL Histograms

A new function to get histogram style information directly from SQL

19/08/2001

PL/SQL Case

PL/SQL in 9i supports the CASE statements

10/08/2001

Lock timeout

Now you can have a timeout when trying to lock rows in a table

09/08/2001

Which is NULL?

A function to return the first non-null in a list

06/08/2001

Validate Structure

Checking indexes? You don't need to worry about locks anymore

28/07/2001

Order by Siblings

You can specify the order of entries under each "node" of a hierarchical query

28/07/2001

NULLIF

A function to return null if its two arguments are equal

28/07/2001

Insert Defaults

Using defaults for inserting a row into a table

23/07/2001

NVL2

A nifty function thats actually already in most versions

23/07/2001

Hierarchy Tree

See an entire tree in a hierarchical query


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 :-)