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

3D Streams Monitor help page

Streams monitor is an web application which provides complex online overview of the Oracle Streams enviroment that is used in the Distributed Deployment of Database(3D) project - part of LCG project.

Monitor pages


Displays basic monitor status about monitored enviroment - number of databases, streams setups and streams processes currently active or disabled

Maps view

Provides streams connections topology of each experiment.

Databases view

Listing of all participating databases with its main metrics

Streams view

Dashboard view of active streams with LCRs flow and processes status

Graphs generator

Generates plots

Error view

Listing of all errors and warining in streans enviroments

Availability view

Displays percentag of database availability during last days

Reports repository view

Provides access to the reports repository directory

Monitored metrics

All dynamic stats are cumulative (except latency) - encountered since start of the instance or process. Additionaly metrics with "/s" shows current payload per secound

Instance stats
  • Id - identity number of instance - if database is non RAC it is always 1. Otherwise it is correspondent to inst_id displayed in GV$ views
  • Name - name of the instance - usually SID+inst_id
  • Stream pool size - current stream pool size
  • Stream pool free - amount of not used pool
  • Stream pool usage - percentage usage retio
  • Stream pool usage - percentage usage retio
  • Redo size - amount of redo data generated since start of the instance
  • Redo generated per sec - current growth of redo size
  • Bytes read per sec - current physical input from datafiles
  • Bytes read per sec - current physical output from datafiles

Capture process
  • Instance nr - number of an instance on which the process resides
  • Queue id - id number of destination queue where process ships captured LCRs
  • LCRs captured - number of logical change records that have been read by log miner from redo log
  • LCRs enqueued - number of logical change records that have been approved by the capture process (rules) to be replicated and inserted to the queue
  • Capture latency - time between creation of an entry in the redo log and being read by log miner
  • Enqueue latency - time between creation of an entry in the redo log and being enqueued by the capture process
  • Type - type of process:
    • Local - capture process uses local instance redo logs for capturing changes
    • Downstream (source) - capture process uses redo logs downloaded from the logs source database
  • State - current state of the capture process
  • Info - homemade diagnostic:
    • F - process is under flow control
    • B - process is a bottleneck
  • Error time - time of the last error
  • Error message - oracle error message
  • Last SCN enqueued - last enqueued system change number before error(appears only when process was aborted or disabled)

Propagation process
  • Source queue id - id number of source queue of LCRs to be propagated. When streams setup is consistent queue id should be the same for propagation and capture process.
  • LCRs propagated number of LCRs that have been transfered to the destination database
Apply process
Queue status
Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r4 - 2007-07-10 - ZbigniewBaranowski
    • 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