Rittman Mead - Delivered Intelligence

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 different in [...]

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

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

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

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