RE: Survey: How many schemas is "many"
Date: Thu, 7 Aug 2014 10:30:24 +0100
Message-ID: <CABe10sZSHcxOSyeqUVZGmXNZjn7vzOHX7CqwMOQbhp1nrJzK7Q_at_mail.gmail.com>
*cough* Oracle licensing *cough*. Bear in mind 60 responses is about the same as those TV cosmetic ads (90% agree that product X works) use and so is better than personal experience, but not scientific. On 7 Aug 2014 10:18, "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com> wrote:
> I would think more than 10 (yes, 10 not 100) schemas in a database would
> be a multi-application database ! (Except for products like EBusiness
> Suite that has many schemas but uses only 1 account to execute DML).
>
>
>
> A large number of schemas in a database is the result of a consolidation
> exercise. So there seem to have been very many consolidations with a
> single database supporting multiple applications (services).
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Niall Litchfield
> *Sent:* Thursday, August 07, 2014 5:04 PM
> *To:* William Robertson
> *Cc:* ORACLE-L
> *Subject:* Re: Survey: How many schemas is "many"
>
>
>
> That's a fair question, Patrice's original question arose in the context
> of the SQL Developer diff tool for comparing schemas in 2 different
> databases. In that context I considered an empty schema to count towards
> the number of schemas in a db since you definitely want to know if it is
> empty in db A but populated in db B. However it did seem likely to me that
> most people would go with your definition - hence Q2.
>
> As I'm away for a bit now, and we have 60 responses, the results so far
> (DB account = any user, schema = user owning objects) are below. So the
> anecdotal evidence from this list is that it is unusual, but hardly unheard
> of, to have > 100 users owning database objects. If anyone missed Jeff's
> later reply on the other thread the DBDiff feature of SQL*Developer isn't
> really intended to be used at that sort of scale.
>
> Total DB accounts
>
> 0-10 15.00%
> 10-100 40.00%
> 100-500 28.33%
> 500-1000 10.00%
> 1000-5000 1.67%
> 5000+ 5.00%
>
>
> Total Schemas
>
> 0-10 31.67%
> 10-100 45.00%
> 100-500 18.33%
> 500-1000 3.33%
> 1000+ 1.67%
>
> Niall
>
> <pedantry>
>
> I'd go with schema as being a set of objects in a single namespace and of
> course would say that that must logically include the empty set :)
>
> </pedantry>
>
>
>
>
>
> On Thu, Aug 7, 2014 at 8:58 AM, William Robertson <
> william_at_williamrobertson.net> wrote:
>
> How are we defining "schema"? To me it's a collection of database objects
> owned by a single account (or equivalent namespace), so I was a bit puzzled
> by the two-part question. A user that owns no objects (such as a read-only
> production account) is not a schema, surely.
>
>
>
> William Robertson
>
>
>
>
> On 5 Aug 2014, at 14:35, Niall Litchfield <niall.litchfield_at_gmail.com>
> wrote:
>
> All
>
>
>
> For those not following the dbdiff thread I've created a 2 question survey
> at https://www.surveymonkey.com/s/VGKZMY5 to get some statistics on how
> many different schemas databases in the wild actually contain. If we get
> more than, say, 50 responses I'll post back the answers here.
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 07 2014 - 11:30:24 CEST