SQL Server for Oracle DBA's
NetComrade
for users of a superior product :)
Particularly interested in 'how to tune', but 'general concepts' will
do as well.
Thanks in advance!
.......
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
remove NSPAM to email
Noons
>
> 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.mspx
don't tell Larry...
there is also a "rozetta stone"-like page
for commands, ask Gary: I sent it to him
a while ago.
joel garry
> On Apr 1, 3:29 pm, NetComrade
>
>
>
> > Particularly interested in 'how to tune', but 'general concepts' will
> > do as well.
>
> > Thanks in advance!
>
> psst:
>
"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.htm#i60813
"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
DA Morgan
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
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
fitzj...@cox.net
> joel garry wrote:
> > On Apr 1, 5:22 am, Noons <wizofo...@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....
>
> 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
Noons
>
> 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!
>
LOL!
I didn't say it was correct from the point of view of Oracle.
It is a microslop document after all!
It is however quite correct for SS. For those
who know Oracle the appropriate filtering can be applied,
of course.
> So, what's the command to make the applications use the same
> transaction model?
>
None. But you'll find all the necessary
commands to maintain a basic SQL Server
and Oracle environments. I'll look it up
and post the link later. It's in one of Gary's
entries in his blog, as well.
Noons
>
> > 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?
>
Found it. here:
http://www.aronson.co.il/DbEquiv.php
I knew Gary had posted a link to it in his blog:
http://igor-db.blogspot.com/
I do recommend reading the various
differences between db2, mysql, oracle and ss.
Quite a useful site to have handy if you
have to live with a multi-vendor site.
DAMHIKT...
Annika1980
joel garry
> On Apr 2, 1:56 am, joel garry <joel-ga...@home.com> wrote:
>
>
>
> > 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!
>
> LOL!
> I didn't say it was correct from the point of view of Oracle.
> It is a microslop document after all!
> It is however quite correct for SS. For those
> who know Oracle the appropriate filtering can be applied,
> of course.
Well, if the first screen is so wrong, you know what they say about
first impressions... and what are these automatic backups in Oracle
they talk about?
>
> > So, what's the command to make the applications use the same
> > transaction model?
>
> None. But you'll find all the necessary
> commands to maintain a basic SQL Server
> and Oracle environments. I'll look it up
> and post the link later. It's in one of Gary's
> entries in his blog, as well.
Well, I continue to work on db-independent apps. And I continue to
laugh at the O10 instructions for them that still cut and paste O7
instructions. And I continue to be amazed they still work and perform
well in character mode, thin client and web based. And I continue to
be sick of the lowest-common-denominator approach required to work
with mslop and O with the same app. And I continue to laugh at places
who manage Oracle databases with SQL Server attitudes.
It might help if you specified which Gary... I see too much SpongeBob.
jg
--
@home.com is bogus.
DA Morgan
Then my apology for misreading the context.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Mladen Gogala
> Hey Noons, why does your family all have such huge noses?
>
> http://members.aol.com/annika1980/honker.jpg
I thought that this was the "TeraKnowledge" moron, but this is some
redneck from TN. It seems that devil didn't go just to GA.
Serge Rielau
> On Apr 2, 1:56 am, joel garry <joel-ga...@home.com> wrote:
>
>>> 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?
>>
>
>
>
> Found it. here:
>
> http://www.aronson.co.il/DbEquiv.php
Nice that it's editable.
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Noons
> Noons wrote:
> > On Apr 2, 1:56 am, joel garry <joel-ga...@home.com> wrote:
>
> >>> 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?
>
> > Found it. here:
>
> >http://www.aronson.co.il/DbEquiv.php
>
> I have filled in most of the DB2 gaps.
> Nice that it's editable.
> --
Thanks, Serge.
Shakespeare
"Mladen Gogala" <mgo...@yahoo.com> schreef in bericht
news:47f2b571$0$1348$834e...@reader.greatnowhere.com...
> On Tue, 01 Apr 2008 14:14:14 -0700, Annika1980 wrote:
>
>> Hey Noons, why does your family all have such huge noses?
>>
>
> I thought that this was the "TeraKnowledge" moron, but this is some
> redneck from TN. It seems that devil didn't go just to GA.
>
>
>
> --
> http://mgogala.freehostia.com
This problem spreads over multiple groups (golf, photography and now
Oracle). Noons (or someone impersonating him) parrotting an..1980 and vice
versa an..1980 bullying Noons.
Could be someone impersonating an..1980 as well, but highly unlikely.
an..1980 =
Mr Bret. Douglas
3505 Oak Ridge Dr Chattanooga, TN 37415 USA
No need to ask for apologies, I fear. Killfiling an..1980 might be the only
solution.
Shakespeare