sqlApply state transition from INITIALIZING to APPLYING taking long in 11gR2
edited Jun 6, 2011 5:46AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 7 commentsAnswered
Hi,
Somebody please help in in bringing this time down, now after switchover sqlApply process is taking almost 200 to 300 seconds. in 10gR2 it used to come in action in 60 seconds time frame or less only.
Please suggest me if i can improve it. looks like loading dictionary is taking more time in 11g. either the dictionary objects have increased a lot in 11g as compared to 10g or some performance parameter is affecting it.
here are two snippets from logs, i am printing message every 5 seconds.
: Before completing switchover. This can take up to 6 minutes before it times out ->
Somebody please help in in bringing this time down, now after switchover sqlApply process is taking almost 200 to 300 seconds. in 10gR2 it used to come in action in 60 seconds time frame or less only.
Please suggest me if i can improve it. looks like loading dictionary is taking more time in 11g. either the dictionary objects have increased a lot in 11g as compared to 10g or some performance parameter is affecting it.
here are two snippets from logs, i am printing message every 5 seconds.
: Before completing switchover. This can take up to 6 minutes before it times out ->
0