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

Home -> Community -> Mailing Lists -> Oracle-L -> Transactions waiting for Lock on Rollback Segments

Transactions waiting for Lock on Rollback Segments

From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
Date: Tue, 16 May 2000 11:14:28 +0530
Message-Id: <10498.105712@fatcity.com> 





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

Received on Tue May 16 2000 - 00:44:28 CDT












Original text of this message













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