Oracle 11.0.1.7:
We are running streams and on the source side when I run "analyze_current_performance" I see that logminer preparer waiting for latch free event for 46% of the time. What could be the problem and how to resolve it?
LOGMINER PREPARER EVENT: latch free 7.692307692 PERCENT
LOGMINER PREPARER EVENT: latch free 15.38461538 PERCENT
LOGMINER PREPARER EVENT: latch free 23.07692308 PERCENT
LOGMINER PREPARER EVENT: wait list latch free 7.692307692 PERCENT
LOGMINER PREPARER EVENT: wait list latch free 15.38461538 PERCENT
SQL> show parameter pool
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
global_context_pool_size string
java_pool_size big integer 0
large_pool_size big integer 0
olap_page_pool_size big integer 0
shared_pool_reserved_size big integer 800K
shared_pool_size big integer 0
streams_pool_size big integer 1G
SQL> show sga
Total System Global Area 3.4217E+10 bytes
Fixed Size 2104216 bytes
Variable Size 1.5838E+10 bytes
Database Buffers 1.8254E+10 bytes
Redo Buffers 123150336 bytes
Edited by: user628400 on Jul 22, 2009 9:13 AM
Edited by: user628400 on Jul 22, 2009 9:14 AM