047.【实验：测试DRIVING_SITE】

SQL> select /*+ */ *
2 from scott.t_group1 t,t_zt@link1 z
3 where z.id=t.id and t.id between 10 and 30;

42 rows selected.

Execution Plan
----------------------------------------------------------
Plan hash value: 2335399746

--------------------------------------------------------------------------------
------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Ti
me | Inst |IN-OUT|

--------------------------------------------------------------------------------
------------------------

| 0 | SELECT STATEMENT | | 1 | 21 | 6 (0)| 00
:00:01 | | |

| 1 | TABLE ACCESS BY INDEX ROWID| T_GROUP1 | 1 | 15 | 3 (0)| 00
:00:01 | | |

| 2 | NESTED LOOPS | | 1 | 21 | 6 (0)| 00
:00:01 | | |

| 3 | REMOTE | T_ZT | 1 | 6 | 3 (0)| 00
:00:01 | LINK1 | R->S |

|* 4 | INDEX RANGE SCAN | IDX_ID | 1 | | 2 (0)| 00
:00:01 | | |

--------------------------------------------------------------------------------
------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

4 - access("Z"."ID"="T"."ID")
filter("T"."ID"<=30 AND "T"."ID">=10)

Remote SQL Information (identified by operation id):
----------------------------------------------------

3 - SELECT "ID","USER_YN" FROM "T_ZT" "Z" WHERE "ID"<=30 AND "ID">=10 (access
ing

'LINK1.REGRESS.RDBMS.DEV.US.ORACLE.COM' )

Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
91 consistent gets
0 physical reads
0 redo size
1966 bytes sent via SQL*Net to client
407 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
42 rows processed

SQL> set linesize 1000;

SQL> select /*+ driving_site(z) */ *
2 from scott.t_group1 t,t_zt@link1 z
3 where z.id=t.id and t.id between 10 and 30;

42 rows selected.

Execution Plan
----------------------------------------------------------
Plan hash value: 1539210871

--------------------------------------------------------------------------------
-------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| T
ime | Inst |IN-OUT|

--------------------------------------------------------------------------------
-------------------------

| 0 | SELECT STATEMENT REMOTE | | 1 | 21 | 6 (0)| 0
0:00:01 | | |

| 1 | NESTED LOOPS | | 1 | 21 | 6 (0)| 0
0:00:01 | | |

| 2 | TABLE ACCESS BY INDEX ROWID| T_ZT | 1 | 6 | 3 (0)| 0
0:00:01 | ORA10~ | |

|* 3 | INDEX RANGE SCAN | PRY_T_ZT | 1 | | 2 (0)| 0
0:00:01 | ORA10~ | |

| 4 | REMOTE | T_GROUP1 | 1 | 15 | 3 (0)| 0
0:00:01 | ! | R->S |

--------------------------------------------------------------------------------
-------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("A1"."ID">=10 AND "A1"."ID"<=30)

Remote SQL Information (identified by operation id):
----------------------------------------------------

4 - SELECT "ID","BIZ_DATE","USER_YN","BIZ_DATE1","USER_YN1","BIZ_DATE2","USER
_YN2","BIZ_DATE3"

,"USER_YN3","BIZ_DATE4","USER_YN4","BIZ_DATE5","USER_YN5" FROM "SCOTT"."T
_GROUP1" "A2" WHERE

"ID"<=30 AND "ID">=10 AND :1="ID" (accessing '!' )

Note
-----
- fully remote statement

Statistics
----------------------------------------------------------
49 recursive calls
0 db block gets
126 consistent gets
0 physical reads
0 redo size
2056 bytes sent via SQL*Net to client
407 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
42 rows processed

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7901922/viewspace-1060030/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7901922/viewspace-1060030/