Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Opinions for this storage parameters.

Opinions for this storage parameters.

From: Norman Dunbar <>
Date: Wed, 3 Jul 2002 14:16:03 +0100
Message-ID: <>

Good evening Richard,

you must be 'down under' then ? (Especially if you're with BigPond !) Wish I was.

<begin another rant>

Talking of the unobtainable Shangri-La situation, I have a customer in the US of A who is a DBA. (Allegedly !). He assures me that exporting his database every night with compress=y, dropping everything and re-importing causes great improvements in performance, after all, all the data is now in one chunk on disc isn't it.

I have lost count of the number of times I have told him, sent him docs, pointed him at Oracle notes, this newsgroup, books everything - but he still claims to know better. He has carried out performance tests and obtained results which show the difference. He is, of course, never able to produce said figures ...... I hate dealing with this guy - every Oracle myth under the sun - he is sure that it is all true.

He always send me dumps with compressed extents. Bang goes my lovingly crafted tablespaces in one go. It may only be a test database, and - shall we say, not highly tuned - but it is MINE and he broke it.
<end another rant>

I never set anything other than zero for PCTINCREASE as that is what I was taught on my DBA course many years ago, and because I've had it sneak up and bite me on an inherited database. I soon got it fixed. The errors go something like 'unable to allocate 64KB in tablespace ... no space left' but the free space shows clearly that there is indeed 64KB (in one free chunk) but what it is really after is some huge amount because of PCTINCREASE being at 50 still. Not helpful, but if I get those symptoms, I always check DBA_TABLESPACES for details of PCTINCREASE. I suspect, as you point out, that we'll never ever get to be in a situation where we have it working the way we want it.


PS. Who Leyton Hewitt ?
I only do sport with engines :o)

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
Tel: 0113 289 6265
Fax: 0113 289 3146
Received on Wed Jul 03 2002 - 08:16:03 CDT

Original text of this message