Printable View
Sorry, Urgent because I am supposed to do some basic sizing structures on this statistics, table growth etc. and I could not even start due to this.. Anyway thanks all for your time ..
So just to summarize can I say that I got avg_row_len 0 because there were 0 rows ? ( frankly I wasn't aware of this !)
Thanks..
MH - If you don't understand it, it could mean the the db is ****ed. It might have been urgent.
I dont understand... so common sense a thread with 11 posts!
If you are given a table with 0 rows how do you calculate the average row length?
Let´s do some mathematics
If there were 10 rows I would simply
sum(row_length)/num_rows
if num_rows is 0 what we get?
infinity
I disagree, if that is your only guidlinde for a fawked database, your job may be in jeapordy.Quote:
Originally posted by DaPi
MH - If you don't understand it, it could mean the the db is ****ed. It might have been urgent.
MH
MH - If I don't understand, I worry. I think that has helped me to keep my job!
You must spend a LOT of time worrying then because I have yet to met anyone that undestands all things available in Oracle. Curios, yes, worry, no.
I will end this verbal tit for tat now and wish you all good holiday cheer.
MH