Skip to content

Daily Archives Thursday, October 2008

Manual Optimisation 3

[Back to Manual Optimisation part 2]
This little series started from a note I wrote about manual optimisation where I took advantage of a sort operation in a non-mergeable view to produce sorted data from a final nested loop join without including an “order by” that would have produced a large sort operation.
In fact, as I [...]

Posted 23 October 2008 † Jonathan Lewis § Uncategorized ‡ Comments Off °

Automatic migration of a Discoverer EUL to an OBIEE Repository

The latest release of OBIEE, version 10.1.3.4 comes with a brand new demo repository and dashboards, that Mark already talked about, in this post. This is not the only new thing to come with this latest release. For the first time now, Oracle makes available a tool that allows the BI administrator to automatically generate [...]

Posted 23 October 2008 † Borkur Steingrimsson § Uncategorized ‡ Comments Off °

Leo: The Mouse Master

The day of an 11 month old boy:

Stalk Mouse - Check
Attack Mouse - Check
Wrestle on the floor with mouse - Check
Kill Mouse - Check
Nap - Check

Life is good.
LewisC

Technorati : family, fun, off topic, photo

Posted 23 October 2008 † An Expert's Guide to Oracle Technology § Uncategorized ‡ Comments Off °

Firefox Still Pwns the Field

Generally, I prefer choice in software. Intertubes browser is no different.

However, in this particular category, I am an unabashed Firefox fanboy. I’ve been using it since 0.8, and it hasn’t let me down yet.
I’ve tried the field, both for personal and professional purposes: Chrome, Opera, Flock, Safari, IE (all versions, 3-8), Netscape/Mosaic, even good old [...]

Posted 23 October 2008 † Jake § Uncategorized ‡ Comments Off °

Blog Anniversary

Sing along with me now…
Happy Anniversary to my blog. It’s been two years as of today. And as Tom Kyte foretold, there has been a lot about “disk” on this blog.
This blog has had nearly 1 million page views to date and while I’d like to say it has been all fun and games it [...]

Posted 23 October 2008 † kevinclosson § Uncategorized ‡ Comments Off °

On Cursor FOR Loops (Q&A)

My mentor told me that when querying data I should always use a cursor FOR loop, even for a single row lookup. He says it’s the easiest way to fetch data, and Oracle Database automatically optimizes it in Oracle Database 10g and above. Do you recommend this practice?

Posted 23 October 2008 † PL/SQL Best Practices § Uncategorized ‡ Comments Off °

Qualifying All References (Q&A)

My DBA told me to put the names of my procedures and functions in front of any variables referenced inside SQL statements that I write in PL/SQL programs. This seems like a major hassle. Why should I bother with it?

Posted 23 October 2008 † PL/SQL Best Practices § Uncategorized ‡ Comments Off °