Re: Re: Wrapping all tables with packages and scalability

From: Vadim Gorbounov <v.gorbunov_at_protek.ru>
Date: Mon, 3 May 2004 19:46:38 +0400
Message-ID: <011901c43125$d22b2390$29160090@protek>

Original Message ----- From: <ryan.gaffuri_at_cox.net> To: <oracle-l_at_freelists.org>; <oracle-l_at_freelists.org> Sent: Monday, May 03, 2004 7:25 PM Subject: Re: Re: Wrapping all tables with packages and scalability

> >
> >
>
> how does wrapping parameters in an object cause serialization?

Object type is not standard Oracle type. It can be anything, User defines this type. Communication between client and server is just stream of bytes, that is object must be packed and unpacked. This is called serialization in object world, it is different from serialization in database world. Point is, because object type is not known to Oracle, serialization/deserialization must be implemented as some sort of generic procedure. There is noticeable overhead.

One may set an experiment to evaluate this cost 1. Use two statements to retrieve 1 parent row and N detail row than construct object in java, use row prefetch (array) 2. Use object view on top of the table and retrieve same data in one call. 3. Compare CPU statistics, collected from 10046 event and responce time on java side.
In my experience, second option cost is much higher. Due to serialization

>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 03 2004 - 10:44:17 CDT