I Have Configured Oracle Goldengate Integrated Capture Process Using

1.	I Have Configured Oracle Goldengate Integrated Capture Process Using The Default Values. As The Data Load Increases I See That Extract Starts Lagging Behind By An Hour (or More) And Database Performance Degrades. How You Will Resolve This Performance Issue?
Answer» When OPERATING in integrated capture mode, you must make sure that you have assigned sufficient memory to STREAMS_POOL_SIZE. An undersized STREAMS_POOL_SIZE or limiting the STREAMS pool to use a SPECIFIC AMOUNT of memory can cause troubles. The BEST practice is to allocate STREAMS_POOL_SIZE at the instance level and allocate the MAX. SGA at GG process level as below: SQL> alter system set STREAMS_POOL_SIZE=3G TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 2048, PARALLELISM 4) When operating in integrated capture mode, you must make sure that you have assigned sufficient memory to STREAMS_POOL_SIZE. An undersized STREAMS_POOL_SIZE or limiting the streams pool to use a specific amount of memory can cause troubles. The best practice is to allocate STREAMS_POOL_SIZE at the instance level and allocate the MAX. SGA at GG process level as below: SQL> alter system set STREAMS_POOL_SIZE=3G TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 2048, PARALLELISM 4)

I Have Configured Oracle Goldengate Integrated Capture Process Using The Default Values. As The Data Load Increases I See That Extract Starts Lagging Behind By An Hour (or More) And Database Performance Degrades. How You Will Resolve This Performance Issue?

Answer»

When OPERATING in integrated capture mode, you must make sure that you have assigned sufficient memory to STREAMS_POOL_SIZE. An undersized STREAMS_POOL_SIZE or limiting the STREAMS pool to use a SPECIFIC AMOUNT of memory can cause troubles.

The BEST practice is to allocate STREAMS_POOL_SIZE at the instance level and allocate the MAX. SGA at GG process level as below:

SQL> alter system set STREAMS_POOL_SIZE=3G

TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 2048, PARALLELISM 4)

When operating in integrated capture mode, you must make sure that you have assigned sufficient memory to STREAMS_POOL_SIZE. An undersized STREAMS_POOL_SIZE or limiting the streams pool to use a specific amount of memory can cause troubles.

The best practice is to allocate STREAMS_POOL_SIZE at the instance level and allocate the MAX. SGA at GG process level as below:

I Have Configured Oracle Goldengate Integrated Capture Process Using The Default Values. As The Data Load Increases I See That Extract Starts Lagging Behind By An Hour (or More) And Database Performance Degrades. How You Will Resolve This Performance Issue?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment