Re: high gets per execution for an update based on rowid
From: Denis <denis.sun_at_yahoo.com>
Date: Tue, 10 Apr 2012 16:57:10 -0700 (PDT)
Message-ID: <1334102230.87552.YahooMailNeo_at_web161806.mail.bf1.yahoo.com>
( send again , hope the numbers are readable)
We bounced the instance.and reverted back the last weekend changes about the memoery setting. Now gets down to 2. backlog are drainning quickly. Not sure it is the new memory value caused the problem or the simple bonce just did the magic.
===> old values
db_cache_size00M
shared_pool_sizeu0M
java_pool_size 0M
large_pool_size 000000
streams_pool_sizeP331648
===> new values introduced last weekend
sga_max_size400M
sga_target000M
db_cache_size000M
shared_pool_size0M
java_pool_size 8M
large_pool_size2M
streams_pool_sizeHM
Date: Tue, 10 Apr 2012 16:57:10 -0700 (PDT)
Message-ID: <1334102230.87552.YahooMailNeo_at_web161806.mail.bf1.yahoo.com>
( send again , hope the numbers are readable)
We bounced the instance.and reverted back the last weekend changes about the memoery setting. Now gets down to 2. backlog are drainning quickly. Not sure it is the new memory value caused the problem or the simple bonce just did the magic.
===> old values
db_cache_size00M
shared_pool_sizeu0M
java_pool_size 0M
large_pool_size 000000
streams_pool_sizeP331648
===> new values introduced last weekend
sga_max_size400M
sga_target000M
db_cache_size000M
shared_pool_size0M
java_pool_size 8M
large_pool_size2M
streams_pool_sizeHM
System Configuration: Sun Microsystems sun4u Sun Fire E25K
System clock frequency: 150 MHz
Memory size: 81920 Megabytes
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 10 2012 - 18:57:10 CDT