Re: SQL Server for Oracle DBA's

From: <fitzjarrell_at_cox.net>
Date: Tue, 1 Apr 2008 13:43:58 -0700 (PDT)
Message-ID: <2b315e0b-3542-4d7c-93c8-294165cbd717@59g2000hsb.googlegroups.com>


On Apr 1, 11:05 am, DA Morgan <damor..._at_psoug.org> wrote:
> joel garry wrote:
> > On Apr 1, 5:22 am, Noons <wizofo..._at_aol.com> wrote:
> >> On Apr 1, 3:29 pm, NetComrade
>
> >>> Particularly interested in 'how to tune', but 'general concepts' will
> >>> do as well.
> >>> Thanks in advance!
> >> psst:
>
> >>http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro...
>
> > "In Oracle, a database refers to the entire Oracle RDBMS environment
> > and includes these components:
>
> > * Oracle database processes and buffers (instance)..."
>
> > Hmmmm....
>
> >http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro....
>
> > "Overview of the Oracle Instance
> > An Oracle database server consists of an Oracle database and an Oracle
> > instance. Every time a database is started, a system global area (SGA)
> > is allocated and Oracle background processes are started. The
> > combination of the background processes and memory buffers is called
> > an Oracle instance."
>
> > This darn database stuff is so confusing!
>
> >> don't tell Larry...
>
> >> there is also a "rozetta stone"-like page
> >> for commands, ask Gary: I sent it to him
> >> a while ago.
>
> > So, what's the command to make the applications use the same
> > transaction model?
>
> > jg
> > --
> > @home.com is bogus.
> >http://www.google.com/search?hl=en&q=johnny+depp+condom
>
> Au contraire mon ami.
>
> In Oracle the database does not consist of processes and buffers
> or anything of the kind. The "database" is a set of related
> physical files ... data files, temp files, undo files, control
> files, redo log files, password file, spfile. What you are
> describing is the "instance."
>
> Get into RAC with srvctl and the difference becomes critical.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

I believe Joel was quoting the SQL Server document in the associated link.

David Fitzjarrell Received on Tue Apr 01 2008 - 15:43:58 CDT

Original text of this message