Larry,
As far as I am concerned my present problems are linked to an unpleasant tendency
of MTS to freeze, and, while looking at $ORACLE_HOME/rdbms/mesg/oraus.msg for a
possibly suitable event to set to get some information, I bumped into 10975 which may
possibly be useful in your case.
BTW
> Larry,
>
> Thanks for taking the time to explain this. You are really patient when it
> comes to writing!
> I see now how Oracle does the refresh. I also remember now seeing
> a post in
> this list some time ago asking about the possibility of tuning a similar
> sql. I think it was you :)
It wa
you don't see clustering and density factor calculations in terms
of SQL. I need to do some more work on this, and the Advanced Replication
guide does talk about dependencies and their impact on whether or not some
things can parallelized, but I've got to dig a bit more into that. But s
> Sent: Tuesday, January 14, 2003 8:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Parallel Replication of Single Table
>
>
> I remember too being able to achieve parallelism (8.1.7) with CTAS or
> inserts across DB's too but I'm not able to achie
4 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Parallel Replication of Single Table
>
>
> I remember too being able to achieve parallelism (8.1.7) with CTAS or
> inserts across DB's too but I'm not able to achieve this now. I tried it
> from the source
I remember too being able to achieve parallelism (8.1.7) with CTAS or
inserts across DB's too but I'm not able to achieve this now. I tried it
from the source side and the target side without success. It's always
serial.
Curious how you are able to test this.
Thanks
Waleed
-Original Message
at code and action may happen that doesn't manifest
itself as SQL -- you see analyzes computing number of distinct, max, min,
etc. But you don't see clustering and density factor calculations in terms
of SQL. I need to do some more work on this, and the Advanced Replication
guide does talk a
> I am not sure about replication but in the past (on 8.1.5 and 8.1.6
> versions) this has been my experience with CTAS over a dblink or DML over
> dblink in that it serializes.
> In order to achieve parallelism, the only workaround we had was (though
> not pretty :-) ) to use the ROWID hint on the
Hi Larry,
I do not know really how you want to parallelize this kind of operations!
The final goal is to push the changes in site 1 to site 2 and get the data
in both tables in sync.
Changes include inserts, updates, and deletes. These changes (dml
operations)
could be cascaded on the same row
Hi Larry,
> In the distributed manual it
> makes a comment about DML serializing when doing remote operations.
I am not sure about replication but in the past (on 8.1.5 and 8.1.6
versions) this has been my experience with CTAS over a dblink or DML over
dblink in that it serializes.
In order to a
Listers,
How can one use parallelism when fast refreshing a *single* table?
Pulling my hair out on this one. We want to use parallelism when replicating
updates/inserts from a single partitioned table between DB's -- partitioned
on both DB's. Both are 8.1.7.4 Solaris 8 64 bit. Using fast refresh
11 matches
Mail list logo
