Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: why administrator refuse to give permission on PLUSTRACE

Re: why administrator refuse to give permission on PLUSTRACE

From: Peter J. Holzer <>
Date: Sun, 4 Nov 2007 00:17:08 +0100
Message-ID: <>

On 2007-11-03 20:19, DA Morgan <> wrote:
> Peter J. Holzer wrote:
>> On 2007-11-03 16:25, DA Morgan <> wrote:
>>> Listen to yourself for a second. A Java developer writes code that runs
>>> on an application server.

>>> This person's knowledge of wait events is precisely zero. Likely they
>>> can't even construct a decent WHERE clause.
>> If they can't do this they have no business writing software which sends
>> SQL queries to an RDBMS. Let somebody else who does have some clue about
>> databases design a middle tier which they can connect to. Or send them
>> to training or fire them - but for heaven's sake don't let them write
>> code which runs on your hallowed production database.
> Do you know a single Java developer that knows how to run an Explain
> Plan?

You got me there. The competent programmers I know mostly seem to avoid Java when they can.

But since at least half of the Java Programmers I know do have a background in PL/SQL programming I should hope they know how to use Explain Plan. I wouldn't bet on it, though.

And I do know a FORTRAN programmer who knows very well how to use explain plan and probably a lot more about Oracle performance than most DBAs. I'd expect C programmers (which was the other language you mentioned) also generally to know what they are doing.


   _  | Peter J. Holzer    | It took a genius to create [TeX],
|_|_) | Sysadmin WSR       | and it takes a genius to maintain it.
| |   |         | That's not engineering, that's art.
__/   | |	-- David Kastrup in comp.text.tex
Received on Sat Nov 03 2007 - 18:17:08 CDT

Original text of this message