Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Complex Object Retrieval doesn't work

Complex Object Retrieval doesn't work

From: Cristian Vanti <cristian.vanti_at_tiscali.it>
Date: 12 Nov 2004 08:20:28 -0800
Message-ID: <a0844a7b.0411120820.18e5a814@posting.google.com>


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
Cristian

p.s.: I can send you a testcase if you want. Received on Fri Nov 12 2004 - 10:20:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US