By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,784 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,784 IT Pros & Developers. It's quick & easy.

SQL Server to Oracel

P: n/a
I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly.
How different is Oracle on Linux then Oracle on windows. What are the major
differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx
Jul 20 '05 #1
Share this Question
Share on Google+
27 Replies


P: n/a
Now, that is a change. Change of OS AND change in database :)

Forget everything about sql server and start out with the Oracle beginners
classes or books.
- Same for Linux vs. NT.

Moving from Unix to Linux (not counting Sys Admin work) is not much of a
change for DBAs, in my opinion.

Note: I personally perfer Oracle on Unix or Linux.

--

"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2j*************@uni-berlin.de...
I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly. How different is Oracle on Linux then Oracle on windows. What are the major differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx

Jul 20 '05 #2

P: n/a

"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2j*************@uni-berlin.de...
I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly. How different is Oracle on Linux then Oracle on windows. What are the major differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx


There's really only one link to turn to at a time like this:
http://tahiti.oracle.com. Find the version you'll be dealing with, then
click on the list of books for that version, and then find the Concepts
guide. If you've got multiple versions, I'd suggest using the 9i links,
rather than 10g (unless of course your organisation is actually running
10g). 10g is significantly different, architecturally, from any prior Oracle
version, and a lot will mislead or confuse if you try and apply 10g
knowledge to 9i or 8i. Whereas 9i concepts are, pretty much, applicable to
8i most of the time, and 8i is almost 100% applicable to 8.0.

There is no difference between Oracle on any platform. Well, OK: Linux and
Unix are process-based operating systems, and Windows is a thread-based one,
so whereas you can actually *see* PMON, SMON, DBWn and the rest on a *nix
platform, you can't see the equivalent threads on Windows. But they're still
there alright, and still do the same jobs as their equivalent processes on
*nix. The only other major difference I can think of is that *nix does
shared memory allocations for the SGA via kernel parameters, and Windows
does it via the creation (and running, obviously) of a service for each
SGA/Instance. But that's minor stuff. 99% of what's in the concepts guide
will apply to both platforms without change.

There is no answer to the question 'what are the major differences between
Oracle and SQL Server'. Their very terminology is different (Oracle schema =
SQL Server database, for example). You might as well ask how different a
peach is from the Eiffel Tower. Both are rather beautiful, serve their
purposes well, and have little fundamentally in common except that they are
both made of atoms. Try not to compare the two products; just learn each on
their own terms. That means, for you, learning Oracle on its terms. You will
probably always be "infected" by a tendency to see things from a SQL Server
perspective, just as I look at SQL Server and scream in horror that it's not
Oracle. That's just inevitable. What separates the DBAs from the geeky
bigots is to be able to embrace those differences and accept them, rather
than see them as a reason to despise one or other product.

Other useful links: www.jlcomp.demon.co.uk and (though I'm biased)
www.dizwell.com

It would help to learn how to spell the product you'll now be working with,
too.

Regards
HJR
Jul 20 '05 #3

P: n/a
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2j*************@uni-berlin.de...
I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and

quickly.
How different is Oracle on Linux then Oracle on windows. What are the

major
differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx


There's really only one link to turn to at a time like this:
http://tahiti.oracle.com. Find the version you'll be dealing with, then
click on the list of books for that version, and then find the Concepts
guide. If you've got multiple versions, I'd suggest using the 9i links,
rather than 10g (unless of course your organisation is actually running
10g). 10g is significantly different, architecturally, from any prior Oracle
version, and a lot will mislead or confuse if you try and apply 10g
knowledge to 9i or 8i. Whereas 9i concepts are, pretty much, applicable to
8i most of the time, and 8i is almost 100% applicable to 8.0.

There is no difference between Oracle on any platform. Well, OK: Linux and
Unix are process-based operating systems, and Windows is a thread-based one,
so whereas you can actually *see* PMON, SMON, DBWn and the rest on a *nix
platform, you can't see the equivalent threads on Windows. But they're still
there alright, and still do the same jobs as their equivalent processes on
*nix. The only other major difference I can think of is that *nix does
shared memory allocations for the SGA via kernel parameters, and Windows
does it via the creation (and running, obviously) of a service for each
SGA/Instance. But that's minor stuff. 99% of what's in the concepts guide
will apply to both platforms without change.

There is no answer to the question 'what are the major differences between
Oracle and SQL Server'. Their very terminology is different (Oracle schema =
SQL Server database, for example). You might as well ask how different a
peach is from the Eiffel Tower. Both are rather beautiful, serve their
purposes well, and have little fundamentally in common except that they are
both made of atoms. Try not to compare the two products; just learn each on
their own terms. That means, for you, learning Oracle on its terms. You will
probably always be "infected" by a tendency to see things from a SQL Server
perspective, just as I look at SQL Server and scream in horror that it's not
Oracle. That's just inevitable. What separates the DBAs from the geeky
bigots is to be able to embrace those differences and accept them, rather
than see them as a reason to despise one or other product.

Other useful links: www.jlcomp.demon.co.uk and (though I'm biased)
www.dizwell.com

It would help to learn how to spell the product you'll now be working with,
too.

Regards
HJR


Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.

OMLET right on your ass
http://www.geocities.com/TeraKnowledgeSystems
download OMLET v4: The Ultimate Oracle Monitoring Tool
Jul 20 '05 #4

P: n/a

<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...


Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.


You really are a tiresome little oik, and a liar regarding your employment
history to boot.

Go away, you funny little man.

Jul 20 '05 #5

P: n/a
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...


Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.


You really are a tiresome little oik, and a liar


HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar and I would pull OMLET off the internet or I post documents,
paychecks to mutually agreed upon professional; Let say someone I
reviewed his book in 1998 which you claimed to know as well! and you
would pay me $10,000; not much for a expert like you. Are you up to
this? Anyone else?

For the record, check my papers on the net:
http://www.informatik.uni-trier.de/~...:Amjad_M=.html

in 1995 I published a paper while at Oracle Server Technologies; Can
you Read?! you might learn how to spell before you bombard us with
your wisedom.

Surely, there ain't two people who can mispell Oracle as Oracel in the
world, you and the newbie must be YOU. Proven by induction.
So upon the evidence in front of me: I bet 1000 to 1 that you wrote
that message.

why?

because you a dump hippocrate!
Jul 20 '05 #6

P: n/a

<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...


Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.


You really are a tiresome little oik, and a liar


HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar and I would pull OMLET off the internet or I post documents,
paychecks to mutually agreed upon professional; Let say someone I
reviewed his book in 1998 which you claimed to know as well! and you
would pay me $10,000; not much for a expert like you. Are you up to
this? Anyone else?

For the record, check my papers on the net:

http://www.informatik.uni-trier.de/~...:Amjad_M=.html
in 1995 I published a paper while at Oracle Server Technologies; Can
you Read?! you might learn how to spell before you bombard us with
your wisedom.

Surely, there ain't two people who can mispell Oracle as Oracel in the
world, you and the newbie must be YOU. Proven by induction.
So upon the evidence in front of me: I bet 1000 to 1 that you wrote
that message.

why?

because you a dump hippocrate!


Don't tell people to learn how to spell when your post is full of spelling
and grammar mistakes.
Jul 20 '05 #7

P: n/a
om***@omlet.org wrote in message news:<dc**************************@posting.google. com>...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...


Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.


You really are a tiresome little oik, and a liar


HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar and I would pull OMLET off the internet or I post documents,
paychecks to mutually agreed upon professional; Let say someone I
reviewed his book in 1998 which you claimed to know as well! and you
would pay me $10,000; not much for a expert like you. Are you up to
this? Anyone else?

For the record, check my papers on the net:
http://www.informatik.uni-trier.de/~...:Amjad_M=.html

in 1995 I published a paper while at Oracle Server Technologies; Can
you Read?! you might learn how to spell before you bombard us with
your wisedom.

Surely, there ain't two people who can mispell Oracle as Oracel in the
world, you and the newbie must be YOU. Proven by induction.
So upon the evidence in front of me: I bet 1000 to 1 that you wrote
that message.

why?

because you a dump hippocrate!

Apparently the only 'dump hippocrate' is you.

Your 'induction' skill is horribly off because such 'induction' is
based upon insufficient evidence at best. It would never stand the
rigorous scrutiny such an inductive proof would undergo upon
validation.

Stop harassing the participants in comp.databases.oracle.server, and
any other Oracle-related newsgroups in which you happen to post such
drivel. It is far from professional, it is thoroughly unnecessary and
it is quite juvenile. Not the sort of behaviour I'd expect from
someone professing to be an "expert".

Some once defined "expert" in this manner: "'ex' is a has-been and
'spurt' is a drip under pressure". You certainly fill this bill based
upon your recent litany of newsgroup assaults.

Please find a suitable playground and leave the adults in peace.

David Fitzjarrell
Jul 20 '05 #8

P: n/a

<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message

news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...


Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.


You really are a tiresome little oik, and a liar


HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar

Will having talked to the person you claimed was your boss, and discovering
he knows nothing about it, count?
HJR
Jul 20 '05 #9

P: n/a
Oracle Newbie wrote:
I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly.
How different is Oracle on Linux then Oracle on windows. What are the major
differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx


Forget 90% of your SQL Server background. They differences between
the products are greater than the similarities.

Follow Burt Peltier's and Howard Roger's advice.

And get a copy of Tom Kyte's book Expert One-on-one Oracle and
read the first three chapters as though your employability
depended on it.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Jul 20 '05 #10

P: n/a

<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message

news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...


Wow! get a newbie who cannot spell Oracle!


That was a typo in my subject line.
Jul 20 '05 #11

P: n/a

"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2k*************@uni-berlin.de...

<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message

news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
>
> Wow! get a newbie who cannot spell Oracle!


That was a typo in my subject line.


*I* knew that, and merely wanted to stress that it pays (a) to get on top of
a subject quickly and (b) to be precise about things. We all make typos. My
favourite is that I can never type 'buffer cache' without inadvertently
hitting the 'g' key instead. But I try to proof-read before hitting the send
key. Someone else decided that it would make good copy for a reason that has
nothing to do with what you wrote about, nor what I replied about.

Regards
HJR
Jul 20 '05 #12

P: n/a
fi*********@cox.net (David Fitzjarrell) wrote in message news:<97**************************@posting.google. com>...
om***@omlet.org wrote in message news:<dc**************************@posting.google. com>...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
>
> Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
> is you HJR that cooked the newbie message and your bias is apparent
> with your dizwell shit.
>
> hopeless.

You really are a tiresome little oik, and a liar


HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar and I would pull OMLET off the internet or I post documents,
paychecks to mutually agreed upon professional; Let say someone I
reviewed his book in 1998 which you claimed to know as well! and you
would pay me $10,000; not much for a expert like you. Are you up to
this? Anyone else?

For the record, check my papers on the net:
http://www.informatik.uni-trier.de/~...:Amjad_M=.html

in 1995 I published a paper while at Oracle Server Technologies; Can
you Read?! you might learn how to spell before you bombard us with
your wisedom.

Surely, there ain't two people who can mispell Oracle as Oracel in the
world, you and the newbie must be YOU. Proven by induction.
So upon the evidence in front of me: I bet 1000 to 1 that you wrote
that message.

why?

because you a dump hippocrate!

Apparently the only 'dump hippocrate' is you.

Your 'induction' skill is horribly off because such 'induction' is
based upon insufficient evidence at best. It would never stand the
rigorous scrutiny such an inductive proof would undergo upon
validation.

Stop harassing the participants in comp.databases.oracle.server, and
any other Oracle-related newsgroups in which you happen to post such
drivel. It is far from professional, it is thoroughly unnecessary and
it is quite juvenile. Not the sort of behaviour I'd expect from
someone professing to be an "expert".

Some once defined "expert" in this manner: "'ex' is a has-been and
'spurt' is a drip under pressure".


I am impressed, you can now pass to the 2nd grade and with it you get TonkaII
that is like 10g that can tune itself.

Now go and f*** yourself; you dump jumble Q of crab.
Jul 20 '05 #13

P: n/a
om***@omlet.org wrote in message news:<dc**************************@posting.google. com>...
fi*********@cox.net (David Fitzjarrell) wrote in message news:<97**************************@posting.google. com>...
om***@omlet.org wrote in message news:<dc**************************@posting.google. com>...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
> <om***@omlet.org> wrote in message
> news:dc**************************@posting.google.c om...
>
>
> >
> > Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
> > is you HJR that cooked the newbie message and your bias is apparent
> > with your dizwell shit.
> >
> > hopeless.
>
> You really are a tiresome little oik, and a liar

HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar and I would pull OMLET off the internet or I post documents,
paychecks to mutually agreed upon professional; Let say someone I
reviewed his book in 1998 which you claimed to know as well! and you
would pay me $10,000; not much for a expert like you. Are you up to
this? Anyone else?

For the record, check my papers on the net:
http://www.informatik.uni-trier.de/~...:Amjad_M=.html

in 1995 I published a paper while at Oracle Server Technologies; Can
you Read?! you might learn how to spell before you bombard us with
your wisedom.

Surely, there ain't two people who can mispell Oracle as Oracel in the
world, you and the newbie must be YOU. Proven by induction.
So upon the evidence in front of me: I bet 1000 to 1 that you wrote
that message.

why?

because you a dump hippocrate!

Apparently the only 'dump hippocrate' is you.

Your 'induction' skill is horribly off because such 'induction' is
based upon insufficient evidence at best. It would never stand the
rigorous scrutiny such an inductive proof would undergo upon
validation.

Stop harassing the participants in comp.databases.oracle.server, and
any other Oracle-related newsgroups in which you happen to post such
drivel. It is far from professional, it is thoroughly unnecessary and
it is quite juvenile. Not the sort of behaviour I'd expect from
someone professing to be an "expert".

Some once defined "expert" in this manner: "'ex' is a has-been and
'spurt' is a drip under pressure".


I am impressed, you can now pass to the 2nd grade and with it you get TonkaII
that is like 10g that can tune itself.

Now go and f*** yourself; you dump jumble Q of crab.


I'm sorry, but my on-line gibberish dictionary currently is not
working. Would you care to explain what a 'dump jumble Q of crab'
might be? Enlighten us all, if you can do it without further
obscenities.

David Fitzjarrell
Jul 20 '05 #14

P: n/a

"David Fitzjarrell" <fi*********@cox.net> schreef in bericht
news:97*************************@posting.google.co m...
om***@omlet.org wrote in message

news:<dc**************************@posting.google. com>...
fi*********@cox.net (David Fitzjarrell) wrote in message news:<97**************************@posting.google. com>...
om***@omlet.org wrote in message news:<dc**************************@posting.google. com>... > "Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>... > > <om***@omlet.org> wrote in message
> > news:dc**************************@posting.google.c om...
> >
> >
> > >
> > > Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it > > > is you HJR that cooked the newbie message and your bias is apparent > > > with your dizwell shit.
> > >
> > > hopeless.
> >
> > You really are a tiresome little oik, and a liar
>
> HJR,
>
> Put your money where your mouth is and let us have a bet: You prove me > a liar and I would pull OMLET off the internet or I post documents,
> paychecks to mutually agreed upon professional; Let say someone I
> reviewed his book in 1998 which you claimed to know as well! and you
> would pay me $10,000; not much for a expert like you. Are you up to
> this? Anyone else?
>
> For the record, check my papers on the net:
> http://www.informatik.uni-trier.de/~...:Amjad_M=.html >
> in 1995 I published a paper while at Oracle Server Technologies; Can
> you Read?! you might learn how to spell before you bombard us with
> your wisedom.
>
> Surely, there ain't two people who can mispell Oracle as Oracel in the > world, you and the newbie must be YOU. Proven by induction.
> So upon the evidence in front of me: I bet 1000 to 1 that you wrote
> that message.
>
> why?
>
> because you a dump hippocrate!
Apparently the only 'dump hippocrate' is you.

Your 'induction' skill is horribly off because such 'induction' is
based upon insufficient evidence at best. It would never stand the
rigorous scrutiny such an inductive proof would undergo upon
validation.

Stop harassing the participants in comp.databases.oracle.server, and
any other Oracle-related newsgroups in which you happen to post such
drivel. It is far from professional, it is thoroughly unnecessary and
it is quite juvenile. Not the sort of behaviour I'd expect from
someone professing to be an "expert".

Some once defined "expert" in this manner: "'ex' is a has-been and
'spurt' is a drip under pressure".


I am impressed, you can now pass to the 2nd grade and with it you get TonkaII that is like 10g that can tune itself.

Now go and f*** yourself; you dump jumble Q of crab.


I'm sorry, but my on-line gibberish dictionary currently is not
working. Would you care to explain what a 'dump jumble Q of crab'
might be? Enlighten us all, if you can do it without further
obscenities.

David Fitzjarrell


He just proved he can mispell (sic!) crap as crab.
When you google for "Q of crap", you get just this 1 hit titled "Add URL to
Q of crap rules directory":
http://www.crap-rules.net/add_url/Ga...dows/Titles/Q/
the perfect place where he can advertize his Omlet jumble...
Jul 20 '05 #15

P: n/a
"Dave" <da*************@ntlXworld.com> wrote in message news:<340Dc.40$Pp.32@newsfe5-win>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
because you a dump hippocrate!


Don't tell people to learn how to spell when your post is full of spelling
and grammar mistakes.


What spelling mistake? A "dump hippocrate" is obviously a container
for disposing of unwanted hippopotamii, and apparently Omlet thinks
somebody resembled one...?
Jul 20 '05 #16

P: n/a
"Dave" <da*************@ntlXworld.com> wrote in message news:<340Dc.40$Pp.32@newsfe5-win>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
"Howard J. Rogers" <hj*@dizwell.com> wrote in message

news:<40***********************@news.optusnet.com. au>...
<om***@omlet.org> wrote in message
news:dc**************************@posting.google.c om...
>
> Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
> is you HJR that cooked the newbie message and your bias is apparent
> with your dizwell shit.
>
> hopeless.

You really are a tiresome little oik, and a liar


HJR,

Put your money where your mouth is and let us have a bet: You prove me
a liar and I would pull OMLET off the internet or I post documents,
paychecks to mutually agreed upon professional; Let say someone I
reviewed his book in 1998 which you claimed to know as well! and you
would pay me $10,000; not much for a expert like you. Are you up to
this? Anyone else?

For the record, check my papers on the net:

http://www.informatik.uni-trier.de/~...:Amjad_M=.html

in 1995 I published a paper while at Oracle Server Technologies; Can
you Read?! you might learn how to spell before you bombard us with
your wisedom.

Surely, there ain't two people who can mispell Oracle as Oracel in the
world, you and the newbie must be YOU. Proven by induction.
So upon the evidence in front of me: I bet 1000 to 1 that you wrote
that message.

why?

because you a dump hippocrate!


Don't tell people to learn how to spell when your post is full of spelling
and grammar mistakes.


Not to mention his "book..."

"In general, if recursive calls is greater than 4 per process, the
data dictionary should be optimized and segments should be rebuilt
with storage clauses to have a few large extents. "
- OraclE 9I Performance Tuning WITH OMLET [SIC, directly
cut-and-pasted]

Man, now that I've actually looked at that crappy book, I see why the
"Dr." is so defensive. It (and his basic product) is just rehashed
myths from around 1995. He even thanks Digital! Jeez, makes me
nostalgic.

Note to all Oracle professionals: re-read the manuals for new
versions, and pay attention to people who point out errors.

jg
--
@home.com is bogus.
NOW What?
Jul 20 '05 #17

P: n/a

"Joel Garry" <jo********@home.com> wrote in message
news:91**************************@posting.google.c om...
Not to mention his "book..."
It's delicious, isn't it? I mean, here's a man who blasts everyone for not
being able to spell, type or grasp grammar, who comes out with such gems as:

"For tuning to be effective, we must identify these sources and find ways to
alleviate them" (I've heard of alleviating pain, but alleviating
*sources*?!)
"This book blends tuning techniques with practical details that is hard to
find anywhere" (Yup, I like sentences which is making mistakes regarding
number)
"Trademarks names appear throughout the book" (Trademark names... or
Trademarks appear... but not... well, you get the idea)
"Otherwise, consider to increase SHARED_POOL_SIZE." ("Consider to..."?????)

Slightly more technically, we have this gem:
"you can increase the size of the buffer cache by increasing the size of the
db_block_buffers configuration parameter" (Not even close for 9i...
remember, this book is called 'Oracle 9i Performance Tuning with Omlet'!
Apparently, the good doctor has never heard of db_cache_size. As Joel says,
"Dr" Amjad is living in the mid-nineties)

Actually, one wonders where he got his doctorate from. "Doctorates R Us" in
central Mysore, I would have to guess -particularly since he cites it
*after* his OCP!!

Regards
HJR


"In general, if recursive calls is greater than 4 per process, the
data dictionary should be optimized and segments should be rebuilt
with storage clauses to have a few large extents. "
- OraclE 9I Performance Tuning WITH OMLET [SIC, directly
cut-and-pasted]

Man, now that I've actually looked at that crappy book, I see why the
"Dr." is so defensive. It (and his basic product) is just rehashed
myths from around 1995. He even thanks Digital! Jeez, makes me
nostalgic.

Note to all Oracle professionals: re-read the manuals for new
versions, and pay attention to people who point out errors.

jg
--
@home.com is bogus.
NOW What?

Jul 20 '05 #18

P: n/a
Howard J. Rogers (hj*@dizwell.com) writes:
Slightly more technically, we have this gem: "you can increase the size
of the buffer cache by increasing the size of the db_block_buffers
configuration parameter"


As an SQL Server person, I did not expect that I would post in this
thread, but this was just too much! You increase the size of the
parameter? Ah, so you change the parameter from being a two-byte value
to be a four-byte value?

Gosh! That you can't do in SQL Server! Oracle is really powerful! Maybe I
should learn Oracle some day?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #19

P: n/a
jo********@home.com (Joel Garry) wrote in message

"In general, if recursive calls is greater than 4 per process, the
data dictionary should be optimized and segments should be rebuilt
with storage clauses to have a few large extents. "
- OraclE 9I Performance Tuning WITH OMLET [
This is a product for 8i,9i,10g! So your comments are misplaced. Self
tuning; local management, undo segments and db_cache_size are not as
widely used as you think. Of course, you are entitled to your opinion;
you write books that you sell for $100 and as such you better be
giving people their money's worth.

The book is about OMLET and tuning Oracle with OMLET; as such, only
queries that made it into a version are reflected in the book. It is
not targeting general audience.
He even thanks Digital!
I worked for Digital Rdb - the KODA group; and joined Oracle when they
bought the Digital rdbms business and as such I thank Digital for
doing that: having access to the Rdb code; which SQL server borrowed
heavily. I added index only tables to Rdb and later to Oracle kernel.
Of course your mother helped me do that; she s*** nicely!
Jeez, makes me
nostalgic.
see a doctor; perhaps the rags slipped! got the OMLET treatment or
both!

Note to all Oracle professionals: re-read the manuals for new
versions, and pay attention to people who point out errors.
I guess Oracle profs are capable of do that by themselves. Do not
insult them or their intel. with your crab.

jg

Jul 20 '05 #20

P: n/a
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
"Joel Garry" <jo********@home.com> wrote in message
news:91**************************@posting.google.c om...
Actually, one wonders where he got his doctorate from. "Doctorates R Us" in
central Mysore, I would have to guess -particularly since he cites it
*after* his OCP!!


My OCP is OMLET Certified Prof. I know OMLET well and I am proud of it
and what is stands for. Where is your social manners: never insult
someone university, party, or his OMLET!

HotShit J. Rogers cannot understand that this book is free, written
for a specific product: OMLET.
Jul 20 '05 #21

P: n/a
"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...
"Joel Garry" <jo********@home.com> wrote in message
It's delicious, isn't it?
"Otherwise, consider to increase SHARED_POOL_SIZE."
"In general, if recursive calls is greater than 4 per process, the

--
@home.com is bogus.
NOW What?


As I am a big fan of Christine Aguilera; and your quote "NOW What"
brings fond memory. Let me tell now what: it is time you open your
legs and get BANGED! Of course you can choose to this recursively; and
using hard pumps!
Joel and HJR of course can share the pleasure pool and stretch to any
size!

All at @home!
shameless.
Jul 20 '05 #22

P: n/a
I think this thread has gone on far enough.

Amjad has clearly lost it, is fast becoming yet another net kook, and
these posts are starting to become nothing but obscene. I would suggest
everybody just avoid replies, and hopefully it will go away.

Amjad - I seriously think you should cease and desist. You are not doing
yourself any favours, and I think you need to remember that whatever you
post here will be with you forever.

Do you really want your children, your wife, (or even your mother)
discovering these posts for themselves one day ?

Jul 20 '05 #23

P: n/a
om***@omlet.org wrote in message news:<dc*************************@posting.google.c om>...
jo********@home.com (Joel Garry) wrote in message

"In general, if recursive calls is greater than 4 per process, the
data dictionary should be optimized and segments should be rebuilt
with storage clauses to have a few large extents. "
- OraclE 9I Performance Tuning WITH OMLET [
This is a product for 8i,9i,10g! So your comments are misplaced. Self
tuning; local management, undo segments and db_cache_size are not as
widely used as you think. Of course, you are entitled to your opinion;
you write books that you sell for $100 and as such you better be
giving people their money's worth.


If you speak of Howard J. Rogers his books DO provide people with
their money's worth, in many cases ten times over. Unlike you, who
can only write degrading and obscene verbiage to those who, with good
reason, disagree with your misguided methodology.

The book is about OMLET and tuning Oracle with OMLET; as such, only
queries that made it into a version are reflected in the book. It is
not targeting general audience.


You're still using unreliable hit ratios; I wouldn't begin to consider
that tuning Oracle. Hit ratios hide information; all ratios do. This
percentage, that percentage ... it's all fluff and nonsense. I've
seen databases with 99.999% db buffer cache hit ratios and they STILL
weren't tuned because the SQL reused in that 99.999% success rate was
simply bad to begin with. 99,999 calls to one bad SQL statement
doesn't represent tuning to me, it represents poor methodology. Truly
the only way to tune Oracle is to determine WHERE the bottleneck is
(and this doesn't happen using hit ratios) and correcting that
bottleneck, be it SQL*Net to client/SQL*Net from client times to
poorly performing queries. Cary Millsap has the correct approach; I'm
sorry to say you don't.
He even thanks Digital!


I worked for Digital Rdb - the KODA group; and joined Oracle when they
bought the Digital rdbms business and as such I thank Digital for
doing that: having access to the Rdb code; which SQL server borrowed
heavily. I added index only tables to Rdb and later to Oracle kernel.
Of course your mother helped me do that; she s*** nicely!


You joined Oracle because Oracle bought out the division you worked
for. So, Oracle didn't choose you from the many to be among the few,
you were included in the package price paid for an Oracle acquisition.
This is making much more sense now.
Jeez, makes me
nostalgic.


see a doctor; perhaps the rags slipped! got the OMLET treatment or
both!


We have been getting the OMLET treatment, from its creator, and it's
not been pleasant nor fruitful. It's been juvenile, sophomoric,
obscene, degrading and useless. If you cannot behave as an adult,
then leave. You originally attacked Howard J. Rogers, then myself,
then Daniel Morgan, then Joel Gary and, finally, Mladen Gogala. Any
post any member of this group of individuals makes you see fit to
insult, in a crude and inappropriate manner. This needs to stop, now.
The regulars in comp.databases.oracle.server, and any other Oracle
newsgroup, will thank you for it.

Note to all Oracle professionals: re-read the manuals for new
versions, and pay attention to people who point out errors.


I guess Oracle profs are capable of do that by themselves. Do not
insult them or their intel. with your crab.


Joel didn't insult anyone; it's you who's insulting. And, if anyone
is posting crap to this newsgroup, it's you, Amjad. No one else has
stooped to your level of attack, as we all know better. Never argue
with an idiot; he brings you down to his level then beats you with
experience. You're trying just that, Amjad, and no one is taking the
bait. Leave now, while you still have a shred (at most) of decency
left. You have no reputation, as you killed that with your continued
harassment of the newsgroup members.
David Fitzjarrell

jg

Jul 20 '05 #24

P: n/a
fi*********@cox.net (David Fitzjarrell) wrote in message news:<97**************************@posting.google. com>...
om***@omlet.org wrote in message news:<dc*************************@posting.google.c om>...
jo********@home.com (Joel Garry) wrote in message

"In general, if recursive calls is greater than 4 per process, the
data dictionary should be optimized and segments should be rebuilt
with storage clauses to have a few large extents. "
- OraclE 9I Performance Tuning WITH OMLET [
This is a product for 8i,9i,10g! So your comments are misplaced. Self
tuning; local management, undo segments and db_cache_size are not as
widely used as you think. Of course, you are entitled to your opinion;
you write books that you sell for $100 and as such you better be
giving people their money's worth.


If you speak of Howard J. Rogers his books DO provide people with
their money's worth, in many cases ten times over. Unlike you, who
can only write degrading and obscene verbiage to those who, with good
reason, disagree with your misguided methodology.


I seriously doubt it! apart from my misguided tech. many sections of
Jo Lewis book was taken verbatim from Metalink postings. Before
writing a book, tell me how many hours you worked as an oncall dba!
how many production databases you have recovered! how many databases
you constructed while others are watching, ....etc.

The book is about OMLET and tuning Oracle with OMLET; as such, only
queries that made it into a version are reflected in the book. It is
not targeting general audience.

You're still using unreliable hit ratios;


Back to Gaja's bullshit; A high ratio by itself may hide two large
qtys when divided; OK! Great; Bigger than Texas!

Publish few papers about this; try CACM as I am an associate editor
for it! I would publish your great works!

At the end; a bad hit ratio means you have a serious problem. your
logical reads are low compared to physical reads. Again LOW LOW LOW
LOW LOW LOW LOW LOW LOW LOW LOW ratio; you get it! you big jumble Q of
of fat to meat! You must admit that is low ratio; and that is a
problem; so get off your feet; leave your computer; play a little with
your tonka; and convince yourself that LOW ratios are really terrible.
Consult your mother and see what she says?

A 47 years old female like you should be having good days and happy
nights. You are getting NONE. I forgot; you may converted to a male.
Anyhow it always help to look for the Butt-neck.
I wouldn't begin to consider
that tuning Oracle. Hit ratios hide information; all ratios do. This
percentage, that percentage ... it's all fluff and nonsense. I've
seen databases with 99.999% db buffer cache hit ratios and they STILL
weren't tuned because the SQL reused in that 99.999% success rate was
simply bad to begin with. 99,999 calls to one bad SQL statement
doesn't represent tuning to me, it represents poor methodology. Truly
the only way to tune Oracle is to determine WHERE the bottleneck is
(and this doesn't happen using hit ratios) and correcting that
bottleneck, be it SQL*Net to client/SQL*Net from client times to
poorly performing queries. Cary Millsap has the correct approach; I'm
sorry to say you don't.
He even thanks Digital!
I worked for Digital Rdb - the KODA group; and joined Oracle when they
bought the Digital rdbms business and as such I thank Digital for
doing that: having access to the Rdb code; which SQL server borrowed
heavily. I added index only tables to Rdb and later to Oracle kernel.
Of course your mother helped me do that; she s*** nicely!


You joined Oracle because Oracle bought out the division you worked
for. So, Oracle didn't choose you from the many to be among the few,
you were included in the package price paid for an Oracle acquisition.
This is making much more sense now.


Actually half the group joined Microsoft; half stayed and two joined
Sybase. Those who joined Microsoft hit the gold pot as they released
Windows 95. I joined Oracle for options and incentives and the chance
to read the Oracle code.
OMLET is the fruit;
You originally attacked Howard J. Rogers, then myself,
then Daniel Morgan, then Joel Gary and, finally, Mladen Gogala. Any
the Soprano's mother-kickers gang!
post any member of this group of individuals makes you see fit to
insult, in a crude and inappropriate manner.


The posts are hardly anything compared to what you hear around the
corner in north Dallas. Try Irvine?!

Well yea! you worked in A.Carter buildings and you were not in Sabre
in South Lake. Are you really getting that old. I should pay you some
respect.
Jul 20 '05 #25

P: n/a
om***@omlet.org wrote in message news:<dc*************************@posting.google.c om>...
jo********@home.com (Joel Garry) wrote in message

"In general, if recursive calls is greater than 4 per process, the
data dictionary should be optimized and segments should be rebuilt
with storage clauses to have a few large extents. "
- OraclE 9I Performance Tuning WITH OMLET [
This is a product for 8i,9i,10g! So your comments are misplaced. Self
tuning; local management, undo segments and db_cache_size are not as
widely used as you think. Of course, you are entitled to your opinion;
you write books that you sell for $100 and as such you better be
giving people their money's worth.


What makes you think I write books? I work, people give me money.
They're happy, they keep giving me money and I keep working. This has
worked for me since the 11/34.

The book is about OMLET and tuning Oracle with OMLET; as such, only
queries that made it into a version are reflected in the book. It is
not targeting general audience.
Well, is the book targeting general audience that tunes Oracle with
OMLET? Whatever, it has some long-discredited myths in it, mixed in
with what may or may not be good advice. But there isn't a trivial
amount of bad advice, which makes all of it look bad.

For example, you make a big deal about ratio tuning and keeping ratios
above targetted amounts. One program that can set a ratio to any
desired value doesn't prove the ratio is useless; but many other
demonstrations along with it can, and have. Whenever Oracle releases
something new, a lot of people take the information Oracle gives out
and propagate it, with varying amounts of degradation in the process.
Some of the ratio tuning ideas were worthwhile when kept within
context, such as watching to see if a ratio changes in a system that
has been stable over time, however, the context is lost when such
ratio tuning is done as an end in itself. Your product is based on
sand.

Ratio tuning may have been considered state-of-the-art tuning a decade
ago. Many experts who have stayed leading edge realized the problems
and myths that were being propagated are wrong, and have corrected, or
at least changed, their methodology. Unfortunately, it appears your
product congealed the problems, and you've been unable to adapt it.
Simply looking at the docs, the product looks pretty, but there is a
melange of myths that you are now unable to
unravel because there is no facility for feeding back new methodology.
So you are frustrated and acting out in newsgroups.

If any product claims to be self-tuning or automatically tuning or
even just giving tuning advice, it must have a way to penetrate the
abstraction layers to account for situations where it simply doesn't
work, or works for the wrong reasons. By being authoritative without
proper, testable explanation, a product will be worse than useless.

And having something around for years and not fixing the grammar looks
pretty cheap too.
He even thanks Digital!
I worked for Digital Rdb - the KODA group; and joined Oracle when they
bought the Digital rdbms business and as such I thank Digital for
doing that: having access to the Rdb code; which SQL server borrowed
heavily. I added index only tables to Rdb and later to Oracle kernel.


So your expertise is hashing, or hashish? In case you forgot,
http://en.wikipedia.org/wiki/Digital...nt_Corporation
Of course your mother helped me do that; she s*** nicely!
Please keep your necrophilia out of the public eye.
Jeez, makes me
nostalgic.
see a doctor; perhaps the rags slipped! got the OMLET treatment or
both!


Well, I used to think that Rdb was better than Oracle, but you may be
convincing me I was wrong.

Note to all Oracle professionals: re-read the manuals for new
versions, and pay attention to people who point out errors.


I guess Oracle profs are capable of do that by themselves. Do not
insult them or their intel. with your crab.


Well, of course I wasn't referring to you and your own manual. Not.

Go see a doctor about those parasites.

jg
--
@home.com is bogus.
"Crabs? I thought they were furry little spiders." - Zap.
Jul 20 '05 #26

P: n/a
In article <91**************************@posting.google.com >, joel-
ga***@home.com says...
I work, people give me money.
They're happy, they keep giving me money and I keep working. This has
worked for me since the 11/34.


I wish the kids growing up today (and for the last 10 years) understood
how that worked :)

--
--
sp*********@rrohio.com
(Remove 999 to reply to me)
Jul 20 '05 #27

P: n/a
om***@omlet.org wrote in message news:<dc**************************@posting.google. com>...

I seriously doubt it! apart from my misguided tech. many sections of
Jo Lewis book was taken verbatim from Metalink postings. Before
writing a book, tell me how many hours you worked as an oncall dba!
how many production databases you have recovered! how many databases
you constructed while others are watching, ....etc.
You must have missed that Mr. Lewis made the postings...

The posts are hardly anything compared to what you hear around the
corner in north Dallas. Try Irvine?!


What is in Irvine?

jg
--
@home.com is bogus.
Just because something is patented, doesn't mean it is a good idea.
http://patft.uspto.gov/netacgi/nph-P...S=PN/6,681,985
Jul 20 '05 #28

This discussion thread is closed

Replies have been disabled for this discussion.