Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle rollback segment problem?
In article <7mne8o$g4q$1_at_nnrp1.deja.com>,
vladoh_at_my-deja.com wrote:
> I have this problem with Oracle7.3 I use three applications, from
which
> two are only selecting data and one is also inserting data (using
> transactions). My public rollback segment has set optimal size to
30MB.
> But sometimes rollback segment grows (to 800MB and more) and doesn't
> drops again to 30MB. I also use triggers that delete, update and also
> insert data into some tables. I made some tests and discovered, that
> problem is maybe with running client programs (but the testing is in
> progress yet... so the problem could be somewhere else). When clients
> are started before inserter (maybe also after.. i test it now), the
> rollback segment is growing... how can i resolve this?
>
> thanx
> Vladimir Hirner
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Vladimir :
rbs shrink to optimal size only when certain condition are met. check
oracle reference book to see whether those condition are met. also you
can use alter rbs statement to shrink rbs.
Ted Chyn
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 12:47:59 CDT