Home » RDBMS Server » Server Administration » Logical standby apply process taking too much time (oracle 11.2.0.2)
Logical standby apply process taking too much time [message #569766] Thu, 01 November 2012 03:57
ardhendu
Messages: 4
Registered: October 2012
Location: INDIA
Junior Member
Hi,

The below statement is getting executed frequently on the logical standby. whenever this statement executes the apply process keeps almost halts and the system goes out of sync.

ALTER TABLE SYSTEM.LOGSTDBY$APPLY_PROGRESS DROP PARTITION P453553963.

The output from

SELECT SERVER_ID, STATE, APPLIED_MESSAGE_NUMBER, MESSAGE_SEQUENCE
FROM V$STREAMS_APPLY_SERVER
ORDER BY SERVER_ID; is shown as below.

1 EXECUTE TRANSACTION 453562715 4
2 DROP PARTITION 453554793 4
3 EXECUTE TRANSACTION 453562713 9
4 EXECUTE TRANSACTION 453562702 7
5 WAIT COMMIT 453562717 7


The Output from

select
s.username usr,
s.SID,
s.SERIAL#,s.osuser,
machine,sql_text
from v$sessmetric m, v$session s,V$sqlarea a
where m.session_id = s.sid
and m.session_serial_num = s.serial#
and s.SQL_HASH_VALUE = a.HASH_VALUE
and s.SQL_ID = a.SQL_ID

shows the above ALTER TABLE SYSTEM.LOGSTDBY$APPLY_PROGRESS DROP PARTITION statement.

please let me know why this is happening so frequently.
Previous Topic: How to refresh test Schema from Production request
Next Topic: how to migrate database from windows 2003 to windows 2008 server
Goto Forum:
  


Current Time: Sun Sep 14 23:07:09 CDT 2014

Total time taken to generate the page: 0.04552 seconds