Re: "Correct" term for a 1:1 relationship between a "database" and an "instance" where > 1 such things are on the same physical server?

From: joel garry <>
Date: Wed, 22 Jul 2009 10:28:28 -0700 (PDT)
Message-ID: <>

On Jul 22, 6:37 am, dana <> wrote:
> Thanks Mark. That was helpful. You wrote:
> > In most practical uses you can use the term database to refer to both the physical database and the instance.
> ...
> > database: Collection of data that is treated as a unit. The purpose of
> > a database is to store and retrieve related information. Each Oracle
> > database instance accesses only one database.
> So when people loosely use the term "instance" or "database instance"
> they're not completely off base, are they? If each instance can ever
> only access one, and only one, database, then it shouldn't be
> "considered harmful" to speak this way? Or is the definition implying
> that a particular instance can only access one and only one database
> at any one time? I think this was what Tom Kyte was saying in the rest
> of that book section. I need to re-read it, and will.
> Here's another question for you:
> 1) Would there ever be any practical reason for two instances (procs +
> SGA) to access the same database (collection of data treated as a
> unit) on the same, unpartitioned physical server?
> 2) Tangentially related, while I'm at it--is the chief and most
> obvious benefit of RAC High Availability? Are claims that RAC can be
> used for scalability mostly hype? Last I checked, there was
> controversy over this one--guess I need to re-read the "Why You Don't
> Need RAC" article; never used RAC and I'm not sure I can even
> articulate precisely what it does let alone how it does it. How does
> RAC relate to the concepts of "instance" and "database"?
> > instance: A system global area (SGA) and the Oracle Database
> > background processes constitute an Oracle database instance. Every
> > time a database is started, a system global area is allocated and
> > Oracle Database background processes are started. The SGA is
> > deallocated when the instance shuts down.
> > Notice the use of the term Oracle database instance appears in both definitions.
> Dana

There are also other Oracle things called instances that are not what we think of as database instances. For example, an ASM instance is a bunch of memory structures for controlling storage. OC4J has instances. The Grid API has instances. I don't even know what Beehive is, but it has instances.

So all those books are wrong, outside a narrow database-centric view. Since we are all running this open-source stuff along with the database now, we, most especially DBA's, need precision in communication. Of course, if everyone says something, the language changes, regardless of whether it is stupid or counterproductive. The change itself can be interesting.


-- is bogus.
The I-Pod of soda machines will dumbfound the person in front of you.
Received on Wed Jul 22 2009 - 12:28:28 CDT

Original text of this message