Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I tell if ConText indexing is making progress?
You need to have a look at the services and Text DML queues to see what is
happening. Depending on the size and format of the documents though it may
take over an hour. If things aren't going well, it is most likely that
context has got itself 'stuck' on indexing a particular document. This sort
of thing doesn't usually happen with straight text documents but is not
uncommon with MS Word and other documents who's format changes with version.
You can view the queues via the Context Option System Admin tool or by
examining the contents of the drq_pending, drq_waiting and ctx_svcq tables.
If a document is 'stuck', it will be sitting in the drq_waiting table for a
long time going nowhere.
Hope this helps
Rod J. Stewart
JonnyA_at_my-dejanews.com wrote in message <74p5jm$qiu$1_at_nnrp1.dejanews.com>...
>I'm trying to re-create an index on about 2500 documents. The server is
very
>powerful and has plenty of resources, but the call to
ctx_ddl.create_index()
>runs for over an hour without returning. The index existed just fine
earlier
>this morning. It's taken far less time to build in the past.
>
>Is there any way to check whether any progress is being made, or should I
>assume at this point that there's a loop somewhere? The ctx_all_servers
view
>shows that one of our "DM" personality servers is busy.
>
>
>Bonus question: Where should I look for the possible cause of the indexing
>problems?
>
>
>Details, details: Oracle7.3 on Solaris, ConText 2.3, new master-detail
>configuration, preferences and policies are created without a hitch.
>
>Thanks for your time.
> -Jon.
>--
> Jon Atkinson * Senior Developer * Virtual Frontiers
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Dec 10 1998 - 18:46:42 CST