????ORACLE??????λ????????????????????alter index rebuil?????SQL??????????15??????????????2???????????????????м??

SQL> set autotrace traceonly
SQL> SELECT SEQ_PAY_CUSTOMEROPER.Nextval??u.ID??'admin'??1??t.LAST_LOGIN_TIME??t.LOGIN_TIMES??t.LOGIN_IP
  2       FROM EFB_USER_MOVE@WODBLINK t??T_PAY_USERINFO u
  3       WHERE t.ID = u.ID AND u.ID > 3500000 AND u.ID<400000
 AND t.ID > 3500000 AND t.ID <= 4000000
  4  /

123832 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 4225832519

-----------------------------------------------------------------------------------------------------------
| Id  | Operation          | Name                 | Rows  | Bytes | Cost (%CPU)| Time     | Inst   |IN-OUT|
-----------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |                      |     1 |    77 |     5   (0)| 00:00:01 |        |      |
|   1 |  SEQUENCE          | SEQ_PAY_CUSTOMEROPER |       |       |            |          |        |      |
|   2 |   NESTED LOOPS     |                      |     1 |    77 |     5   (0)| 00:00:01 |        |      |
|*  3 |    INDEX RANGE SCAN| PK_T_PAY_USERINFO    |     1 |     6 |     3   (0)| 00:00:01 |        |      |
|   4 |    REMOTE          | EFB_USER_MOVE        |     1 |    71 |     2   (0)| 00:00:01 | WODBL~ | R->S |
-----------------------------------------------------------------------------------------------------------

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

   3 - access("U"."ID">3500000 AND "U"."ID"<=4000000)

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

   4 - SELECT "ID"??"LAST_LOGIN_TIME"??"LOGIN_TIMES"??"LOGIN_IP" FROM "EFB_USER_MOVE" "T" WHERE
       "ID"<=4000000 AND "ID">3500000 AND "ID"=:1 (accessing 'WODBLINK' )

 

Statistics
----------------------------------------------------------
      86691  recursive calls
      18753  db block gets
      14781  consistent gets
          0  physical reads
    4035364  redo size
    5163224  bytes sent via SQL*Net to client
      91297  bytes received via SQL*Net from client
       8257  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
     123832  rows processed

???????SQL????????????????????SQL?м??????м??????????

???????SQL?????123832????????????м???????nested loops?????????????????????EFB_USER_MOVE?????DBLINK???????????????????EFB_USER_MOVE??????????????????????ж????У???????CBO???????????1?У??????????123832???????????????SQL?????HINT

SELECT /*+ full(u)*/ SEQ_PAY_CUSTOMEROPER.Nextval??
       u.ID??
       'admin'??
       1??
       t.LAST_LOGIN_TIME??
       t.LOGIN_TIMES??
       t.LOGIN_IP
  FROM EFB_USER_MOVE@WODBLINK t?? T_PAY_USERINFO u
 WHERE t.ID = u.ID
   AND u.ID > 3500000
   AND u.ID < 400000
   AND t.ID > 3500000
   AND t.ID <= 4000000;

????????SQL?????????????????sequence????????????????123832??????????sequence???cache??С??????????SQL????????????cache??1000

???????????SQL??????????DBLINK?????????????????????SQL???DBA???HINT??????????DBLINK???????????????????е???? ???????????driving_site???HINT??????????岻??????