Comments in-line
At 00:49 11-12-03 -0800, you wrote:
But the last time I looked at it, you had
to enable supplemental logging at the
database level if you wanted to use logical
standby. Two side effects -
Yes, indeed, supplemental logging must be switched on.
1) As you said, you need a unique/
Hi, Jonathan,
I think your question is why I mentioned TDU, not just SDU, in my response to
Guang's message. I admit I didn't give much thought and threw that in.
Note:44694.1 says it's set to 32k by default and its adjustable range is 0 to
32k. Then the question is why Oracle chose the magical 32
But the last time I looked at it, you had
to enable supplemental logging at the
database level if you wanted to use logical
standby. Two side effects -
1) As you said, you need a unique/primary key,
and database supplemental logging copies
such a key into the redo for every change to a row:
but
Can you clarify a couple of points for me.
The SDU (session data unit) is presumably the
packet size that the Oracle client and server
want to pass back and forth - which is presumably
the maximum size the one synchronous dialogue unit
will be.
The TDU (transport data unit) is presumably the
pre
Hi, Guang,
Look up SDU and TDU in Oracle documentation Network configuration. You set them
in tnsnames.ora and listener.ora, not sqlnet.ora. protocol.ora allows you to
modify some procotol-specific parameters. In addition, in your client
application, you can choose a sensible array fetch size, suc
Hi Kitty,
Never heard of that, but I'm interested in your experiences, and the
architecture of iReflect. The only advantage of Data Guard I can tell you
is that it comes for free with your Oracle licences.
Regards, Carel-Jan
-- There will allways be another 10 last bugs --
At 12:14 9-12-0
Hi Vi,
Rows NEED unique identification. So, if there are bunches of raw data
with no unique identifier whatsoever (remember, rowid is not allowed) LSB
can't generate a where-clause what row to update or delete on the SB
database. It's generating SQL based on redolog info, and has to come up
with
I have never worked on Network stuff. But is there any easy parameters we
could set in sqlnet.ora so that we could increase the DB performance by
increase the network transfer rate (without doing anything else)? BTW my
sqlnet.ora (on a Sun Box) has only two lines:
--
bash-2.03$ more sqlne
Hi All,
I am working on a similar project here. I am wondering if anyone in the list ever
compared Oracle Data Guard with iReflect from Data Mirror. Please share your
experience with us.
Thanks,
Kitty
-Original Message-
Sent: Monday, December 08, 2003 6:54 PM
To: Multiple recipient
Jumbo frames are new to me. The Ethernet Definitive Guide book says it was
proposed by one vendor and adopted by several, so may not have good
interoperability. But I wonder how much performance improvement there is by
going from MTU 1500 with SDU 8k to MTU 8k with SDU 8k. I assume the lower the
OS
Hi Carel,
What if 50% of tables doesn't have Primary/Unique
keys, how it is going be with LSB then? Can you please
explain more.
with thanks,
Vi
--- Carel-Jan Engel <[EMAIL PROTECTED]>
wrote: > Comments inline
>
> At 14:54 8-12-03 -0800, you wrote:
> >Hi Carel,
> >
> >That is good help, can
Comments inline
At 14:54 8-12-03 -0800, you wrote:
Hi Carel,
That is good help, can you please send me the pdf that
you implemented there then.
Was on its way already
Tell me one thing I agree that we some
times
(rather most of the time ) generate less redo so we
should be smooth.
Hi Carel,
That is good help, can you please send me the pdf that
you implemented there then.
Tell me one thing I agree that we some
times
(rather most of the time ) generate less redo so we
should be smooth. Can you tell me is there any
releation between LSB and Primary keys, I read
With TCP over standard ethernet the maximum transfer unit (MTU) is about
1500 bytes, this means if you want to send 2000 bytes over network, you have
to fragment it in 2 packets and send them separately. This means double
packet headers, double latency etc. Jumbo frames is a capability of some
Gbit
Comments inline
At 13:34 8-12-03 -0800, you wrote:
Hi Tanel,
Much appreciated, The fact is I am interested in
Logical standby rather than physical.
Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.
It all depends
Hi Vijay,
I've done around 20 DG installations at different sites, using Linux,
Solaris, AIX and W2K.
High speed network isn't always what you need, low latency might be more
important. I've set up a DG environment between Kuala Lumpur and Rotterdam,
using a 128KB line. This wasn't for standby
Hi,
Tanel,
"enabling jumbo frames and SDU size if using
Gbit ethernet,"
can you elaborate on this?
-Original Message-
Sent: Monday, December 08, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Tanel,
Much appreciated, The fact is I am interested in
Logical standby rath
Hi Tanel,
Much appreciated, The fact is I am interested in
Logical standby rather than physical.
Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.
Now We didn't go to Snapshot because It is on
multiple tables
> Hi All,
>
> can any one let me know kindly the following info.
>
> 1) Has any one used the Oracle 9i Data Guard?
Yes, physical standby and successfully.
> 2) If yes then, is there any performance impact on
> Target/Source server database.
Your database has to be in archivelog mode, but when y
Jeff - With 8.1.7, I believe that you are limited to read-only or standby,
but you can't have both simultaneously. It is either in recovery mode
accepting redo logs from production or open and allowing read-only.
I believe that with 9i the options are much more flexible. Read up
on the Or
It is possible in 8.1.7
>From: "Jeff Wiegard" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Data Guard
>Date: Thu, 01 Nov 2001 11:20:22 -0800
>
>Hi. I'm looking into implementing a read-only stand-by database. I'd
21 matches
Mail list logo
