Rollback Segment Size Testing.

2002-11-12 Thread chao_ping
hi, list friends: I am interested in that topic:http://www.ioug.org/ioug_s/repository_pkg.doc?v_tech_content_dtl_phy_id=7666 I am also considering whether too large rbs segment size does have adverse impact on database performance. In my production (OLTP) i configured rbs to be

Re: Rollback Segment Size Testing.

2002-11-12 Thread Tim Gorman
Zhu Chao, Please be aware that rollback segments serve two major purposes: * recover individual transactions (i.e. rollback) * provide before-image information for read-consistency The information you are getting from V$ROLLSTAT and STATSPACK is accurate at measuring the first purpose