INDEXTYPE IS "CTXSYS"."CONTEXT"  PARAMETERS ('SYNC (ON COMMIT)')  PARALLEL 4

SELECT DISTINCT di.*
FROM indexed_content di
WHERE contains(di.title, '%' || :text || '%') > 0
ORDER BY title DESC

SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$TITLE_TEXTIDX$X")*/ DISTINCT 
  TOKEN_TEXT  FROM "QA"."DR$TITLE_TEXTIDX$I" T WHERE TOKEN_TEXT LIKE 
  :lkexpr ESCAPE '\' AND (TOKEN_TYPE = 0 OR TOKEN_TYPE = 4 OR (TOKEN_TYPE 
  BETWEEN 16 AND 74)  OR (mod(TOKEN_TYPE, 10000) between 1001 and 1333))

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.19      42.32       3237       3237          0          25
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.19      42.32       3237       3237          0          25

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 70     (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
        25         25         25  SORT UNIQUE NOSORT (cr=3237 pr=3237 pw=0 time=6447294 us cost=4 size=15181 card=323)
        25         25         25   INDEX RANGE SCAN DR$TITLE_TEXTIDX$X (cr=3237 pr=3237 pw=0 time=40171389 us cost=3 size=15181 card=323)(object id 20105)

=====================
PARSING IN CURSOR #47226043359600 len=294 dep=1 uid=70 oct=3 lid=70 tim=1474897270953604 hv=3993624360 ad='e489ad78' sqlid='2c5qbkvr0mrt8'
SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$TITLE_TEXTIDX$X")*/ DISTINCT TOKEN_TEXT  FROM "QA"."DR$TITLE_TEXTIDX$I" T WHERE TOKEN_TEXT LIKE :lkexpr ESCAPE '\' AND (TOKEN_TYPE = 0 OR TOKEN_TYPE = 4 OR (TOKEN_TYPE BETWEEN 16 AND 74)  OR (mod(TOKEN_TYPE, 10000) between 1001 and 1333))
END OF STMT
PARSE #47226043359600:c=0,e=235,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=1474897270953603
EXEC #47226043359600:c=1000,e=874,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=1600871725,tim=1474897270954521

*** 2016-09-26 08:41:53.279
FETCH #47226043359600:c=196970,e=42324683,p=3237,cr=3237,cu=0,mis=0,r=25,dep=1,og=1,plh=1600871725,tim=1474897313279251
STAT #47226043359600 id=1 cnt=25 pid=0 pos=1 obj=0 op='SORT UNIQUE NOSORT (cr=3237 pr=3237 pw=0 time=6447294 us cost=4 size=15181 card=323)'
STAT #47226043359600 id=2 cnt=25 pid=1 pos=1 obj=20105 op='INDEX RANGE SCAN DR$TITLE_TEXTIDX$X (cr=3237 pr=3237 pw=0 time=40171389 us cost=3 size=15181 card=323)'
CLOSE #47226043359600:c=0,e=6,dep=1,type=0,tim=1474897313279820
=====================