Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
Sent: Monday, December 08, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
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.com12/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: Mercadante, Thomas F INET: thomas.mercadante_at_labor.state.ny.us 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:04:25 CST