Useful Sources of Oracle Reports Documentation

Wednesday, December 31st, 2003 by Mark Rittman

Someone recently asked me to recommend a good book for Oracle Reports, and I thought it worth jotting down my thoughts in this area, as it’s something I’ve been asked about a few times in the past.
Oracle Reports has traditionally ‘fallen between the cracks’ when it comes to books, usually getting bundled in with Oracle […]

Jonathan Gennick on the SQL Model Clause

Tuesday, December 30th, 2003 by Mark Rittman

“You’re writing a query that returns computed column values. As input to your calculations, you need values from multiple rows. What do you do? This is actually a fairly common problem. Solutions to it often involve inscrutable combinations of self-joins and subqueries.
Oracle Database 10g enables a new approach. Using the SELECT statement’s new MODEL clause, […]

Guide To Online Oracle Support Resources

Monday, December 29th, 2003 by Mark Rittman

Jonathan Lewis recently posted a guide on comp.databases.oracle.server to the best online resources for answering Oracle questions. A couple of them were new to me, so I thought it worth mentioning them here.

The Co-operative Oracle Users’ FAQ - a whole list of Oracle frequently asked questions hosted on Jonathan’s site
Steve Adams’ Ixora Web Site - […]

New Look For Website

Sunday, December 28th, 2003 by Mark Rittman

You’ve probably noticed that the site has gone through a makeover in time for the New Year. It’s largely been driven by the move to Moveable Type as the engine behind the site, but I’ve taken the opportunity to add a few new features as well, including category archives, a better search engine, and listings […]

Happy Christmas!

Tuesday, December 23rd, 2003 by Mark Rittman

Well that’s it for 2003. I’m going to spend the next week or so eating too many mince pies, helping my son open his presents, and watching too much television. Have an excellent Christmas and New Year, and see you all in January!

The Register On Oracle 10g

Monday, December 22nd, 2003 by Mark Rittman

“It really does appear that Oracle has done enough to make the grid built out of commodity servers a practical and economic reality. As a by-product it has made the management of smaller systems easier as well.” writes Peter Abrahams for The Register.

TOra, The Linux Alternative To TOAD

Monday, December 22nd, 2003 by Mark Rittman

One of my New Year Resolutions is to move my work laptop over to Linux, to be more in sync with Oracle’s development effort and to benefit from the extra performance that you get from running Oracle on a Unix platform. One of the things that’s put me off in the past is the thought […]

More On Database And Application Tuning

Monday, December 22nd, 2003 by Mark Rittman

I’ve just come back from an initial couple of days at a client site, where we’re looking at tuning up their data warehouse. I’d previously mentioned one of the areas we’d looked at (function-based indexes), and having done a bit more research, I thought it worth mentioning one of the sites I’d come across that looked […]

Integrating Discoverer 9iAS Logins And Database Logins

Wednesday, December 17th, 2003 by Mark Rittman

“When using Discoverer 9iAS (the one that comes with 9iASr2) and public connections, the row-level security i’d set up on the Oracle database doesn’t work any more. How can we integrate the SSO logins and discoverer logins such that our database row-level security now works?“

I had a similar situation happen with a recent client, and this […]

Metalink Note On Using The OWB Design Browser With The Standalone OC4J Instance

Wednesday, December 17th, 2003 by Mark Rittman

If you’re looking to use the web-based Design Browser that comes with OWB 9.0.4 and 9.2, and want to deploy it using the new built-in OC4J instance, there’s a new Metalink note No. 237367.1 that goes through all the steps required to set it up.
In the past, to use the Design Browser you had to […]