Re: what happens in the single-task message?
Date: Tue, 2 Dec 2008 10:52:33 +0000
Maintenance of the Context Index might be responsible for this, though I'm not sure I'd have expected it to show in the same trace, since my understanding in 8i was that context index maintenance was done via an entirely separate job.
anyway since this is a guess based on hazy memories of context in 8174 going back 8 years or so now, you'd be best to test it. My plan for that would be simply to create an identical table without the context index and repeat the experiment.
On Tue, Dec 2, 2008 at 10:44 AM, Martin Busik <martin.busik_at_busik.de> wrote:
> Hi Martin,
> > it's the client (similar to two-task, but just single-task)
> a jdbc client is using a prepared statement. 15 times a value gets
> bound (varchar2 and number, no blobs), then execute is called.
> Which part of this sequence may be covered by the single-task message?
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 02 2008 - 04:52:33 CST