Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 08 Dec 2003 13:04:25 -0800
Message-ID: <F001.005D932E.20031208130425@fatcity.com>








somebody has free time on his hands.  Jared, what's your bosses email addy?
 

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.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: 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US