Let's do the ez one first.
On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] wrote:
> When I do a describe across the link I get "ORA-12663-Services required by
> the client not available on the server."
This is a bug, don't worry about it. The only fix is to upgrade your
database from 7.3 to 8.something. It only affects the 'describe' command.
> When I connect to the NT and run the query by hand it also hangs. But I
> can join the NT table to each of the AIX tables and get instant results - I
> just cannot join all three.
Turn tracing on for the session and check out the trace file. In all
likelihood the session is not actually hung, just running very slowly.
You can also monitor v$sess_io to see what activity is taking place
for the session.
Check out the explain plan. Do you have a copy of the explain plan
from when it worked? Of course you don't, neither does anyone else.
If you did, you could compare them. As it is, take a look at it, as it
may be rather revealing.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
