WARNING: This web is not used anymore. Please use PDBService.MonitorStreams instead!
 

Monitor Streams

Status Scripts

You can find more information about how to monitor the Streams environment on the Oracle Streams documentation.

  • propagation_status.sql: Display the total number of events and bytes propagated and the schedule of each propagation job.

  • apply_status.sql: Display the transactions recived and applied, and general information about each apply process.

  • How to check the oldest archive log that will be needed by the capture process:

  • How to display detailed information about Apply Errors:
    • (as SYSDBA):
       GRANT EXECUTE ON DBMS_APPLY_ADM TO strmadmin; 
    • (as strmadmin): print_LCR.sql: print_LCR.sql
    • To run this procedure after you have created it, enter the following:
      •  SET SERVEROUTPUT ON SIZE 1000000 
      •  EXEC print_errors 

Streams Monitor Tool

STRMMON is a monitoring tool focused on Oracle Streams.

You can refer to the metalink note Oracle Streams STRMMON Monitoring Utility - Note:290605.1

3D monitoring Resources

Topic attachments
I Attachment History Action Size Date Who Comment
Microsoft Word filedoc STRMMON.doc r1 manage 66.5 K 2006-04-19 - 10:59 EvaDafonte Strmmon documentation
Unknown file formatsql apply_status.sql r1 manage 1.4 K 2006-04-19 - 10:48 EvaDafonte  
Unknown file formatsql capture_status.sql r1 manage 0.8 K 2006-04-19 - 10:48 EvaDafonte  
Unknown file formatsql minimum_archivelog.sql r1 manage 1.0 K 2007-12-17 - 17:31 EvaDafonte  
Unknown file formatsql propagation_status.sql r1 manage 1.5 K 2006-04-19 - 10:48 EvaDafonte  
Unknown file formatsql queues_status.sql r1 manage 0.5 K 2006-04-19 - 10:48 EvaDafonte  
Compressed Zip archivezip strmmon.zip r1 manage 23.1 K 2006-04-19 - 10:58 EvaDafonte Strmmon tool zip file
Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r5 - 2008-11-03 - EvaDafonte
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback