The event_log had these three entries pointing to some DDL message with very large byte size:
Notice 2018-12-27 09:14:52.022000 6380 7972 Capture: Got Long DDL of length 339917, splitting into multiple msg with max length of 327277 (capturing from SOURCE_SID) [module oct]
Notice 2018-12-27 09:15:02.024000 6380 7972 Capture: Got Long DDL of length 663836, splitting into multiple msg with max length of 327277 (capturing from SOURCE_SID) [module oct]
Notice 2018-12-27 09:15:05.025000 6380 7972 Capture: Got Long DDL of length 423896, splitting into multiple msg with max length of 327277 (capturing from SOURCE_SID) [module oct]
The Capture DDL log (*ocap* *ddl*) contained a series of large DDLs (like PL/SQL procedures) as follows:
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 User Name: "SYS" Status: Not Replicated
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 DDL = CREATE OR REPLACE PROCEDURE procedure_name (
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 p_rdbms_version IN VARCHAR2,
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 p_apps_release IN VARCHAR2 )
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 IS
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 my_sequence INTEGER := 0;
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 PROCEDURE ins (
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 p_version IN VARCHAR2,
ocap_ddl 2018-12-27 09:14:45.021000 6380 7972 p_name IN VARCHAR2,
.
.
.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center