Re: rollback segments and performance

Check the number of transactions using your RBS. You should have 1 RBS per 4 transactions.

Also what are you doing...
If it's a lot of inserts consider the BLOCK size of you database and what your inserting there may be wasted space inside each extent. If your doing a lot of batch processing try larger RBS with less egements like below.

Otherwise increase the initial exent (and all extents) To match the size of the data that's going into it...

The following query is useful:

select n.name,s.extents,s.rssize,s.optsize, s.hwmsize,s.xacts,s.status
from v$rollname n, v$rollstat s
WHERE n.usn=s.usn;

The xacts shows how many transactions are using your RBS.

1 Last thing is what about your RBS tablespaces.... Did you check that these are OK.

> STORAGE(INITIAL 25m
> NEXT 25m
> MINEXTENTS 1
> MAXEXTENTS whatever
> OPTIMAL 25M);
>
>
>

Cheers!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 06 1999 - 07:58:21 CDT