Thanks Helen

Sorry about the RAM comment, what I meant was HDD space :)

No one has run the gfix on these databases, I suspect it is a setting in
one of the components we use to either create the database or to pump
data between databases. I will look into it.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Helen Borrie wrote:

>At 11:41 AM 29/03/2005 +1200, you wrote:
>
>
>
>>Hi Sandor
>>
>>Sorry about the delay in replying, we had a long weekend here in New
>>Zealand. I have no idea why this is set or indeed where this is set.
>>Where is this configured? Our DB is certainly has a number of edits
>>taking place, we have plenty of RAM as well so this setting makes no sense.
>>
>>
>
>RAM isn't in the picture. By default, page space is allocated on the basis
>of leaving "headspace" for updates that might cause rows on the page to
>increase slightly in size. It would make the difference between "updating
>in place" and needing to allocate a new page.
>
>Someone has run the gfix utility with the -use full switch. To return to
>the condition where space is reserved, perform a database shutdown as
>sysdba and run gfix -use reserve path/to/database
>
>./hb
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>