Michael, Did you try this with the DRIVING_SITE hint? (May not help, but worth trying). My understanding is that where a STOPKEY such as rownum is involved, the table (or the result of the query) would be brought across the dblink into the local TEMP tablespace and the STOPKEY applied lare on. What you are seeing is the time for the whole table to be brought across via the DBlink and the condition applied after that. A look at 'V$MYSTAT' for that session should normally show an inordinately large value for 'bytes received via SQL*Net from dblink', and you should also see corresponding waits on 'SQL*Net message from dblink.
John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** -----Original Message----- Sent: Tuesday, June 04, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Hi, Could anybody help me with the database link problem? I have two databases db_A and db_B, and link from db_A to db_B. In the database db_B there is table B with 1.6 million records. I created simple test to query data from the table B via database link (I am connected to db_A) ------------------------------------- declare v_record B%rowtype; cursor cB is select * from [EMAIL PROTECTED] where rownum < 20000; begin for c in cB loop v_record :=c; end loop; end; ------------------------------- I tried to check performance of data querying through the link, so I had two tests: - via the link - 19.8 sec - locally - 1.5 sec Difference is too large, as far as I can expect! I have been REALLY surprised. At this time there was mostly no other activity on the network (databases are on the same subnet, at the same hierarchical level). Could anybody explain is it normal results? Thanks, Michael Rosenblum, Dulcian Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).
