Fwd: SQL tuning tip

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Thu, 18 Oct 2012 10:15:58 +0100
Message-ID: <CAGRZYUdACuYDktau9QzxS1rO38heZjACF9f0CaxXGnhtS_AF=A_at_mail.gmail.com>

(copy to list)

Tim

To be fair, the OP is Prabhu Krishnaswamy, not Mohamed Houri. Mohamed is trying to help (as are we all of course).

If you go back through the thread, you see:

- Prabhu asks the question
- David Fitzjarall asks for a trace
- Mohamed asks for explain plan
- David also asks for version number
- Now Mohamed replies to justify that some help can be offered even

though the OP did not supply version
- David replies (in effect to Mohamed, although that isn't explicit) as if he is the OP "Yet you are logged into the problem database with the version information in full view at login". But Mohamed is not the OP and can't provide that. After that post, confusion reigns.

AFAIK, Prabhu who posted the original question hasn't yet provided any of the information he has been asked for, or responded in any way to the suggestions that have been made. It is Prabhu who needs to follow your (Tim's) advice on how best to help himself.

Now, keep calm and carry on!

Cheers

Nigel

On 18 October 2012 09:28, Tim Gorman <tim_at_evdbt.com> wrote:
> Mohamed,
>
> A gentle observation...
>

<snipped>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 18 2012 - 11:15:58 CEST