Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)
There are some useful hints in this SO post.

If you are looking for alternatives to Oracle Text, have a look at this.