Re: understanding oracle terminology - instance, database, sid, schema

From: rogergorden_at_....gmail.com <rogergorden_at_gmail.com>
Date: Thu, 24 Jun 2010 09:07:06 -0700 (PDT)
Message-ID: <a247b03f-c36a-4c22-8ac0-2d28dcaaf8c6_at_t10g2000yqg.googlegroups.com>

On Jun 24, 11:53 am, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 24, 8:28 am, The Quiet Center <thequietcen..._at_gmail.com> wrote:
>
> > On Jun 24, 11:24 am, The Quiet Center <thequietcen..._at_gmail.com>
> > wrote:
>
> > > there is a lot of Oracle terminology that I dont understand.
> > > Specifically:
> > > - instance
>
> > Found it -http://www.orafaq.com/wiki/Database_Concepts_and_Architecture
> > An instance can mount and open one and only one database.
>
> The database concepts manual is required reading first.  After that,
> check out books by Tom Kyte, he is good at relating concepts you
> already know to their Oracle equivalents.  He also rewrote the
> concepts manual for 11g, btw.
>
> Over the years, I've noticed the most important thing for developers
> coming from other dbms's is to understand Oracle's locking and
> concurrency model.
>
> jg
> --
> _at_home.com is bogus.http://groups.google.com/group/comp.os.linux.development.system/msg/3...

I've also seen that developers coming from other rdbms's should understand is Oracle's Sequence, rather than "MAX(id) + 1" for inserts.

Roger Gorden Received on Thu Jun 24 2010 - 11:07:06 CDT