Re: Fwd: SQL tuning tip

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 18 Oct 2012 06:19:37 -0700 (PDT)
Message-ID: <1350566377.55554.YahooMailNeo_at_web121601.mail.ne1.yahoo.com>

• 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".   No, I did not.  Mohamed made comment on his strategy for investigating such problems which puts him squarely at the problem database with a SQL> prompt (as I read his response).  I never confused Mohamed with Prabhu, simply mentioned that Mohamed has access to the version information as he's investigating the problem.

David Fitzjarrell

---

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com> To: Oracle-L Freelists <oracle-l_at_freelists.org> Sent: Thursday, October 18, 2012 3:15 AM Subject: Fwd: SQL tuning tip

(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

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

Received on Thu Oct 18 2012 - 15:19:37 CEST