Re: streams capture performance

Untitled

Madhu,

The spill rate is 22% which is very high. Is this rate increasing? 1 of the reasons why spill occurs is because streams_pool_size is small. Do you see it getting dynamically resized to a bigger size (check under V$SGA_RESIZE_OPS, look for streams_pool_size being resize, and not just when instance was started).

You also can consult $STREAMS_POOL_ADVICE for proper sizing of streams_pool_size

Do you have a heartbeat table implemented?

If not here is a link to help with implementation

http://ksadba.wordpress.com/2008/07/02/oracle-streams-recommendations-for-heartbeat-table/ Also can you post the output of this query:

*select *startup_time, state, TOTAL_MESSAGES_CAPTURED,

       ELAPSED_CAPTURE_TIME, ELAPSED_PAUSE_TIME
*from *gv$streams_capture;

There are other info under v$streams_capture that would help you to investigate where the delay is spend in the capture processLast, did you add or adjust any capture rules?

 Hazem

--
http://www.freelists.org/webpage/oracle-l