Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i tunning
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