| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
