New undocumented parameters for Oracle 11.1.0.7
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: 26 Sep 2008 13:43:20 +0200
Message-ID: <48dccad8$1@news.x-privat.org>
Date: 26 Sep 2008 13:43:20 +0200
Message-ID: <48dccad8$1@news.x-privat.org>
Oracle 11.1.0.7 has some undocumented new parameters. I was unable to
find anything on Metalink or Google. The parameters are:
cell_offload_compaction cell_offload_parameters cell_offload_plan_display cell_partition_large_extents
Is there anybody who knows what these parameters are about? It looks like a brand new mechanism, possibly for handling NUMA or, maybe, MODEL clause and analytic functions? These are wild guesses, I have no clue about the true nature of the parameters.
There is also a new parameter "DB_ULTRA_SAFE" which deals with corruptions. It is a synthetic parameter which combines the previously known parameters DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, and DB_LOST_WRITE_PROTECT. I imagine that this parameter can have quite a visible effect on performance.The parameter is described in the note 465130.1 on Metalink.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Fri Sep 26 2008 - 06:43:20 CDT