DBLINK ????????????SQL????
???????????? ???????[ 2013/5/10 10:00:26 ] ????????
????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??????????岻??????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11