Re: Weird OPTIMIZER behavior for SQL*Net queries

Without extra information it is impossible to resolve this issue. What is the version of Oracle?
What is the platform?
What do you mean by 'direct connection': a sql*plus session on the server itself by means of IPC or BEQ.
What is that query and what are the execution paths. I'm asking this because the optimizer is the optimizer, there shouldn't been any difference, and there are no settings that take sqlnet into account. There must exist some difference on your side, maybe the optimizer_goal setting modified by login.sql, or something like that.

Hth,

--
Sybrand Bakker, Oracle DBA

Jerzy Tomasik <jerzy_at_tus.ssi1.com> wrote in message news:37D0A5B2.BC9E5FE6_at_tus.ssi1.com...
> Hi,
>
> I'm seeing a strange performance problem. The same query performs very
> well when executed
> with a direct connection (e.g. sqlplus scott/tiger) and very poorly when
> executed through SQL*Net
> (e.g. sqlplus scott/tiger_at_mydb). Running the analyzer shows that the
> execution path is different in
> both cases.
> BTW, the query generates virtually no network traffic (returns just a
> count).
>
> Is there any way I can control or force the optimizer to behave the same
> way for a query
> coming through SQL*Net as it does for local queries?
> I've read the docs about the hints, etc, but I haven't seen anything
> that seems to be the answer.
>
> TIA,
>
> -Jerzy
>
Received on Sat Sep 04 1999 - 02:06:56 CDT