The Stream without a map

In order to learn how to document, we have to start with the basic questions of "What should we document?" We want to document everything that we have set up and determine if Streams is working correctly or within acceptable baselines.

The documentation plan is to have a high level of current Streams environment. Then drive down to the detail components and baseline performance level. Fortunately, as you have probably set up the Streams environment, you can quickly sketch out the environment in a quick picture. If you are the lucky "winner" who inherited the Streams environment then you will need to derive this picture from the techniques covered in this chapter.

The Stream without a map

Oracle has supplied about two hundred and fifty or so supplied packages with Oracle 11gR2. Out of those, we will focus on two of them. They are as follows:

  • DBMS_STREAMS_ADVISOR_ADM
  • UTL_SPADV

These two supplied packages and a little creativity will build all your documentation. The documentation will be easily updated and maintained once you understand how to use these two key packages.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.223.106.100