Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RBS waits

RBS waits

From: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 7 Aug 2002 06:03:10 -0700
Message-ID: <7ca2852.0208070503.28e88693@posting.google.com>


Hi
Te following is the status of my database. It has been running for 3 days now. Though i have 55 rollback segments , i always seem to have contention for it. transactions_per_rollback_segment = 10, and the rollback segments have initial 5m next 5m minextents 20. There are about 100 users connected at any point of time and around 30 - 40 concurrent transactions. Where is the problem?

SQL> select * from v$waitstat;

CLASS                   COUNT       TIME

------------------ ---------- ----------
data block 18024355 24968386 sort block 0 0 save undo block 0 0 segment header 93 665 save undo header 0 0 free list 0 0 extent map 0 0 bitmap block 0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 CLASS COUNT TIME
------------------ ---------- ----------
system undo block 0 0 undo header 1827 121484 undo block 13504 43563

Please help.

Ashok Received on Wed Aug 07 2002 - 08:03:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US