Jonathan Lewis wrote:
> That depends on whether it is a built-in
> function an external function - and I think
> it's a built-in.
>
> I'm also curious about the 'context switch' bit -
> it gets mentioned from time to time, but there
> really isn't a "context switch" in the normal
> meaning of the term - it's all happening without
> interruption in the oracle executable. Can
> you clarify what it is that is considered to be the
> context switch in that case ?
>
>
> "Frank" <fbortel_at_nescape.net> wrote in message
> news:bptt05$6bl$1_at_news3.tilbu1.nb.home.nl...
>
>>Jonathan Lewis wrote:
>>
>>
>>>You might go one step further and check if
>>>the (undocumented) function
>>> sys_op_map_nonnull()
>>>works a little faster.
>>>
>
>
>>But that would still be a function call.
>>Context switch - overhead - performance loss.
>>--
>>Regards, Frank van Bortel
>>
>
>
>
Within Oracle, SQL vs. PL/SQL
I was more referring to O/S switches,
like between subprocesses.
--
Regards, Frank van Bortel
Received on Tue Nov 25 2003 - 15:24:39 CST
