Re: SET TRANSACTION .. didn't work

From: Vadim Grepan <kezal_at_mail.ru>
Date: Mon, 20 Nov 2000 12:57:14 +0300
Message-ID: <3A18F57A.9599D309@mail.ru>

Hello!

Jonathan Lewis wrote:

> Looking more closely, it gets worse -
>
> >> > >ORA-01237: cannot extend datafile 6
> >> > >ORA-01110: data file 6: '/dsk1/s1/oradata/EL83/rbs01.dbf'
> >> > >ORA-19502: write error on file "/dsk1/s1/oradata/EL83/rbs01.dbf",
> >> > >blockno 2419
>
> It looks as if your filesystem was unable to meet the
> demand for a file autoextend (even though it was
> quite a small file)
>
> It is interesting that 'create intermedia index' generates
> so much rollback - the 'extensibility option' isn't quite
> as transparent as one might hope - 'create index' for
> normal data doesn't require very much rollback at all.
>
> I haven't used the context option since 7.3, but there
> was some ctxsys parameter that could be used to
> change the amount of memory allocated for building
> context indexes - if this is still possible for Intermedia
> then a larger in-memory build might reduce the amount
> of rollback generated on the build, since I guess the
> rollback appears from updates as index sections are
> merged.

By default ctxsys uses large enough memory size (DEFAULT_INDEX_MEMORY). In my case it equals around 12M

>
>
> Also, is there a 'nologging' option with intermedia
> index build ? For normal data, this is irrelevant for
> rollback purposes, but perhaps for intermedia it
> would have some side-effect on rollback.
>

Unfortunatly, there is no available 'nologging' option with intermedia index.
OTOH I think It may be useful to create tablespace for indexes including 'nologging'
( CREATE TABLESPACE imi_index ... NOLOGGING)

>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
>
> Publishers: Addison Wesley Longman
> Book bound date: 8th Dec 2000
> See a first review at:
> http://www.ixora.com.au/resources/index.htm#practical_8i
>
> Vadim Grepan wrote in message <3A139B49.1464173C_at_mail.ru>...
> >Hello Mark!

 Thanks. Of course I've seen this error message too :) I need real LARGE
> >"temporary"rollback which I'll drop after creating index. If I increase
> >"permanent" rollback datafile I cannot decrease it back.
> >
> >Rgds, Vadim Grepan
> >----------------------------
> >Moscow, Russia
> >
> >

Thanks for your advices, they are really useful.

Rgds, Vadim Grepan

---

Moscow, Russia Received on Mon Nov 20 2000 - 03:57:14 CST