1 2 3 4 Previous Next 49 Replies Latest reply: Dec 28, 2011 3:59 AM by 488176 RSS

    tool for monitoring oracle streams

    sham
      Is there any tool from 3th party that you can monitor oracle streams???
        • 1. Re: tool for monitoring oracle streams
          570955
          Till now i have not heard of any 3rd party tool for stream monitoring, but i have used the enterprise manager grid control a bit and thts very good. Most of the time i end up using the OEM database console, which is really a pain to use. ALso heard of "STRMMON", but didnt get a chance to work on that.
          • 2. Re: tool for monitoring oracle streams
            488176
            I developed a web - based tool for streams environments (controlling and administration) , based on Hub&Spoke and Multimaster replication. you can see it in a live demo at

            http://arealinux.homelinux.net:81/pls/osc/inhalt

            let me know, if you need more information, this is freeware and is downloadable.

            stefan.menschel@oracle.com
            • 3. Re: tool for monitoring oracle streams
              sham
              where can i download this nice tool
              • 4. Re: tool for monitoring oracle streams
                488176
                you can download here

                http://arealinux.homelinux.net:81/pls/control/download

                the OSC it's for free !

                first read the README.txt file and then define you settings in 00_define.sql then go to the 02-OSC-Setup path and install the OSC

                Let me know, if you need support

                Stefan
                • 5. Re: tool for monitoring oracle streams
                  sham
                  hey,

                  so i can see i have to install apache webserver and what i have to get more
                  • 6. Re: tool for monitoring oracle streams
                    sham
                    i have installed this tool it's very helpfull en nice.
                    great tool.
                    • 7. Re: tool for monitoring oracle streams
                      488176
                      Download Page for Oracle Streams Commander is changed to
                      http://www.oracle.com/global/de/community/platform/osc/index.html
                      • 8. Re: tool for monitoring oracle streams
                        anoopS
                        You can use Oracle commander or Oracle enterprise manager 10g .
                        Oracle Enterprise manager 10g is a very good tool to monitor streams.
                        Have used it and seems to be a nice tool.
                        • 9. Re: tool for monitoring oracle streams
                          sham
                          i like the osc its easier than enterprise manager10g with enterprise manager10g you can't so many as OSC. that's (OSC) is nice tool.
                          • 10. Re: tool for monitoring oracle streams
                            anoopS
                            ok Good ...
                            OSC should be integrated with Oracle EM i believe .
                            • 11. Re: tool for monitoring oracle streams
                              sham
                              i hope so
                              • 12. Re: tool for monitoring oracle streams
                                schropp
                                We use a very fine tool named OSC. This tool can help to monitor and analyze
                                streams errors, you didn't see with OEM in the actual version.
                                We had situations, when OEM showed no streams errors but OSC
                                found problems. With this tool the most common errors can be easily
                                discovered and fixed. I hope this will be part of oem in
                                next OEM Versions.
                                • 13. Re: tool for monitoring oracle streams
                                  skurup2
                                  STRMMON is a command line utility that will display the streams components status. This utility is good enough if you are looking for checking an ongoing performance issues. In our production Streams environment, we collect the status of v$streams_xxx tables to our own history tables every couple of seconds. Then we run delta queries against these history tables to review the past&ongoing performance for each components. We generate reports and generate graphical view of volue vs latency of capture, apply, propagaton bytes sent, received etc.
                                  • 14. Re: tool for monitoring oracle streams
                                    skurup2
                                    sample code:- for apply status
                                    CREATE TABLE APPLY_LATENCY_HIST
                                    (
                                    APPLY_NAME VARCHAR2(30) NULL,
                                    APPLY_LATENCY_SEC NUMBER NULL,
                                    RUN_TIME TIMESTAMP(6) NULL,
                                    MESG_CR_TIME DATE NULL,
                                    MESG_APPLY_TIME DATE NULL,
                                    TOTAL_APPLIED NUMBER NULL,
                                    TOTAL_WAIT_DEPS NUMBER NULL,
                                    TOTAL_WAIT_COMMITS NUMBER NULL,
                                    TOTAL_IGNORED NUMBER NULL,
                                    TOTAL_ROLLBACKS NUMBER NULL,
                                    TOTAL_ERRORS NUMBER NULL,
                                    TOTAL_MESSAGES_APPLIED NUMBER NULL,
                                    TOTAL_ASSIGNED NUMBER NULL
                                    )
                                    CREATE UNIQUE INDEX APPLY_LAT_IDX1_NEW
                                    ON APPLY_LATENCY_HIST(APPLY_NAME,RUN_TIME);

                                    create dbms_job to run the following every couple of seconds:-
                                    INSERT INTO FID_APPLY_LATENCY_HIST
                                    SELECT a.APPLY_NAME,
                                    round((a.HWM_TIME - a.HWM_MESSAGE_CREATE_TIME)*86400,2),
                                    SYSTIMESTAMP,
                                    a.HWM_MESSAGE_CREATE_TIME,
                                    a.HWM_TIME,
                                    a.TOTAL_APPLIED,
                                    a.TOTAL_WAIT_DEPS,
                                    a.TOTAL_WAIT_COMMITS,
                                    a.TOTAL_IGNORED,
                                    a.TOTAL_ROLLBACKS,
                                    a.TOTAL_ERRORS,
                                    sum(b.total_messages_applied),
                                    sum(b.total_assigned)
                                    FROM V$STREAMS_APPLY_COORDINATOR a,v$streams_apply_server b
                                    where a.APPLY_NAME=b.APPLY_NAME
                                    group by
                                    a.APPLY_NAME,
                                    round((a.HWM_TIME - a.HWM_MESSAGE_CREATE_TIME)*86400,2),
                                    SYSTIMESTAMP,
                                    a.HWM_MESSAGE_CREATE_TIME,
                                    a.HWM_TIME,
                                    a.TOTAL_APPLIED,
                                    a.TOTAL_WAIT_DEPS,
                                    a.TOTAL_WAIT_COMMITS,
                                    a.TOTAL_IGNORED,
                                    a.TOTAL_ROLLBACKS,
                                    a.TOTAL_ERRORS;
                                    COMMIT;

                                    Run the following query to display delta of each run:-
                                    -- ########################################################################################
                                    -- Query to list the volume and latency of apply from the history
                                    -- This query will list the delta of following stats between the stats collection interval
                                    -- apply latency between stats interval
                                    -- transaction applied between stats interval
                                    -- lcr applied between stats interval
                                    -- number of DML applied between stats interval
                                    -- #########################################################################################
                                    select run_time,apply_latency_sec "LATENCY IN SECONDS",
                                    total_applied-lag(total_applied) over (order by run_time) "NUMBER OF TXN APPLIED",
                                    TOTAL_MESSAGES_APPLIED-lag(TOTAL_MESSAGES_APPLIED) over (order by run_time) "NUMBER OF LCR APPLIED",
                                    (TOTAL_MESSAGES_APPLIED-lag(TOTAL_MESSAGES_APPLIED) over (order by run_time)) - (total_applied-lag(total_applied) over (order by run_time)) "NUMBER OF DML APPLIED"
                                    from FID_APPLY_LATENCY_HIST
                                    where
                                    apply_name='REPLACE APPLY NAME'
                                    and run_time >= to_date('2007-11-13 15:59:00','yyyy-mm-dd hh24:mi:ss')
                                    and run_time <= to_date('2007-11-13 23:00:00','yyyy-mm-dd hh24:mi:ss')
                                    order by apply_name,run_time;
                                    1 2 3 4 Previous Next