Re: "Row Source Operation" missing from tkprof output
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: vbarac@xxxxxxxxxxxx
- Date: Wed, 31 Dec 2008 10:59:35 +0100
Hi Vladimir
As we have spoken in our mails I have mentioned the cursors must be closed
if you want to see the execution plans and the row source operations.
Regards
--
LSC
On Wed, Dec 31, 2008 at 10:30 AM, Vladimir Barac <vbarac@xxxxxxxxxxxx>wrote:
> Hi, listers
>
>
>
> I am facing a bit strange situation, so maybe somebody had experienced this
> before…
>
>
>
> When 10046 tracing some procedure (executed manually at SQL*Plus prompt or
> as a part of some other procedure), TKPROF doesn't show "Row Source
> Operation" at all.
>
>
>
> If I take out statements (all are updates) and execute them manually or as
> a part of unnamed PL/SQL block, TKPROF will show "Row Source Operation" and
> everything is fine.
>
>
>
> What could be the reason for this?
>
>
>
> All pointers to enlightenment are welcomed,
>
>
>
> Vladimir Barac
> Database administrator | Alghanim Industries
> P.O. Box 223, Safat 13003, Kuwait
> Tel: +965 1881 111 / ext. 2960
>
>
>
> ______________________________________________________________________
> This e-mail message and any attachments to it are for the sole use of the
> intended recipients and may contain confidential and privileged information.
> This e-mail message and any attachments are the property of Yusuf A.
> Alghanim & Sons w.l.l. or any of its subsidiaries or affiliates ("Alghanim
> Industries"). Any unauthorized review, use, disclosure, or distribution of
> this e-mail message or its attachments is prohibited. Any opinions expressed
> in this message are those of the author and do not necessarily reflect the
> opinion of Alghanim Industries. If you are not an intended recipient, please
> notify the sender by reply e-mail and destroy all copies of the original
> message and any attachments.
> ______________________________________________________________________
>
Other related posts:
