Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i tunning

Re: Oracle 9i tunning

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 24 Jun 2002 19:41:42 +0200
Message-ID: <k6mehu8lfr48h3pm7rha15f2tremcnnci9@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 - 12:41:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US