I have two installations of Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
And Real Application Testing options.
Bi-directional replication is configured at the table-level between the two databases.
I have tried running UTL_SPADV.COLLECT_STATS(interval => 30, num_runs => 2) in both databases.
In one it runs fine. In the other, I get:
ERROR at line 1:
ORA-01427: single-row subquery returns more than one row
ORA-06512: at "SYS.DBMS_STREAMS_ADV_ADM_UTL", line 1986
ORA-06512: at "SYS.DBMS_STREAMS_ADV_ADM_UTL_INVOK", line 1766
ORA-06512: at "SYS.DBMS_STREAMS_ADVISOR_ADM", line 79
ORA-06512: at "STRMADMIN.UTL_SPADV", line 3281
ORA-06512: at line 1