在一台服务器是正常的,另一台有问题如下:
SQL> SELECT count(t1.sFileID) FROM bms115.tfilecache t1 where ((Contains(t1.sdoc
info, 'About(sports arts) ', 1) > 0 or Contains(t1.scontext, 'About(sports arts) ' , 2) > 0));
COUNT(T1.SFILEID)
-----------------
872
Execution Plan
----------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=55 Card=1 Bytes=107)
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'TFILECACHE ' (Cost=55 Card=135 By
tes=14445)
上面TABLE ACCESS (FULL) OF 'TFILECACHE ' 在正常机器为Table Access(By Index RowID)
Statistics
----------------------
1378394 recursive calls
0 db block gets
1386185 consistent gets
2 physical reads
0 redo size
386 bytes sent via SQL*Net to client
503 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
------解决方案--------------------
没有用过,帮顶
------解决方案--------------------
顶
------解决方案--------------------
帮顶
------解决方案--------------------
极其诡异