10g has about 30 "basic" parameters such are
db_name and sga_target, a real bunch of "advanced" parameters and the rest
are undocumented parameters.
So, the marketing people can already say you got
less than 100 tunable params..
Tanel.
----- Original Message -----
Sent: Monday, December 08, 2003 10:59
PM
Subject: Re: dc_used_extents
,dc_free_extents and dc_histogram_defs
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: Tanel Poder
INET: tanel.poder.003_at_mail.ee
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 - 15:14:24 CST
