Originally posted by prakashs43
Hi ,

I could imagine value for transactions_per_rollback_segment but what could be the value for transaction prameter at any point of time .
One way to figure that out (in a big database) is to shedule a job run every 5' minute within say 24 hours. The job would execute a function which returns count(*) from v$transaction; and inserts the value amount in some temp table, call it T1. Then you can select avg(amount) from T1; This would give you the approximate/avg amount of transactions at a given point of time. You don't have to run the function every 5' in 24 hours. You may as well run it every minute within 2 hours or so.