Re: CLOB

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 03 Aug 2004 22:04:22 -0700
Message-ID: <1091595898.193617@yasure>

Oradba Linux wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1091424473.55153_at_yasure...
>

>>Oradba Linux wrote:
>>
>>
>>>I am trying to find out if any of you are replicating Clobs in a

>
> production
>

>>>environment . How many rows does your table
>>>contain ? How fast does it replicate ? How to tune the fast refresh ? I

>
> am
>

>>>not doing a complete refresh .
>>
>>What do you mean by "replicate" and why, in a relational database would
>>anyone replicate anything?
>>
>>--
>>Daniel A. Morgan
>>University of Washington
>>damorgan_at_x.washington.edu
>>(replace 'x' with 'u' to respond)
>>

>
>
> I have never seen you give any useful suggestions and this one is no
> different . Please dont jump on me for telling this .
>
> I did not put my question clearly . I am trying to replicate a table with
> clob field across 2 production instances .
> This table has about 5 mil rows . I want to do a fast refresh everyday . I
> expect atleast 50,000 rows inserted into this table
> every day and has to be refreshed to the second database . I am trying to
> find out if anybody has any experiences replicating
> or doing fast refreshes of a table with clob field . How fast was it ? Any
> tips to improve performance .
>
> Thanks

Replicate how? With Advanced Replication? With an export-import? With DataGuard?

I have been using DataGuard and it is very clean. But as soon as we get our new storage arrays up we will move to using the snap-mirror built-in capability to do all of the replication.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Aug 04 2004 - 00:04:22 CDT