!! Please do not post Off Topic to this List !!
What is 2lakh rows? Never heard of that number metric.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978)
!! Please do not post Off Topic to this List !!
200, (two hundred thousand:)
English is indeed an great language as it changes in
its nuances as geographic locations change ..its
friday finally!
srinivas for estimating rollback, consider taking
snapshots of v$rollstat.waits (specified in
!! Please do not post Off Topic to this List !!
200,000 @ 50 bytes, I would say just over 40Mb of rollback.
Not sure how you came up with 21akh to 200,000 :)
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their
!! Please do not post Off Topic to this List !!
Hi lists
can anybody post me how much rollback (approx in bytes/kb/mb) will be
generated if I delete my table that has 2 lakh rows.
the avg row len is 50.
often The query is getting failed due to the error unable to extend the
rollback segment.