Re: dc_used_extents ,dc_free_extents and dc_histogram

From: <Jared.Still_at_radisys.com>
Date: Mon, 08 Dec 2003 12:59:24 -0800
Message-ID: <F001.005D932D.20031208125924@fatcity.com>

Though there has been an average increase in the total number of init parameter of 83% from
versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38%
in 7.3.4, to 31%/69% in 9.2.0.4.

version undoc tunable total %undoc %tunable
-------------------------------------------------------------------------
7.3.4 97 158 255 38 62
8.1.7.4 300 204 504 60 40
9.2.0.4 587 258 845 69 31

To achieve the stated goal of 100 tunable parameters in 10g, with an expected
growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g
should look somthing like this:

version undoc tunable total %undoc %tunable
-------------------------------------------------------------------------
10.0.0 999 100 1099 91 9

;)

Jared

Mladen Gogala <mladen@wangtrading.com>
Sent by: ml-errors@fatcity.com

12/08/2003 11:59 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
cc:
Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

Larry Ellison has publicly stated that his goal is to produce a database with
less then 100 tunable parameters. Allegedly, he came rather close with 10g.
As far as 10g is concerned, I'm rather disappointed with the marketing hype
being created with oracle not making an early version available. I don't plan
on migrating to 10g until I learn it well and if some oracle sales guy
tries to exert pressure on me to migrate, he will get a very stable sign
used by English archers after the battle at Agincourt to signify that they
still have all the fingers needed to operate a longbow. I've had my fill of
white papers and articles and now I want to see the software.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Dec 08 2003 - 14:59:24 CST