Re: Oracle 9i tunning

Joe wrote:

> Wow, judging by the tone of the two responses of my post, I have decided
> that being an Oracle DBA must be *way* too stressful for me to handle. I
> think SQL server is the correct choice for me.
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:k6mehu8lfr48h3pm7rha15f2tremcnnci9_at_4ax.com...
> > On Mon, 24 Jun 2002 16:38:39 GMT, "Joe" <joegenshlea_at_attbi.com> wrote:
> >
> > >Oh yeah...
> > >
> > >80 Million rows may be nothing to Oracle but...
> > >
> > >In the last job I had our fact table was 3 million rows and with the
> default
> > >Oracle 8i installation. I was constantly getting errors when executing
> DML
> > >SQL (It's been over a year so forgive me I am not entirely accurate with
> the
> > >syntax). The errors had to do with Snapshot too old, and failing to
> extend
> > >tablepace extents, etc...and we had a DBA with 15 years experience
> (mostly
> > >OLTP experience albeit). We solved these issues by tweeking the
> > >tablespaces, rollback segments,etc. From my experience with this
> situation,
> > >I decided to mess around with the configuration of the insallation in my
> > >test environment.
> > >
> > >By the way, I am a one man shop, my background is in Economics not
> Computer
> > >Science or anything of the sort, so be kind! Most everything I know about
> > >Oracle I've picked up doing in a research and analysis capacity and also
> > >what I've gleaned from "Oracle 8i Data Warehousing" by Dodge and Gorman.
> > >
> > >Joe
> > >
> > First of all it strikes me that so many people are incapable to grasp
> > the correct orthography of the word 'tuning', with *one* n.
> > Secondly, if you only think a *little*, you could know a
> > sort_area_size of 1 G for a system with 2 G is clearly outrageous and
> > ridiculous. Sort_area_size is a per process limit, if you are not
> > running dedicated server the sort_area_siz is NOT in the SGA, so
> > evidently, the disk lamp in your server must be continually on,
> > because you force the server to page *all the time*.
> >
> > I would recommend to start reading Designing Oracle for Performance,
> > on page 1, before you even consider datawarehousing.
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address

I agree. The comment above in this thread "I was constantly getting errors when executing DML" is a clear indication of why it is wise to caution people not to jump into Oracle and assume it is SQL Server, or any other RDBMS product for that matter.

I've never had it happen to me in over ten years. But then that might be because I didn't assume I could use the product without learning it. Just because you can fly a Cesna does not mean you can fly a 747 without additional training. And the same applies here. They may both fly but they are not the same. (and please don't assume that the preceding analogy includes some subtle or not so subtle value judgement ... it does not).

Daniel Morgan Received on Mon Jun 24 2002 - 15:04:13 CDT