Enable Network Tracing and check. GovindanK
> I'm confused, has anyone ever seen something like this before? > > This query works as you can see: > > select count(*) > from [EMAIL PROTECTED]; > > COUNT(*) > ---------- > 275375 > > We execute the following DDL: > > DROP SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS; > > CREATE SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS > FOR [EMAIL PROTECTED]; > > We run the following query: > select count(*) > from mv_user_enabled_doc_type_privs; > > The query hangs for over an hour before being killed. When traced it > shows it is waiting for the other side to respond. > > On the other hand, if I do this you can see it works! > > 1* select count(*) from [EMAIL PROTECTED] > SQL> / > > COUNT(*) > ---------- > 0 > > SQL> create synonym mine for [EMAIL PROTECTED]; > > Synonym created. > > SQL> select count(*) from mine; > > COUNT(*) > ---------- > 0 > > The hanging behavior is true for every table in the markview schema. >> Allan L. Nelson >> Oracle DBA >> M-I L.L.C. >> (832) 295-2238 office >> (832) 351-4180 fax >> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> >> >> > > ______________________________________________________________________________ > This email is intended solely for the person or entity to which it is > addressed and may contain confidential and/or privileged information. > Copying, forwarding or distributing this message by persons or entities > other than the addressee is prohibited. If you have received this email in > error, please contact the sender immediately and delete the material from > any computer. This email may have been monitored for policy compliance. > [021216] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
