Problem with HDR
I have upgraded my database from 11.5.FC6 to 11.5.FC7 but facing some issues with HDR. Its observed that when HDR is lagging behind the primary there are number of sessions goes into " G waiting on write of the logical log buffer" and primary goes slow and lot of load on primary until unless secondary completely synch with the primary. Is there any bug in this version,Because we were facing some like this problem with rss in 11.5.FC6 Any body can guide me to resolve this issue or any database tuning to overcome the problem . Thanks in advance.
number of cpuvps,
value of OFF_RECVRY_THREADS and LOGBUFF
output of onstat -l
???
M.P.
From: "KHURRAM SHAHZAD" <kshahzad02@i2cinc.com>
To: ids@iiug.org
Date: 02/20/2011 07:09 AM
Subject: Problem with HDR [22840]
Sent by: ids-bounces@iiug.org
I have upgraded my database from 11.5.FC6 to 11.5.FC7 but facing some
issues
with HDR. Its observed that when HDR is lagging behind the primary there
are
number of sessions goes into " G waiting on write of the logical log
buffer"
and primary goes slow and lot of load on primary until unless secondary
completely synch with the primary.
Is there any bug in this version,Because we were facing some like this
problem
with rss in 11.5.FC6
Any body can guide me to resolve this issue or any database tuning to
overcome
the problem .
Thanks in advance.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Yes. I ran into the same problem The fix is supposed to be in xC8. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KHURRAM SHAHZAD Sent: Sunday, February 20, 2011 9:07 AM To: ids@iiug.org Subject: Problem with HDR [22840] I have upgraded my database from 11.5.FC6 to 11.5.FC7 but facing some issues with HDR. Its observed that when HDR is lagging behind the primary there are number of sessions goes into " G waiting on write of the logical log buffer" and primary goes slow and lot of load on primary until unless secondary completely synch with the primary. Is there any bug in this version,Because we were facing some like this problem with rss in 11.5.FC6 Any body can guide me to resolve this issue or any database tuning to overcome the problem . Thanks in advance. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.