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

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

Complex Object Retrieval doesn't work

From: news.tiscali.it <c.vanti_at_tin.it>
Date: Sun, 14 Nov 2004 01:56:24 +0100
Message-ID: <cn6bfb$lec$1@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 Received on Sat Nov 13 2004 - 18:56:24 CST

Original text of this message

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