Mark Rittman

It's almost that time of year again, and in a couple of days we'll be off to Ireland for the Christmas break to stay with Janet's family (Note to burglars - the house has an alarm and the neighbours are in next door) As

Nicholas Goodman [http://www.bayontechnologies.com/bt/blog/] is running another article in hisOracle Warehouse Builder "Paris" early review series [http://www.bayontechnologies.com/bt/blog/archives/2004/09/owb_paris_early.php], this time on thedata profiling feature within "Paris" [http://www.bayontechnologies.com/bt/

The other week I wrote an article on adatabase tuning engagement [http://www.rittman.net/archives/001129.html]I'd been on, and one of the things that I looked at during the visit was a SELECT statements that was being executed in parallel. After running the statement with

"Oracle and Java Stored Procedures", Michael Klaene [http://www.developer.com/db/article.php/10920_3337411_1] : "Beginning with version 8i, the Oracle database includes a fully functional Java Virtual Machine, Oracle JVM. Out of this close relationship between Oracle and Java emerges an important technology for

Lucas Jellema has put together an informative Amis Blog article on aprivate session he'd recently on Enterprise Planning & Budgeting [http://technology.amis.nl/blog/index.php?p=298]. A lot of what's in it I covered in my previous "Under The Covers With Enterprise

If you came along to the Open Word Discoverer "Drake" presentations, or had a look at the presentations and papers available for download, you'll probably have noticed that a major theme for Drake is the provision of BI "Dashboards". Built using Oracle Portal and

One of the major announcements at Open World was forOracle Database 10g Release 2 [http://www.oracle.com/technology/products/database/oracle10g/pdf/10gr2_highlights.pdf] . This next release of the Oracle RDBMS isn't likely to be available for download until the middle of 2005, but some initial

Now that I'm back from Open World, there's a chance now to start taking a look through all of the papers and presentationsavailable to download [https://www.openworld2004.com/sf/scheduler/controller/catalog] from the conference website. One of the features of actually being at Open

Wednesday is keynote day, and I mentioned before [http://www.rittman.net/archives/001157.html] that I watched Chuck Rozwat's and Scott McNealy's keynotes from speaker room as I frantically tried to get my AWM10g / Drake demo working again. If you're coming along tomorrow,

[http://www.kinggeorge.com/index1.html]Well, I've arrived in San Francisco now and got settled in to my hotel. I arrived about 2.00pm local time after an 11 hour flight, so had a quick wander around the area local to my hotel, got something to eat

I recently came across some free online training on OWB that anyone looking to get into the product, or bring their product knowledge up to date, might find useful. The training homepage is at http://www.oracle.com/technology/products/warehouse/selfserv_edu/self_service_education.html and breaks the

> "What is the definition and purpose of an olap catalog? how can I create one? what do I add to it? and how do I add things to it? I am using Oracle 10g with JDeveloper 9.0.4 and BI Beans 9.0.4" The OLAP

A selection of books that I've been looking at recently. [http://www.amazon.co.uk/exec/obidos/ASIN/007222729X/qid=1101645531/markrittmansh-21/026-3961103-0724440] Imentioned the other week [http://www.rittman.net/archives/001129.html]that I had recently ordered Richmond Shree's and Kirtikumar Deshpande's&

Over the last couple of weeks I posted a couple of articles that generated a lot of feedback, so much so that I thought it worth posting an update article summarising some of the comments I received. The articles were on subjects that tend to pretty much divide the Oracle

If you've been looking at the available material and presentations [http://www.rittman.net/archives/001101.html] on Enterprise Planning & Budgeting [http://www.oracle.com/applications/epb.html], you've probably got a good idea now of the capabilities of this new product. What isn'

> "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

> "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

A couple of alternative event 10046 resource profilers you might want to take a look at. AppsDBA Resource Profiler [http://home.comcast.net/~arivenes/utilities_resource.htm] : "The AppsDBA resource profiler is a perl based event 10046 interval resource profiler. The resource profiler will parse an Oracle event 10046

Beginning SQL: Differences Between Oracle and Microsoft [http://www.nocoug.org/download/2004-05/BegSQL.pdf] 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

Reading through thecomments [http://www.rittman.net/mt/mt-comments.cgi?entry_id=1130]following on from my "Is Oracle A Legacy Technology" [http://www.rittman.net/archives/001130.html] posting, and in particularMogens N rgaard's reference [http://www.rittman.net/mt/mt-comments.cgi?entry_id=1130]

Lucas Jellema from Amis has written up anexcellent blog article [http://technology.amis.nl/blog/index.php?p=266]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

Oracle seeks to broaden BI use with new offering [http://www.adtmag.com/article.asp?id=10261] : "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

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

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...

It's almost time again for the UKOUG Conference & Exhibition [http://conference.ukoug.org], 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