UKOUG Conference & Exhibition

Thursday, October 28th, 2004 by Mark Rittman

It’s almost time again for the UKOUG
Conference & Exhibition, which this year is taking place a month early
and is running on the 1st - 3rd November up at the ICC in Birmingham.
There’s a number of presentations, workshops and panel sessions that’ll be of
interest to Oracle business intelligence and data warehousing users, including
the following:

Oracle
[…]

UKOUG Conference & Exhibition

Thursday, October 28th, 2004 by Mark Rittman

It’s almost time again for the UKOUG
Conference & Exhibition, which this year is taking place a month early
and is running on the 1st - 3rd November up at the ICC in Birmingham.
There’s a number of presentations, workshops and panel sessions that’ll be of
interest to Oracle business intelligence and data warehousing users, including
the following:

Oracle
[…]

GIS-Enabling Your Oracle Data Warehouse

Wednesday, October 27th, 2004 by Mark Rittman

In this month’s article for DBAZine, put
together in collaboration with fellow blogger
Justin Lokitz, I look at
GIS-Enabling Your Oracle Data
Warehouse.
"GIS" is short for Geographic Information Systems and describes the technique
of combining information and maps. Almost every database and data warehouse
contains an element of location data, be it customer addresses, location of
transactions, or geographic regions or […]

Howard Rogers’ Windows Laptop RAC Paper Now Available Again

Wednesday, October 27th, 2004 by Mark Rittman

Howard Rogers dropped me a line earlier today to say that his Windows Laptop
RAC paper is available for download again.
The paper can be download from

http://www.dizwell.com/html/exotic_oracle.html, and Howard’s put a redirect
in place so requests to the previous URL still get through.

What Happens To Application Performance When CPU Utilisation Increases?

Tuesday, October 26th, 2004 by Mark Rittman

There was an interesting
question on Oracle-L the other day about system performance when CPU
utilisation goes up towards 100%:

"I’m not a hardware guy or sys admin person so forgive me if this
is a stupid question. Leaving out all other variables(such as IO), should I
expect performance to be the same in a databse […]

Craig Shallahamer : “Oracle Tuning Is Like War”

Tuesday, October 26th, 2004 by Mark Rittman

"Performance War", Craig Shallahamer : "Every great Greek battle
commander (Pausanias, Themistocles, Aristides, just to name a few) was either
exiled, sacked, indicted, or fined by the very people he sought to save. Do you
DBAs feel like that sometimes? We often think, "Well, why even try?" But we
continue on because performance optimization is what many of us […]

Concats, Composites and Conjoints

Monday, October 25th, 2004 by Mark Rittman

The other day I posted an article about dimensions in Oracle 9i, and went
through an example where we created some dimensions using an analytic workspace.
The particular part of the article went as follows;

"…  Next, we need to create some dimensions. In our case we
want to create two dimensions, a new one called

“When Worlds Collide, Content Joins Data”

Monday, October 25th, 2004 by Mark Rittman

When
Worlds Collide, Content Joins Data : "The systems that manage
content and data are on a collison course. New synergies will change the course
of content. The technologies that manage unstructured content and structured
data are on a collision course, and signs of the convergence are everywhere.
Take, for example, the widely expected news that Oracle will enter the
enterprise […]

Steven Feuerstein On Best-practice tips for using Native Dynamic SQL

Sunday, October 24th, 2004 by Mark Rittman

Better to Best NDS : "In recent years, dynamic SQL has become a much more
common aspect of PL/SQL programming. Prior to the availability of Native Dynamic
SQL (NDS) in Oracle8i, dynamic SQL was available in PL/SQL only through the
DBMS_SQL package. Although very robust, DBMS_SQL was very difficult to use and
relatively slow. Now, in Oracle Database 10g, […]

“Digital Retro : The Evolution Of The Personal Computer”

Saturday, October 23rd, 2004 by Mark Rittman

If
you’re in your mid-thirties and work in the IT industry you probably grew up
using home computers such as the

Sinclair Spectrum, Commodore-64, Acorn Atom and Atari 800. If this sounds
like you, you’ll probably be interested in a new book that I got hold of
recently entitled

"Digital Retro" by Gordon Laing. The author writes the monthly "Retro"
article in […]