Home » Server Options » Data Guard » data guard is very slow.why? (oracle10 R2.)
data guard is very slow.why? [message #638038] Mon, 01 June 2015 10:45 Go to next message
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 #638043 is a reply to message #638038] Mon, 01 June 2015 11:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe first align the columns in your output so we can read it.
And what is your Oracle version with at least 4 decimals.
And how did you generate your output?
From how long is it?

Re: data guard is very slow.why? [message #638044 is a reply to message #638038] Mon, 01 June 2015 12:11 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #638048 is a reply to message #638044] Mon, 01 June 2015 12:51 Go to previous messageGo to next message
tomson
Messages: 9
Registered: June 2015
Location: a
Junior Member
what's "PX Deq: Test for msg"?
Re: data guard is very slow.why? [message #638049 is a reply to message #638048] Mon, 01 June 2015 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why don't you first answer our questions before posting a new one?

Anyway, I can't help people who help someone who illegally use Oracle, this is against OTN license agreement.
http://www.orafaq.com/forum/m/638047/#msg_638047

Re: data guard is very slow.why? [message #638050 is a reply to message #638049] Mon, 01 June 2015 13:04 Go to previous messageGo to next message
tomson
Messages: 9
Registered: June 2015
Location: a
Junior Member
Excuse me
Excuse me
Excuse me
i clear my post from there.
please help me.

Re: data guard is very slow.why? [message #638051 is a reply to message #638049] Mon, 01 June 2015 13:18 Go to previous messageGo to next message
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 1608 times)
Re: data guard is very slow.why? [message #638052 is a reply to message #638051] Mon, 01 June 2015 13:19 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/
Previous Topic: Sequence of archive log list show zero at physical standby
Next Topic: Returning clause in Active Data Guard is not allowed
Goto Forum:
  


Current Time: Thu Mar 28 12:59:59 CDT 2024