spool someFILEname
select 'alter table '||table_name||' cache;' from user_tables where table
name like 'DR%';
spool off
@someFILEname
exit
DSmith wrote in message <37146680.0_at_208.206.112.5>...
>All,
>
>We're running ConText 2.3.6 on 8.0.4 on NT to provide text search &
>retrieval of documents that have been OCR'd. We have noticed that there
>appears to be a lot of disk activity associated with each search a user
>initiates.
>
>I assume that ConText is searching the DRSYS indices and not the text data
>when executing a keyword search -- is this correct? If so, is there a way
>to load these indices into system memory to avoid the delays associated
with
>disk access?
>
>Any info would be greatly appreciated.
>
>--David Smith
>dsmith_at_hpti.com
>
>
Received on Thu Apr 15 1999 - 06:53:25 CDT
