"Depreciated" Parameters In SPFILE

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 14 Aug 2007 23:37:36 GMT
Message-ID: <41rwi.27603$RX.7411@newssvr11.news.prodigy.net>

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. Received on Tue Aug 14 2007 - 18:37:36 CDT