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
Received on Mon Jun 24 2002 - 13:04:43 CDT
