Hi friends,
I am running 8.1.6 on an UNIX machine.
I am using set transaction for deleting (or selecting too) records from a table which has around 50,000 records. It is taking abnormally long time.
I have 7 rollback segments, one of 20 mb and the other 6 of 4 mb. I am using the 20mb segment for these transasctions and there are no other transactions going on. What may be the reason in these delays?
Thanks
manjunath