Re: Less bytes when transferring table

From: Jared Still <>
Date: Thu, 2 Apr 2009 13:54:58 -0700
Message-ID: <>

 On Thu, Apr 2, 2009 at 1:24 PM, Tanel Poder <> wrote:

> Yep, Oracle Net does simple compression - when there are lots of rows with
> same consecutive column values sent over sqlnet then Oracle can send the
> column only once plus a count. Anjo Kolk wrote about it in his old blog but
> I couldn't find his article anymore.
> Check the simple example (look into difference in bytes sent via SQL*Net
> even though the result data is the same):
> SQL> select owner from dba_source order by dbms_random.random;
> 299151 rows selected.
> ...

In addition to being a very neat trick, this lends some insight into to how data might be moved more quickly over a slow or overloaded network.

Say you have a few tables to to move across a dblink.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Thu Apr 02 2009 - 15:54:58 CDT

Original text of this message