To improve performance with Oracle Text based searches in Oracle Portal, you should on a regular basis make sure to syncronize and optimize Portal text indexes (if this is not allready set up during installation).
sqlplus portal/<password> exec wwv_context.sync exec wwv_context.optimize exit
Trackback this post