| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Transactions waiting for Lock on Rollback Segments
Freelists are meant to be created for the tables, hence you should
not try to create it on rollback segments. Instead try to increase
the freelists on the tables which participate in online transactions.
Regards.
Bhat
-----Original Message-----
From: VIVEK_SHARMA [mailto:vivek_sharma_at_inf.com]
Sent: Wednesday, May 17, 2000 2:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Transactions waiting for Lock on Rollback Segments
Banking product Application - Bancs2000
On Oracle 7.3.4.5.0 FREELISTS for ROLLBACK segments NOT allowed . Allowed only for Tables & indexes
SQL> create public rollback segment bm1_temp_test1
2 tablespace tba_roll
3 storage (initial 512K next 512K maxextents 121 freelists 50);
storage (initial 512K next 512K maxextents 121 freelists 50)
*
ERROR at line 3:
ADVICE PLEASE
-----Original Message----- From: Gogala, Mladen [SMTP:MGogala_at_oxhp.com] Sent: Tuesday, May 16, 2000 9:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: Transactions waiting for Lock on RollbackSegments
Create more rollback segments.
> -----Original Message-----
> From: Chris Kempster [SMTP:chris_kempster_at_hotmail.com]
> Sent: Tuesday, May 16, 2000 10:28 PM
> To: VIVEK_SHARMA
> Subject: Re: Transactions waiting for Lock on Rollback Segments
>
>
> Hi there, I was wondering what the name of the bench-marking application
> you were using is called?
>
> hmmm... check free-lists on the segments, it sounds like a concurrency
> issue.
>
> >From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Transactions waiting for Lock on Rollback Segments
> >Date: Mon, 15 May 2000 23:04:28 -0800
> >
> >
> >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).
> >
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
-- 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 mayReceived on Wed May 17 2000 - 01:20:16 CDT
 |
 |