Re: streams capture performance
- From: "Hazem Ameen" <hazem.ameen@xxxxxxxxx>
- To: "Madhu Sreeram" <madhusreeram@xxxxxxxxx>
- Date: Sat, 18 Oct 2008 13:25:51 +0300
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
Other related posts:
