OraFAQ Forum: SQL & PL/SQL » SQL*Net message from db link Doubt

Home » SQL & PL/SQL » SQL & PL/SQL » SQL*Net message from db link Doubt (Oracle 11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Net message from db link Doubt [message #630612]

Wed, 31 December 2014 05:12

tigsav
Messages: 49
Registered: April 2012

Member

Hello All,

I Have a doubt :

I have a query which is executing over a db link.
Suppose my query is :

select * from dual@test_link;
On a Assumption that this query takes fairly heavy resources ,then which db's AWR will be showing the wait event : SQL*Net message from db link Doubt

Regards,
tigsav

Report message to a moderator

Re: SQL*Net message from db link Doubt [message #630615 is a reply to message #630612]

Wed, 31 December 2014 06:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the local DB'S AWR report

Report message to a moderator

Re: SQL*Net message from db link Doubt [message #630618 is a reply to message #630612]

Wed, 31 December 2014 07:50

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Who says the remote DB even IS an Oracle DB AND IS configured to have AWR? YOur local oracle DB certainly can't depend on that.

Report message to a moderator

Re: SQL*Net message from db link Doubt [message #630619 is a reply to message #630612]

Wed, 31 December 2014 08:08

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Think a little bit.
Which db can wait for "SQL*Net message from db link" due to this query?

      give me the dual row 
db1 ------------------------> db2
         here's the row
    <------------------------

Who can wait for something from the db link?

Report message to a moderator

Previous Topic:	How to define Package Name in Reports Builder / REP-0069
Next Topic:	filling summary table from detail and updating the detail with summary reference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:21:16 CDT 2024