Wishing you a very happy and prosperous new year. Can anyone tell me, that one rollback segment can handle how many concurrent transactions? I know that oracle keeps the transaction table in the header block of segment's. I have taken the system dump of this block, but, couldn't understand where to see for concurrent transaction value in the dump file. Can anyone have any idea how to find out the value? Thanks you. -- Best Regards, Syed Jaffar Hussain OCP 8i & 9i DBA, Banque Saudi Fransi, Saudi Arabia http://jaffardba.blogspot.com/ ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l