General Administration


Topic

Description

15/10/2007

First match

Does Oracle stop after the first match? An interesting test case

18/04/2007

Default column

Adding a column with DEFAULT updates the entire table...How to avoid?

09/01/2007

Hidden columns

You can gather stats on a hidden column, but you cannot get them!

30/04/2006

Space reuse

A simple demo that shows that index space CAN be re-used

26/03/2006

NOT NULL constraints

Are all the NOT NULL declarations mades ?

13/01/2006

More bad code

You can lead a horse to water... but you can't make it think

13/01/2006

View definitions (updated)

Some subtle differences when defining views

17/04/2005

KEEP INDEX clause

A closer look at the KEEP INDEX clause

10/02/2005

Index Stats

Quick and dirty script to populate INDEX_STATS for all indexes

06/10/2004

Compressed Partitions

A quirk with compressed partitions in 10g

20/04/2004

Unusable indexes

A nasty gotcha when truncating tables with unusable indexes

01/01/2003

Monitoring VPD

Some tips for monitoring the effect of Virtual Private Database

10/09/2002

Converting Tablespaces

(Updated) Want to convert to locally managed tablespaces?

01/08/2002

GCD

Why would an oracle site have a Greatest Common Divisor routine?

14/07/2002

Extents

Maybe the number of extents does matter?

14/06/2002

Slow read-only

Something to consider when making tablespaces read-only

14/05/2002

Index compression

Use this to determine index compression levels

25/10/2001

Rolling backup

Simple script to retrieve a rolling list of tablespaces per day

25/10/2001

Subqueries in 8.1.7

A new 8.1.7 feature that still has a few holes

17/10/2001

Duelling with DUAL

Querying DUAL isn't as simple as you may think

25/08/2001

Index maintainer

A routine to rebuild/coalesce your indexes in serial/parallel/and many other options

19/06/2001

Analyze database

The only analyze routine you will ever need (yeah, right!)

20/03/2001

Minextents quirk

Minimum extents has a different meaning on Locally Managed tablespaces

10/03/2001

Buffer pool bug

Don't rely on V$BUFFER_POOL_STATISTICS in 8.1.7 just yet

08/03/2001

Role Matrix

Some SQL to print a matrix of privileges on tables to roles

12/12/2000

Disconnecting users

Now you can kill a user's session the "friendly way", ie, when their transactions ends

27/11/2000

Cumulative totals

A simple example of analytic functions that everyone seems to keep asking for

17/10/2000

Converting Tablespaces

Want to convert to locally managed tablespaces? You don't have to reload your database

12/09/2000

Recompiling objects

An undocumented syntax to avoid cross-PL/SQL engine problems when recompiling

01/09/2000

Function-Based Indexes

Where is the function for my function-based index ?

31/08/2000

Reverse Indexes

How do I know if an index is built as REVERSE ?

17/08/2000

Granting privileges

How do I grant privileges on someone else's objects?

14/08/2000

Idle users

I've got sessions on the database, but are these people active at the moment?

21/06/2000

Alert log check

A alert log checker that only scans the part of the log since the last check was run

21/05/2000

Synonyms solved

Sick and tired of maintaining 1000's of synonyms or using public synonyms ? 8i can help

20/05/2000

Snapshot privileges

Getting "insufficient privileges" creating a snapshot, but I have the privilege

20/05/2000

Current rollback segment

What rollback segment is someone using

23/04/2000

Character Set

How to change the character set after the database has been created

03/04/2000

SGA Locking

What to do if you get errors when trying to lock your SGA into memory

25/03/2000

Uptime in Oracle

A query for UPTIME that is simpler than what you may have seen in the past

08/03/2000

Uniqueness in 8i

Using non-unique indexes to enforce a unique constraint

24/02/2000

Group by != Order by

Why 'group by' does not necessarily means results are in sorted order

24/02/2000

New datafiles

When was a datafile added on my database

24/02/2000

Transaction Count

How many transactions ( current & high water) on my database

11/02/2000

Function based indexes

Steps you need to take to enable function based indexes in 8i

10/02/2000

Graphical 8i Install

How can I use the GUI 8i installer on a remote machine

10/02/2000

Parameter changes in 8i

Examining the (large) amount of parameter changes in 8i

09/02/2000

Sequence used in insert

How do I find the sequence number used in an insert statement

06/02/2000

File high water mark

Showing the high water mark for a datafile (with a view toward shrink)

06/02/2000

ON DELETE SET NULL

Implementing ON DELETE SET NULL referential integrity constraint

06/02/2000

Views are wonderful

Some reasons why views don't deserve the bad reputation they get

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