Rittman Mead - Delivered Intelligence

"Hi, Mark,

You paper ‘Oracle 9i OLAP Uncovered’ inspired me to explore more on this
exciting subject. First let me confirm with you that Discoverer’s own OLAP
feature is implemented based on (or using) 9i/10g ROLAP. Is it true?
Regardless of your answer to my first question, I think I have two […]

Beginning SQL:
Differences Between Oracle and Microsoft by Les Kopari : "If you’re new
to SQL or just new to Oracle SQL, perhaps coming from a Microsoft SQL Server
environment, it may seem like the two versions should be very similar, and they
are, to a certain degree, but they are also very […]

A couple of alternative event 10046 resource profilers you might want to take a look at.
AppsDBA
Resource Profiler : "The AppsDBA resource profiler is a perl based event
10046 interval resource profiler. The resource profiler will parse an Oracle
event 10046 level 8 or higher trace file and create an interval resource profile
for each session found in the […]

Reading through the
comments
following on from my "Is
Oracle A Legacy Technology" posting, and in particular
Mogens
N rgaard’s reference to Jonathan Lewis’ comments about database
independence, made me think about another client I recently worked with.
This client had an application that, when a transaction was about to take
place, would request from the database a set of sequence […]

Oracle seeks to broaden
BI use with new offering : "Oracle Corp. is poised to make what a company
executive calls a "big push" in the business intelligence market in an effort to
get customers to take advantage of as much functionality as BI tools have to
offer.
At next month’s Oracle OpenWorld conference in San Francisco, the company
is […]

Lucas Jellema from Amis has written up an
excellent blog article
on a real-life use of table functions and the Oracle 10g model clause.

"From time to time there is a need in my SQL
queries to have access to a table with a specific number of records. Sometimes
I want to explode the results […]

One of the new features coming up in OWB "Paris" is "Experts", which allows
you to reuse OWB components to build your own custom ETL applications. A typical
use of this feature is to put together an "expert" script that obtains the name
of a file from a user, then imports the file into a table, carries out […]

Just a short note to say that I’m still here. It’s been incredibly
busy following the UKOUG event and I’m currently working for a client in Glasgow
doing some database and application tuning. Normal service will be resumed
in due course…