GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Streams utl_spadv.show_stats ORA-06512: at "SYS.DBMS_ASSERT"

edited Aug 19, 2016 11:03AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center