Re: Complex Object Retrieval doesn't work

I haven't used them before as you are. In general not using bind vairables increases hard parses and CPU on the server (and latches etc). Also not using the array interface increases network trips. I believe there is an object cache that one can set up on the client.

But most people don't use object features, or should I say not that way. They use them more for pl/sql or xml.
Jim

"news.tiscali.it" <c.vanti_at_tin.it> wrote in message news:cn6opq$tmb$1_at_lacerta.tiscalinet.it...
> No Jim, I'm not using bind variables neither arrays. I used a very simple
C
> program using OCI. My attempt to use OCCI was terrible 7 times slower, 20
> times roundtrips.
> I have only to extract data from db, so I just Pin refs to get referenced
> objects. I don't lock anything.
> I set prefetch rows to 1000 and prefetch memory to 10Mb.
> Monday, I'll be in office and I'll be able to send you a simple testcase.
> I can't believe that Oracle put a lot of emphasys about something that
> doesn't work, but I wasn0t able to find a working example. Have you ever
> succeded in using COR ?
> BTW, how many people you know are using Oracle object extensions ?
>
> Thanks,
> Cristian
>
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> ha scritto nel
> messaggio news:ZaAld.403845$D%.2482_at_attbi_s51...
> >
> > "news.tiscali.it" <c.vanti_at_tin.it> wrote in message
> > news:cn6bfb$lec$1_at_lacerta.tiscalinet.it...
> >> I'm using Oracle object extensions. I use nested tables and table of
> >> refs.
> >> I've tried to read my data with OCI and OCCI but tracing accesses to
> >> db I find a lot of roundtrips: one for each ref to be read. Much more
> >> with OCCI which is several times slower.
> >> I've tried to set Complex Object Retrieval parameters with but I got
> >> no results: roundtrips are always the same and its time is 55-60% of
> >> my app total time.
> >> I used following configurations:
> >> server: tru64 5.1b + ora 9.2.0.4 - client: tru64 5.1b + ora 10.1.0.2
> >> server: tru64 5.1b + ora 9.2.0.4 - client: tru64 5.1b + ora 9.2.0.4
> >> server: tru64 5.1b + ora 9.2.0.4 - client: winxp + ora 10.1.0.2
> >> server: tru64 5.1b + ora 9.2.0.4 - client: winxp + ora 10.1.0.3
> >> server: winxp + ora 10.1.0.3 - client: tru64 5.1b + ora 10.1.0.3
> >>
> >> Have someone ever had successful results using COR ?
> >>
> >> TIA
> >>
> >>
> > Are you using bind variables and the array interface? Also I think for
> > objects you can have a .local object cache.
> > Jim
> >
> >
>
>
Received on Sun Nov 14 2004 - 00:09:11 CST