Re: high gets per execution for an update based on rowid
- From: Denis <denis.sun@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Apr 2012 16:57:10 -0700 (PDT)
( 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_size?00M
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_size?0M
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
