Re: understanding oracle terminology - instance, database, sid, schema
From: joel garry <joel-garry_at_home.com>
Date: Thu, 24 Jun 2010 08:53:00 -0700 (PDT)
Message-ID: <43104a41-330c-4db8-97fa-dddafe2752a3_at_y11g2000yqm.googlegroups.com>
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.
Date: Thu, 24 Jun 2010 08:53:00 -0700 (PDT)
Message-ID: <43104a41-330c-4db8-97fa-dddafe2752a3_at_y11g2000yqm.googlegroups.com>
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/30ff122e2dd33c69?dmode=sourceReceived on Thu Jun 24 2010 - 10:53:00 CDT