Re: CLOB

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1091677002.66194_at_yasure...
> Oradba Linux wrote:
>
> > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1091595898.193617_at_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)
> >>
> >
> >
> > I want to do a fast refresh every day and fast refresh can be done only
> > snapshots replication .
> >
> > Thanks
>
> What do you think the difference is?
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>

The difference is , in Dataguard the redo logs are shipped and later applied to the standby database .
But here in the fast refresh the data is pulled in real time over the db link and updated or inserted . I tested an example today and i could achieve only about 10 updates per second . I am not sure if thats efficient enough . It is a development server and another sun workstation . It is not really a powerful server . Received on Thu Aug 05 2004 - 16:14:18 CDT