Jim Dilanni On The Future Of Oracle Certification

Sunday, February 29th, 2004 by Mark Rittman

There’s an interesting interview over at CertCities.com, where Jim Dilanni, Oracle’s Director Of Certification, gives some background on the program’s changes over the past year, and discusses some of the changes we’re likely to see in the future.
Particularly interesting is the number of certifications at present (203000, with growth mainly in China and India), the […]

Twelve Silver Bullets For Oracle Performance Tuning

Friday, February 27th, 2004 by Mark Rittman

"Contrary to the pontifications of theoreticians and ivory-tower academics, there are many silver bullets for Oracle performance tuning. By silver bullet, I mean a small set of commands that quickly relieves an acute performance bottleneck. Some of these techniques of just-in-time tuning have been codified in Oracle10g with the Automatic Memory Management (AMM) facility, in […]

Don Burleson’s Questions To Ask Your Applications Vendor

Thursday, February 26th, 2004 by Mark Rittman

Don Burleson offers some useful
guidelines on what to ask of third-party application vendors whose
applications run on the Oracle platform. Don’s advice?

"If you are the victim of a shoddy Oracle vendor implementation,
insist on your right to be provided with complete and accurate Oracle
documentation. Remember, it’s your vendor’s responsibility to provide you with
[…]

Arup Nanda On Building Firewalls Using Oracle Net

Thursday, February 26th, 2004 by Mark Rittman

“Using a firewall to protect a server, and not just a database server, is not a new concept and has been around for a while. However, a firewall may be overkill in some cases. Even if a firewall is desirable, it may still have to be configured and deployed properly. The complexity in administering a […]

Online Interview With Matthew Symonds, Author Of “Softwar”

Wednesday, February 25th, 2004 by Mark Rittman

“Hi Mark,
I am a technology reporter with washingtonpost.com. I noticed your blog
on Oracle.
I will be hosting an online interview tomorrow with Matthew Symonds,
author of the recently released book “SOFTWAR: An Intimate Portrait of
Larry Ellison and Oracle.” Symonds will field questions about
business software company Oracle Corp. and its leader and co-founder.
In researching his book, Symonds had access […]

Inline Views And Outer Joins

Tuesday, February 24th, 2004 by Mark Rittman

I had an interesting question put to me at work yesterday, where a colleague was
having problems with an outer join in an SQL statement.
My collegue was putting together as system that recorded bids for contracts, storing the userid of the system operator, the details of the prospective client, and details of all the company’s sites, […]

Has Anyone Got TOra 1.2.4 On Linux Working Against Oracle Database 10g?

Tuesday, February 24th, 2004 by Mark Rittman

I’ve been trying to get TOra 1.2.4 to connect to an Oracle Database 10g installation, with both client and server on the same Red Hat 9.0 machine.
Unfortunately, although TOra starts up, as soon as I try and connect I keep coming up with the error “ORA 12705: invalid or unknown NLS parameter value specified”, […]

AskTom On SORT MERGE vs. HASH JOINS

Tuesday, February 24th, 2004 by Mark Rittman

Ever wondered what the difference is between the SORT MERGEs and HASH JOINs found in Explain Plans? Tom Kyte gives us the lowdown…

Peter Walzer On Ensuring The Success Of BI Projects

Tuesday, February 24th, 2004 by Mark Rittman

"Why do so many BI projects fail? For years we ve heard about the
potential value of BI, so why are the results often so disappointing in the eyes
of key BI project sponsors and stakeholders? A BI project can go quite smoothly
from a technical perspective and […]

OWB 9.2.0.4 Patchset Now Available

Monday, February 23rd, 2004 by Mark Rittman

Mark
Van De Wiel has advised that the 9.2.0.4 patchset for Oracle Warehouse
Builder 9.2 is now available on metalink,
using patch ID 3443542.
The patch is currently available for Windows and Solaris, with patches for
Linux, HP-UX, AIX and Tru-64 expected within the next month.
The patchset addresses bugs and issues with the 9.2 release, and the
resultant upgraded 9.2.0.4 version […]