Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Depreciated" Parameters In SPFILE
Bob Jones wrote:
> "Charles Hooper" <hooperc2000_at_yahoo.com> wrote in message > news:1187183849.417085.301070_at_b79g2000hse.googlegroups.com...
>>> On Aug 15, 9:37 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote: >>> >>>> Oracle 10g 10.2.0.3, Windows 2003 Server >>>> This may seem an easy question but I can't seem to find an answer. >>>> If an Oracle instance is set up for automatic memory management and >>>> there >>>> are some parameters, such as bitmap_merge_area_size (etc) which are >>>> non-zero >>>> and which Oracle recommends using the PGA_AGGREGATE_TARGET instead >>>> ,should >>>> such parameters be zeroed out in the SPFILE? >>>> I know the manual says they aren't recommended except in Shared Server >>>> environments but what should be done in a Dedicated Server environment? >>>> Thanks. >>> The old _AREA_SIZE parameters are silently ignored if the new >>> parameter is present. >>> >>> You may want to leave them in the spfile at their non-zero values, >>> however, in case you switch to shared server mode (or, remembering >>> that an instance can do both shared- and dedicated-server mode at the >>> same time, in case one or two of your users need to connect in shared >>> mode). >>> >>> If you really want to get rid of the old parameters, don't just zero >>> them out, though. Delete them from the spfile entirely: >>> >>> alter system reset sort_area_size scope=spfile sid='*'; >>> >>> ...that way, the parameter still has a non-zero default value for >>> those rare occasions when it might be needed.
>>
>>
>> > > Wow, this guy really has too much time in his hands, or he just hate this > Don guy too much. It is pointless to set _AREA_SIZE when using > PGA_AGGREGATE_TARGET anyway.
You really need to drop the attitude or learn about the "rule of holes:" When you are in one stop digging.
Howard is 100% correct in everything he wrote. And you will find the exact same criticism from Tom Kyte, and Jonathan Lewis, and many others who are the experts in our community.
In case you are not familiar with Howard ... you might want to review
this:
http://apex.oracle.com/pls/otn/f?p=19297:4:4116369228746107::NO:4:P4_ID:59
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Aug 16 2007 - 11:00:32 CDT