Hi dba!
Can anyone say to me if I'm rigth about the following Thread?
The biggest table of my DB is about 300 M with an average record of 70 bytes.
I'm re-analizing my DB structure and I'm studing riollback segments creation.
I know that rolback segments should be at least 10% of the biggest table.
Do you think that 4 rollback segtments of 30 M with those storage parameters (initial 256K, next 256K optimal 2M) could be enough considering that sometimes there are delete of about 150.000 records?
150.000 x 70 bytes is about 10 M - IS THIS CORRECT?
What do you think?
THANX