Parameter Changes Between 9.2.0.1.0 and 10.2.0.2.0

I loaded the respective SYS.X$KSPPI data from 9.2.0.1.0 and 10.2.0.2.0 into regular user tables for the purpose of comparison, so here are some brief-but-fun statistics.

9.2.0.1.0 has 797 parameters, of which 540 are hidden and 257 are not.

10.2.0.2.0 has 1,410 parameters of which 1153 are hidden and 257 are not.

The two versions have 733 parameters exactly in common.

One hidden parameter from 9.2.0.1.0 was “promoted” to non-hidden in 10.2.0.2.0: _instance_type.

9.2.0.1.0 has two non-hidden parameters for which there are hidden counter-parts (ie. “parameter” and “_parameter” both exist):

  • cpu_count
  • db_block_buffers.

10.2.0.2.0 has six non-hidden parameters for which there are hidden counter-parts:

  • db_block_buffers
  • db_cache_size
  • java_pool_size
  • large_pool_size
  • shared_pool_size
  • streams_pool_size

10.2.0.2.0 has 647 hidden parameters that 9iR2 does not. Too many to list here, but the most popular first words of the parameter names are:

  • 46 x optimizer
  • 41 x xsolapi
  • 36 x db
  • 22 x olap
  • 16 x gc
  • 16 x disable
  • 16 x flashback
  • 15 x asm
  • 14 x px
  • 13 x lm
  • 13 x log
  • 12 x enable
  • 11 x bct
  • 10 x memory
  • 10 x simulator
  • 10 x olapi
  • 8 x ash
  • 8 x cursor
  • 8 x kgl
  • 8 x dump

A clear win for the optimizer, I think. Here is the full list.

And here is the full list of 10.2.0.2.0 parameters

Finally, the longest pparameter name in 10.2.0.2.0 is “_xsolapi_materialization_rowcache_min_rows_for_use”: an impressive 50 characters.

Advertisements

One thought on “Parameter Changes Between 9.2.0.1.0 and 10.2.0.2.0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s