Streams utl_spadv.show_stats ORA-06512: at "SYS.DBMS_ASSERT"
I lift this from GoldenGate performance best practice
http://www.oracle.com/technetwork/database/availability/maa-gg-performance-1969630.pdf
but this is a Streams question per se.
Ran
@C:\app\KGAN\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlspadv
exec utl_spadv.start_monitoring(interval=>15);
-- The above works. But this fails. (appendix A)
SQL> begin
2 utl_spadv.show_stats(path_stat_table=>'STREAMS\$_PA_SHOW_PATH_STAT',
3 bgn_run_id=> -1,
4 end_run_id=> -1,
5 show_legend=> TRUE);
6 end;
7 /
begin
*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_ASSERT", line 315
ORA-06512: at "GGSUSER.UTL_SPADV", line 955
ORA-06512: at "GGSUSER.UTL_SPADV", line 3881