RE: Transactions waiting for Lock on Rollback Segments

Create more rollback segments.

-----Original Message-----
From: VIVEK_SHARMA [mailto:vivek_sharma_at_inf.com] Sent: Tuesday, May 16, 2000 3:04 AM
To: Multiple recipients of list ORACLE-L Subject: Transactions waiting for Lock on Rollback Segments

CASE - Benchmarking Application on a Specific Machine E 6.5 K SunOS 5.6

AIM - To pass 50,000 OLTP Transactions in 1 Hour using 2500 Oracle sessions
(with respective Unix users)

HARDWARE setup - Total 3 E6.5K machines = 2 machines Containing APP , 1 machine Containing DB
20 GB RAM in each , 18 CPUs in each ,

DATABASE Setup - Oracle 7.3.4 , 160 Rollback Segments Each with - EXTENT size 512 K MINEXTENTS 20 , OPTIMAL 10M

PROBLEM Started the firing off of OLTP transactions . Till Completion of 10 Thousand (roughly) OLTP Transactions , there were NO WAIT for Locks on Any Rollback Segment

After Completion there seemed about 8-10 Transactions WAITING for Lock on Each Rollback segment

ADVISE PLEASE

-- 
Author: VIVEK_SHARMA
  INET: vivek_sharma_at_inf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).