Re: what happens in the single-task message?
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: martin.busik@xxxxxxxx
- 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.
Niall
On Tue, Dec 2, 2008 at 10:44 AM, Martin Busik <martin.busik@xxxxxxxx> 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?
>
> Cheers,
> Martin
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
