Niall's Oracle Pages

Thoughts, discoveries and otherwise maybe useful stuff about the Oracle RDBMS

Sunday, August 07, 2005

For my Australian Friends 

5 Comments:

Looks like having McGrath and Lee out creates an even playing field...

:-)

# posted by  Connor McDonald : 1:37 PM, August 09, 2005

 

I know
fancy finding cricket balls and dirt on a cricket pitch. shockingly dangerous these english conditions.

# posted by  Niall : 2:22 PM, August 09, 2005

 

whereas Lee got an infection...

He should have known to only drink bottled water in a 3rd world country

:-)

# posted by  Connor McDonald : 1:05 AM, August 11, 2005

 

ouch!...
:)

# posted by  Noons : 12:51 PM, August 11, 2005

 

thanks for the tip Connor. I arranged for a delivery of English bottled water to the Australian hotel this very morning. I trust all is well now :)

# posted by  Niall : 9:22 PM, August 12, 2005

 

Post a Comment

About

This page contains my thoughts and ramblings about the Oracle RDBMS. In addition you will find scripts that I have found useful and presentations delivered to various audiences around the world.

You won't find marketing or - too much - advocacy on these pages, I am more interested in getting useful use out of the technology than RDBMS wars.

If you find anything useful, wrong or intriguing drop me a line

Links

• Newsgroup Archives
• The Oracle Users' Co-operative FAQ
• Connor McDonald's useful site
• Site run by Howard Rogers
• The Oak Table
• Oracle Underground FAQ
• Mark Rittman's Oracle Weblog - good for developers and BI

Scripts

A word of hopefully commonsense warning. These scripts are provided as-is and without warranty. You are free to use them, and I do hope they prove useful, but I cannot accept liability if they don't do exactly what you thought. They are all unencrypted so you should be able to see what they do. That all said it makes sense to check them out on a test system first to work out what they do. Read the comments - they are an aide-memoire for me but they might help you get the idea. Don't just apply them without thinking to your production database.

I do welcome feedback, and if you are going to quote me publicly then at least give me a little advance warning. A legal language version of this - that is, the license - is available by clicking on the link or picture below.
These works are licensed under a Creative Commons License.

Resources

• Webutils - Generate email from PL/SQL
• Simple Profiler - Generate a resource profile from Extended SQL Trace
• Manual Standby Scripts for windows - accompanies the presentation
• Demonstration of tablespace fragmentation using auto-allocate LMT
• Read the alert log from pl/sql
• Check when objects were analyzed
• Memory Usage vs Elapsed timings for PL/SQL bulk operations
• Utility to monitor the cause of arbitrary server errors
• Display more informative execution plans in 9i and above.
• Order in where clause does not need to match order of index creation
• Execute an arbitrary number of concurrent sql scripts - OraLoader
• A Guide to setting up Generic Connectivity

Presentations

• The Oracle Myths Presentation given to the UK and South African Oracle Users Groups
• You Probably Don't Need DataGuard - running a standby database on Standard Edition
• A la recherché du temps perdue - In search of lost time. Practical response time based tuning presentation given to the UKOUG DBMS sig
• Snatches of Eternity - End-to-End tracing in Oracle 9i and below.

archives

• 03/01/2004 - 04/01/2004
• 04/01/2004 - 05/01/2004
• 05/01/2004 - 06/01/2004
• 06/01/2004 - 07/01/2004
• 07/01/2004 - 08/01/2004
• 08/01/2004 - 09/01/2004
• 09/01/2004 - 10/01/2004
• 11/01/2004 - 12/01/2004
• 12/01/2004 - 01/01/2005
• 01/01/2005 - 02/01/2005
• 03/01/2005 - 04/01/2005
• 04/01/2005 - 05/01/2005
• 05/01/2005 - 06/01/2005
• 06/01/2005 - 07/01/2005
• 07/01/2005 - 08/01/2005
• 08/01/2005 - 09/01/2005
• 09/01/2005 - 10/01/2005
• 10/01/2005 - 11/01/2005
• 11/01/2005 - 12/01/2005
• 12/01/2005 - 01/01/2006
• 01/01/2006 - 02/01/2006
• 04/01/2010 - 05/01/2010