INSERT INTO search_results  SELECT /*+ ALL_ROWS DOMAIN_INDEX_SORT 
  USE_NL(item_tl item)*/ score(1), item_tl.item_itemid FROM item_tl, item 
  WHERE item_tl.lang ='US' AND item_tl.item_itemid=item.itemid AND  
  contains(item_tl.ctx_desc, '((({@@rvq@101708@graybar_kennametal@}, 
  {@@rvq@101708@jl_kennametal@}, {@@rvq@101708@newpig_kennametal@}, 
  {@@rvq@101708@scottelectric_kennametal@}, 
  {@@rvq@101708@shannonsafety_kennametal@}, 
  {@@rvq@101708@shuttlechem_kennametal@}, {@@rvq@101708@stauffer_kennametal@},
   {@@rvq@101708@grainger_kennametal@}, {@@rvq@101708@xpedx_kennametal@})))
  *10 & (${itemname${countval}}%)', 1) > 0  AND rownum <= 100 AND 
  item.A101764= 'production' ORDER BY score(1) DESC


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        2      0.83       0.91          0       1588          0           0
Execute      2      0.01       0.00          0          0          2           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.84       0.91          0       1588          2           0

Misses in library cache during parse: 2
Optimizer mode: CHOOSE
Parsing user id: 33  

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  COUNT STOPKEY 
      0   NESTED LOOPS 
      0    TABLE ACCESS BY INDEX ROWID ITEM_TL 
      0     DOMAIN INDEX 
      0    TABLE ACCESS BY INDEX ROWID ITEM 
      0     INDEX RANGE SCAN (object id 21722)

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  single-task message                             2        0.54          1.00
  SQL*Net message from client                     8        0.03          0.07
  SQL*Net break/reset to client                   4        0.00          0.00
  SQL*Net message to client                       6        0.00          0.00

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      113      5.19       5.33          0       9152          0           0
Execute    113      7.25       7.29          0      51134         16           0
Fetch       96      0.09       0.09          0        476          8         140
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      322     12.53      12.71          0      60762         24         140

Misses in library cache during parse: 27

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message from client                 17804       20.03       1147.68
  SQL*Net message to client                     628        0.00          0.00
  SQL*Net more data from client                   8        0.00          0.00
  log file sync                                   8        0.01          0.02
  single-task message                         17056        1.10          7.15
  SQL*Net break/reset to client                   4        0.00          0.00
  library cache lock                              2        0.02          0.03
  latch free                                      1        0.00          0.00


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse     3769      0.64       0.59          0          0          0           0
Execute   3996      0.15       0.16          0         48         24          16
Fetch    20819      3.09       2.85          0      54940          0      233221
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    28584      3.88       3.60          0      54988         24      233237

Misses in library cache during parse: 7

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message from client                 16937        0.01          0.34
  SQL*Net message to client                   17057        0.01          0.04
  SQL*Net more data to client                  1836        0.01          0.15

  149  user  SQL statements in session.
 3733  internal SQL statements in session.
 3882  SQL statements in session.
********************************************************************************
Trace file: mmprod_ora_21884.trc
Trace file compatibility: 8.00.04
Sort options: default

       1  session in tracefile.
     149  user  SQL statements in trace file.
    3733  internal SQL statements in trace file.
    3882  SQL statements in trace file.
      37  unique SQL statements in trace file.
  134683  lines in trace file.
    2823  elapsed seconds in trace file.