Re: Calculating Number of Transactions

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 18 Dec 2000 10:40:22 -0000
Message-ID: <91kpim$lk6$1@soap.pipex.net>

First see if your database conforms to the 'rule of four'

one rbs for every 4 concurrent users, with at least 2 and no more than 50 rollback segements in total.

so 100 concurrent users 25 rollback segements. 500 users 50.

This should be a good start.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<edjjnr_at_my-deja.com> wrote in message news:91dnok$ae2$1_at_nnrp1.deja.com...


> Hello,

>

> I am thrust into a situation here where I need to recreate rollback

> segments for one database.  I am a newbie and after reading countless of

> information it all points back trying to figure out how many

> transactions occur in one given day.  I know I have contention after

> running a small script.  So, is there a view I can look at to help me

> determine how many transactions are going on in one given day.  Or at

> least point me in the right direction to getting some information to

> help me.

>

> Ed

>

>

> Sent via Deja.com

> http://www.deja.com/

Received on Mon Dec 18 2000 - 04:40:22 CST