| data guard is very slow.why? [message #638038] |
Mon, 01 June 2015 10:45  |
 |
tomson
Messages: 9
Registered: June 2015
Location: a
|
Junior Member |
|
|
hi all,
i have a data guard in maximum performance mode(LGWR+ASYNC).
data guard(physical standby) is very slow when apply archivelog.
more information:
waite on data guard:
WAIT_CLASS NAME Time (hours) PCT
Other PX Deq: Test for msg 24.07 74.67
Configuration checkpoint completed 4.38 13.59
Other PX Deq Credit: send blkd 1.35 4.2
CPU Server CPU 1.21 3.74
System I/O RFS write 0.32 0.99
Other RFS dispatch 0.31 0.95
Network SQL*Net more data from client 0.24 0.75
Other SGA: allocation forcing component growth 0.18 0.55
System I/O log file sequential read 0.12 0.37
System I/O Log archive I/O 0.03 0.09
What Should I Do?
[Updated on: Mon, 01 June 2015 10:51] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: data guard is very slow.why? [message #638044 is a reply to message #638038] |
Mon, 01 June 2015 12:11  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
I don't see anything in what you have posted that indicates a problem (though it is hard to be sure, because of the format). Please can you query v$dataguard_stats on the standby to show the transport lag and the apply lag?
|
|
|
|
|
|
|
|
|
|
| Re: data guard is very slow.why? [message #638051 is a reply to message #638049] |
Mon, 01 June 2015 13:18 |
|
tomson
Messages: 9
Registered: June 2015
Location: a
|
Junior Member |
|
|
SELECT wait_class, NAME, ROUND (time_secs/3600, 2) "Time (hours)",ROUND (time_secs * 100 / SUM (time_secs) OVER (), 2) pct FROM (SELECT n.wait_class, e.event NAME, e.time_waited / 100 time_secs FROM v$system_event e, v$event_name n WHERE n.NAME = e.event AND n.wait_class <> 'Idle' AND time_waited > 0 UNION SELECT 'CPU', 'Server CPU', SUM (VALUE / 1000000) time_secs FROM v$sys_time_model WHERE stat_name IN ('background cpu time', 'DB CPU')) ORDER BY time_secs DESC;
please take attach file
-
Attachment: 1.png
(Size: 42.26KB, Downloaded 2142 times)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
